SQL Replication – is it possible to change a subscriber to become publisher?

I am trying to setup a backup server B as a subscriber. But whenever the main server A is down, I want to change to subscriber B to become a publisher to serve transaction. Which later on turn the “publisher” A to become subscriber to sync back the transactions from B during the down time back go A. Is it doable?

submitted by /u/teapeng
[link] [comments]


Go to Source of this post
Author Of this post: /u/teapeng
Title Of post: SQL Replication – is it possible to change a subscriber to become publisher?
Author Link: {authorlink}