February 27, 2017 at 4:12 am
Dear All,
We have setup Always ON (Synchronous) between two nodes Server1 and Server2, which works fine as we have tested failover and
backups on them.
There was a need to setup Replication from the above to a WFCS called Server3. During Replication setup, Server1
was the Primary Always On server. Replication was setup successfully and we ran "EXEC sys.sp_redirect_publisher" to redirect the Original
Publisher to the Listener name on the Distribution database. We tested failover of Always On Servers and Replication worked successfully.
However in order to test futhere we turned off Server1 which was the Original Publisher at the time of Replication setup and we found the Replication broke completely.
Has anyone come across such a situation and found a fix for it?
Any help and advice is welcome. Thanking you in anticipation,
Kailash.
February 27, 2017 at 7:02 am
kkanaya - Monday, February 27, 2017 4:12 AMDear All,
We have setup Always ON (Synchronous) between two nodes Server1 and Server2, which works fine as we have tested failover and
backups on them.There was a need to setup Replication from the above to a WFCS called Server3. During Replication setup, Server1
was the Primary Always On server. Replication was setup successfully and we ran "EXEC sys.sp_redirect_publisher" to redirect the Original
Publisher to the Listener name on the Distribution database. We tested failover of Always On Servers and Replication worked successfully.However in order to test futhere we turned off Server1 which was the Original Publisher at the time of Replication setup and we found the Replication broke completely.
Has anyone come across such a situation and found a fix for it?
Any help and advice is welcome. Thanking you in anticipation,
Kailash.
Did you do any research on this topic? A search of the words
sql server alwayson replication
reveals a number of top ranked searches that are quite clear and detailed.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 27, 2017 at 8:59 am
Hi Kevin,
Thank you for your reply. I have looked online but I could not find a fix to the issue and hence this post. I will look again incase I have missed something that will help resolve the issue.
Regards,
Kailash.
February 27, 2017 at 1:28 pm
Search web for a white paper from Paul Randal entitled SQL Server Replication: Providing High Availability with Database Mirroring
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 28, 2017 at 2:43 am
Hi Kevin,
Thank you for the link. Really appreciate your help with this.
Regards,
Kailash.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply