Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Mirroring with replication question Expand / Collapse
Posted Tuesday, April 30, 2013 6:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 2:20 AM
Points: 212, Visits: 771
Before I watched CBT Nuggets dicussing replication & mirroring. In it he described the following scenario (pictured below as I drew a diagram to help me understand his tongue twister.

Paraphrasing, he said: "If the principal is mirrored then in the case of a failover it will still continue as expected; going from the mirrored server (new principal) to the subscribers. However, if it is a subscriber that is mirrored & that becomes avaiable then that subscriber will no longer be reached."

This makes sense because it is sending to servers rather than cluster names. However, my question is (or rather seeking confirmation) this outcome detailed is only true when the replication uses the PUSH model. If the replication was done in a PULL model then opposite would occur (subscriber could no longer find the failed over publisher but a failed over subscriber would still locate the publisher just fine). Am I right in this assumption?


Post #1447991
Posted Wednesday, May 1, 2013 12:20 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, November 20, 2016 3:52 AM
Points: 927, Visits: 2,039
Edit - removed answer after rereading the question.
Post #1448558
Posted Tuesday, May 14, 2013 10:18 AM


Group: General Forum Members
Last Login: Monday, October 10, 2016 9:24 AM
Points: 2,337, Visits: 1,417
With a remote distributor the subscription can be configured as either push or pull. For high availability of replication you wouldn't want the publisher acting as its own distributor.

Whether you have a push or pull subscription the distribution agent will not recognize the failed over subscription mirror. You would have to setup replication for the new subscriber but you could use the initialize from lsn option rather than creating a new snapshot or restoring from backup.
Post #1452707
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse