Re: Multiple Database or Full Backup

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 18:26:21 +0100

I had to restore from a bunch of backup files in a directory a while ago, so I write a stored proc which loops
the files and do the restore for each file. You can have a similar loop to perform the backup as well. But you
really need some TSQL programming skill to write the loop to perform the backups, and you probably want to
verify my code which does the restore:

http://www.karaszi.com/sqlserver/util_restore_all_in_file.asp 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Top Cat" <anonymous@discussions.microsoft.com> wrote in message
news:efbd01c412b1$8bc40fd0$a001280a@phx.gbl...
> 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: Off-Site Duplicate Server Setup
    ... the normal process for databases is backing up the ... backup the backup files to tape/disk/offline/whatever. ... Which is good until restoration when you need to restore the original, ... likely have a live replicated server available. ...
    (microsoft.public.windows.server.general)
  • Re: Off-Site Duplicate Server Setup
    ... the normal process for databases is backing up the ... backup the backup files to tape/disk/offline/whatever. ... Which is good until restoration when you need to restore the original, ... likely have a live replicated server available. ...
    (microsoft.public.windows.server.setup)
  • Re: Full Backup and restore
    ... Since i was looking for answer to my question related to backup and restore ... Then add the ContentDB to SharePoint using Central Administration or stsadm. ... But, in addition to backing up the content databases in SQL, and backing ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Deleted log file
    ... You'll probably have to restore from backup. ... Run the following command from the ... that means the databases is inconsistent and you ...
    (microsoft.public.exchange2000.general)
  • Re: Full Backup and restore
    ... did you just say that they should restore the content ... But, in addition to backing up the content databases in SQL, and backing up ... the sharepoint specific files on the sharepoint server, ... sharepoint's own backup capabilities. ...
    (microsoft.public.sharepoint.portalserver)