469,148 Members | 1,433 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,148 developers. It's quick & easy.

SQL server replication from non-clustered database servers

Hello,

Being a bit of a SQL Server novice, need some advice with the following
situation.

Server A and Server B have SQLServer 2000 based databases. The vendor
of the application/system has implemented their own replication process
to ensure the 2 databases are in sync. However, there is no clustering
with virtual IP addresses implemented. So to an external client/db, it
is 2 identical databases with the same name on 2 distinct servers.

We need to develop an application that will reside on a networked
server C and with SQLServer 2000 as well. While most of the tables in
this database are self contained, around 10 tables will have to be
mirror copies of the same tables from either Server A or Server B.

Question, how do we implement subscription based replication on top of
a redundant database, when no clustering is implemented? So, in
essence, when Server A is alive, the database on Server C will
periodically (or on change) replicate the 10 tables from Server A. When
Server A is not alive, it needs to do same from server B. (When both
server A and B are alive, it is acceptable to get data from either,
since they are synchronized internally).

Any alternate suggestions on achieving this functionality are welcome
too. If SQL Server 2005 has some capabilities that may address this
problem, that is a consideration as well.

Thanks

Jun 22 '06 #1
1 1360
Pls take a look at Alternate Synchronization Partners in merge replication.
On SQL Server 2005 you might consider peer-to-peer transactional
replication.
Actually probably the simplest solution is to have Server C as a publisher
and the other 2 as subscribers in a merge scenario.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Jun 22 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Stein Rustad | last post: by
14 posts views Thread by diskoduro | last post: by
4 posts views Thread by gjameson via AccessMonster.com | last post: by
15 posts views Thread by sat | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.