Posted by sql guy123 on 12/09/05 22:22

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.

• Next in forum: Re: Using muliple smaller SPs and Functions better than using 1 big SP?
• Prev in forum: Re: Please help the performance issue.
• Thread view: Sync to databases nightly with BLOB data

[Reply to this message]