February 25, 2019 at 9:51 am
I have DB mirroring configured to DR location from Server A --> B. Also replication configured from Server A --> C. If i have situation to do fail-over the Principle server would be B. Just curious how does the replication would work in that scenario? Do i have to reconfigure the replication with Server B as source? Is there any other way to handle this?
Thanks
February 25, 2019 at 2:18 pm
Admingod - Monday, February 25, 2019 9:51 AMI have DB mirroring configured to DR location from Server A --> B. Also replication configured from Server A --> C. If i have situation to do fail-over the Principle server would be B. Just curious how does the replication would work in that scenario? Do i have to reconfigure the replication with Server B as source? Is there any other way to handle this?Thanks
If you have replication configured for always on it works. You need to configure the secondary and also execute sp_redirect_publisher to associate the publisher with the listener. Otherwise it won't work. The steps for configuring replication and always on are listed in this documentation - configuring the secondary and redirecting to the listener but with more details:
Configure replication with Always On availability groups
Sue
February 25, 2019 at 2:28 pm
Thanks! So DB mirroring won't work? If not, what would be the option with DB Mirroring.
February 25, 2019 at 2:50 pm
Admingod - Monday, February 25, 2019 2:28 PMThanks! So DB mirroring won't work? If not, what would be the option with DB Mirroring.
Duh...no my bad. I read Always on even though you clearly wrote mirroring. It's Monday...that's my excuse 🙂
It's easier if you use a remote distributor and then configure the principal and the mirror to use that distributor. Then when you execute sp_adddistpublisher, use the mirror network name for the publisher. For the snapshot and log reader agents, you also need to add the parameter -PublisherFailoverPartner and specify the mirror name
The logins, jobs and linked server will need to exist on the mirror as well. If you used the defaults, the repl_distributor linked server needs to be created on the mirror as well as the distributor_admin login. On failover, you do have to manage the jobs. You can disable the jobs on what was the primary and enable the jobs on what was originally the mirror.
This is the correct article for the configurations...it's for mirroring this time:
Database Mirroring and Replication (SQL Server)
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply