Sync to databases nightly with BLOB data

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?

I don't know how to accomplish this task.

PLEASE HELP.

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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

How can I learn to do this?  Is there a chance for data corruption?

thank you

Does any one have a good source to accomplish this?

thanks

sql guy123 (stoppal@hotmail.com)  writes:
> How can I learn to do this?

Books Online is a good place to start. More precisely the Administering
SQL Server->Backing Up and Restoring Databases-

> Is there a chance for data corruption?

No.

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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

I've heard of books online, but where is it, what is it?  Is it a
website?  What is the web address.

thank you

sql guy123 (stoppal@hotmail.com)  writes:
> I've heard of books online, but where is it, what is it?  Is it a
> website?  What is the web address.

No, it is not a web site, it's on your hard disk. And if you can't find it,
read all of this post.

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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

I see, but once I get to the webpage and try to download the file, it
states it's unavailable.  No worries, I track it down.

Thank you.

sql guy123 (stoppal@hotmail.com)  writes:
> I see, but once I get to the webpage and try to download the file, it
> states it's unavailable.  No worries, I track it down.

That's bad. I will alert some people. I the mean time, check out the SQL
Server program group from the Start button.


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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

ok
thanks