Re: Multiple Database or Full Backup

From: Top Cat (anonymous_at_discussions.microsoft.com)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 13:38:43 -0800

I can! In fact I am doing just that as I write this. I
had hoped there would be a way of doing a full backup and
a full restore bring over security intact, etc., but I
hearing there isn't. Seems rather manual this way!

Thanks!!

>-----Original Message-----
>can you take SQL off line, copy database files to new
server and attach
>databases?
>
>"Top Cat" <anonymous@discussions.microsoft.com> wrote in
message
>news:10b9501c412ad$961d95e0$a601280a@phx.gbl...
>> I can't see a way of backing up all databases at once,
or
>> the ability to choose multiple databases to back up. I
am
>> in the process of moving a bunch of databases from one
>> laptop to another and I would rather not do it one at a
>> time.
>>
>> Ideas?
>>
>> Thanks in advance!!
>
>
>.
>

Relevant Pages

  • Re: Database Maintenance Plan Problems
    ... the system databases such ... Deleted by Maintenance Plan ... >>A maintenance plan job to backup transaction logs ... >>Backup can not be performed on this database. ...
    (microsoft.public.sqlserver.server)
  • Re: Database Maintenance Plan Problems
    ... >may want to create separate maintenance plans for the system databases such ... Expired Transaction Log Backups May Not Be Deleted by Maintenance Plan ... >A maintenance plan job to backup transaction logs may fail. ...
    (microsoft.public.sqlserver.server)
  • Re: database log truncated, transaction log backup job failed
    ... I got it fixed by selecting the specific databases in the Maintenance plan. ... step that runs the transaction log dump". ... Unfortunately, I recall now, that maintenance plans do a good job of ... it seems like the only time you need to backup the transaction logs is ...
    (microsoft.public.sqlserver.tools)
  • Re: Backup SBS 2003
    ... >> backup your system successfully. ... We shouldn't backup the Exchange log files since we are backing ... With the databases, you can decide to move the Exchange ...
    (microsoft.public.windows.server.sbs)
  • Re: Automating SQL Service start and shut down
    ... The best option would be using the Transact-SQL BACKUP command. ... make sure that you know how to restore/recover your data and your databases. ... Grab a tape, restore the files to a different server, and try to get the files restored. ... Moving SQL Server databases to a new location with Detach/Attach ...
    (microsoft.public.sqlserver.setup)
Loading