By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,576 Members | 1,399 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,576 IT Pros & Developers. It's quick & easy.

Sync to databases nightly with BLOB data

P: n/a
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.

Dec 9 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
sql guy123 (st*****@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 10 '05 #2

P: n/a
How can I learn to do this? Is there a chance for data corruption?

thank you

Dec 12 '05 #3

P: n/a
Does any one have a good source to accomplish this?

thanks

Dec 12 '05 #4

P: n/a
sql guy123 (st*****@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 12 '05 #5

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

thank you

Dec 12 '05 #6

P: n/a
sql guy123 (st*****@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 13 '05 #7

P: n/a
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.

Dec 14 '05 #8

P: n/a
sql guy123 (st*****@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 14 '05 #9

P: n/a
ok
thanks

Dec 15 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.