SQL 2000 Replication

[flyjetta]

How would I replicate data from one sql server to another? We are setting up two identical boxes for a client, they would like some form of failover if possible. We were thinking of doing a dump every night, then exporting that data to the other server and doing a restore.

Any suggestions on a best way to do this? I'm just starting out in SQL and am hitting the ground running

Any recommended books to read about being an SQL DBA?

 

[mrdenny]

You have a couple of options.

1. Clustering - more expensive, requires shared storage
2. Log Shipping - less expensive, no shared storage, more licensing costs. You can use Microsoft's log shipping. I've also writting some log shipping which you can get from here faq962-5754.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com