Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL 2000 Replication

Status
Not open for further replies.

flyjetta

MIS
Joined
Mar 23, 2004
Messages
3
Location
US
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?
 
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)
[noevil]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top