August 30, 2018 at 10:56 am
I have question,
Server A is mirrored to Server B when the failover is done server B would be principal and server A would change to Mirror.
Server A is replicating to Server C.
Does replication breaks in this situation. Please advise?
Thanks
August 30, 2018 at 11:40 am
Admingod - Thursday, August 30, 2018 10:56 AMI have question,
Server A is mirrored to Server B when the failover is done server B would be principal and server A would change to Mirror.
Server A is replicating to Server C.
Does replication breaks in this situation. Please advise?Thanks
Yes it does.
I guess my question, is if you are on SQL 2016, have you considered an availability group?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 30, 2018 at 3:40 pm
Well the front end has some issues with availability group. So we cannot use that at this point. So replication would break when you do the failover right? If yes, what is the best way to handle replication? Recreate the replication?
August 31, 2018 at 3:40 am
Hi,
I think this is not correct, that a mirror failover will break a replication.
You have got the parameter "–PublisherFailoverPartner". Some years ago we were able to set up a transcational replication with a mirrord datebase as a publisher.
After a failover, the replication goes on, without doing something.
Best regards,
Andreas
August 31, 2018 at 1:47 pm
I think you may be right. I have tested the scenario with test database.
I did the failover, the replication publisher moves to DR site. However, the changes won't be replicated from DR site to the subscriber after the failover. Once i did failback to the original server. Then replication picked up from that point. Just wondering how does all this happen on the replication side?
August 31, 2018 at 2:46 pm
Admingod - Friday, August 31, 2018 1:47 PMI think you may be right. I have tested the scenario with test database.I did the failover, the replication publisher moves to DR site. However, the changes won't be replicated from DR site to the subscriber after the failover.
Did you configure Distributor for the mirror?
August 31, 2018 at 4:17 pm
I did configure the distributor for mirror. Still no luck?
September 2, 2018 at 7:22 am
andreas.kreuzberg - Friday, August 31, 2018 3:40 AMHi,
I think this is not correct, that a mirror failover will break a replication.
You have got the parameter "–PublisherFailoverPartner". Some years ago we were able to set up a transcational replication with a mirrord datebase as a publisher.
After a failover, the replication goes on, without doing something.
Best regards,
Andreas
I stand corrected, it's been a while.
As far as replication not working after the failover, here are a couple things to dig into.
I had this same setup 10 years ago.
The distributor (I think, old brain cells!) was set up on what would be Server C in your example. All of the subscriptions were lull subscriptions.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
September 6, 2018 at 5:48 am
Admingod - Thursday, August 30, 2018 10:56 AMI have question,
Server A is mirrored to Server B when the failover is done server B would be principal and server A would change to Mirror.
Server A is replicating to Server C.
Does replication breaks in this situation. Please advise?Thanks
have you checked this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply