Re: Backing up related databases

Have you considered using the following Transact-SQL command:
BACKUP

You can use it to backup your entire database. For example:
BACKUP DATABASE foo TO DISK = 'x:\foo.bak' WITH INIT

There is lots more information on this subject (including how to RESTORE
your database) within SQL Server Books Online (look in the SQL Server
program group for Books Online).

--
Keith Kratochvil


"gabi" <gabi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B89C844E-3820-48FE-B20E-F1FB2EAA6BED@xxxxxxxxxxxxxxxx
I have to backup two related databases in two different SQL servers. I
understand that the way to go is to use marked transactions. So my first
question is if this is the only way to do it and second is there a way to
create marked transaction logs using Enterprise Manager, not SQL scripts?
I
am using SQL Server 2000.

Thanks!



.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... with volume Shadow Copy error 800423f4. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
  • Re: Start SQLServerAgent job Synchronously
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.server)
  • Re: Start SQLServerAgent job Synchronously
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.programming)
  • Re: "Best Practices" way to distribute MSDE
    ... > Restore a users's selected backup. ... for dayly house-keeping I do usually provide scripted job for database ... that file copy operation (not SQL Server backup!) can be performed.. ... my personala advice is to perform dayly house-keeping actions ...
    (microsoft.public.sqlserver.msde)
  • Re: NT Backup Causes Server to Hang
    ... Thanks for using the SBS newsgroup. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
Quantcast