Backing up related databases

25 Apr 2006 1:41 PM

gabi

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!

25 Apr 2006 1:50 PM

Keith Kratochvil

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

Show quote

"gabi" <g***@discussions.microsoft.com> wrote in message
news:B89C844E-3820-48FE-B20E-F1FB2EAA6BED@microsoft.com...
>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!
>