We're setting up a DB which will be mirrored to another Instance/DB on a seperate server. The principal server will also be replicated (transactional replication) to another Instance/DB on a seperate server. In the event of the principal server being demoted
to a secondary server (though automatic failover), will the replication still work, i.e. will the replication start reading changes from the 'new' principal server?
View Complete Post