471,049 Members | 1,396 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

Looking for db replication tool

I'd like to use log shipping to provide warm backup to some production
MSFT SQL 2000 servers. I know that I can write something to ship logs
but I'm looking for a complete solution that would take a while to
write. Prefer not to upgrade to SQL enterprise (too costly). Is
there a tool that provides a robust solution? ... deletes old log
files, logs events, does backups, failure notification, recreates
schemas, etc.
Jul 20 '05 #1
2 2462
Although I haven't used it, I believe there is such a tool in the BORK
4.5. (Back Office Resource Kit)

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #2
Hi

SQL Server professional ran a couple of articles for rolling your own log
shipping. but you have to be a subscriber to see them
http://www.pinnaclepublishing.com/SQ/SQmag.nsf/index/$searchForm?SearchView&Seq=1

Also another subscription article may be useful:

http://www.sqlmag.com/Articles/Index...rticleID=23231

John
"BobF" <bo*@frieden.org> wrote in message
news:d3**************************@posting.google.c om...
I'd like to use log shipping to provide warm backup to some production
MSFT SQL 2000 servers. I know that I can write something to ship logs
but I'm looking for a complete solution that would take a while to
write. Prefer not to upgrade to SQL enterprise (too costly). Is
there a tool that provides a robust solution? ... deletes old log
files, logs events, does backups, failure notification, recreates
schemas, etc.

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Cherrish Vaidiyan | last post: by
reply views Thread by Cherrish Vaidiyan | last post: by
2 posts views Thread by Cherrish Vaidiyan | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.