Merge replication with sql server 2005 clustering

• nikhil.verma

  SSCrazy

  Points: 2603

  More actions

  June 9, 2009 at 11:00 am

  #133145

  Hello All

  In my environment i have 2 clusters ( each with 2 nodes and sql server 2005 enterprise edition . ) . Both the clusters ( one for production and one for DR) are on different locations.

  Both clusters are synchorized with merge replication .

  On cluster 1 two databases are published on to secondary cluster.

  On cluster 2 one database is published on to primary cluster.

  I am not able to understand how the data is going to flow between 2 clusters . Which one will act as publisher and which one is act as subscriber as both the clusters have publisher dbs.

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  June 10, 2009 at 1:57 am

  #1007225

  They are both publisher and subscriber.

  For this case:-

  On cluster 1 two databases are published on to secondary cluster.

  Cluster 1 is the publisher and cluster 2 is the subscriber

  For this case:-

  On cluster 2 one database is published on to primary cluster.

  Cluster 2 is the publisher and cluster 1 is the subscriber