Posted by Erland Sommarskog on 12/10/05 12:53

sql guy123 (stoppal@hotmail.com) writes:
> I need some assistence here.
>
> I have two servers. One with MS SQL 2000 Standard edition and MSDE(MS
> desktop engine).
>
> I need to sync my databases nightly, as a backup.
>
> Is there a cheap software that will do this? I don't want to just
> backup the entire databases files b/c they are large and I'm
> transfering them over DSL.
>
> I was thinking transaction logging, but I'm not sure. Is there a easy
> way to do this?


You could indeed back up the transaction log, bring that over the network,
and then apply that log on the other database.

The catch here is that you must run with full or bulk_logged recovery, and
you must never truncate the log on the source server. If you do so, you
will need to bring a full backup over the net at this point.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Database security (crosspost)
• Prev in forum: Re: How to copy data from backup or data files to new SQL installation?
• Thread view: Re: Sync to databases nightly with BLOB data

[Reply to this message]