Groups | Blog | Home
all groups > sql server replication > february 2006 >

sql server replication : Database Replication SQL 2000


stosti
2/14/2006 4:57:27 PM
I have two SQL 2000 servers. I want to make the primary and one the
secondary. I want to databases to stay replicated. If the Primary goes down
the Secondary would be used while we fix the Primary. Once the the Primary
is fixed it would be brought back online and the Secondary would replicate
it's data to the Primary. Then they would be in sync again.

What are my options here? What is the recomended way to accomplish this?

Thanks,
Scott

Paul Ibison
2/15/2006 12:00:00 AM
Scott,
there are many threads (and opinions!) on this sort of thing over the last
few months. I would recommend looking at queued updating subscribers
provided you aren't using BLOB datatypes.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Jay
2/16/2006 4:00:17 PM
AddThis Social Bookmark Button