Triangular way to create Merge Replication


  • I have setup the merge replication between two servers. In server A, created publisher and server B, we have created Subscriber, but the merge agent is running in Server A side.

    Now, we have planned to create one more server C as a Disaster recovery, so I have an idea to create triangular way of replication in SQL server 2012. For example: if server A fails, Server B and server C will be in sync ; if server B fails, server A and C will be in sync; if server C fails(temporary ), server A and C will be in sync.

    Please let me know whether this can be possible in merge replication.

    With Regards,

    Santhosh Wilson

    Thursday, May 02, 2013 6:59 AM


All replies