Nov
9
2017

Configuring Replication with Always ON Availability Group

 

 

For setting up replication on AlwaysOn availability group in SQL Server 2012 and above, following need to be taken care to ensure replication will work irrespective of the AAG placement.

 

The following sections build the environment described above:

 

  • Configure a remote distributor
  • Configure the Publisher at the original Publisher
  • Configure Remote distribution on possible publishers
  • Configure the Secondary Replica Hosts as Replication Publishers
  • Redirect the Original Publisher to the AG Listener Name
  • Run the Replication Validation Stored Procedure to verify the Configuration
  • Create a Subscription

 

Points to note:

 

  • In an AlwaysOn availability group a secondary database cannot be a publisher, Re-publishing is not supported when replication is combined with AlwaysOn Availability Groups.
  • SQL Server replication supports the automatic failover of the publisher, the automatic failover of transactional subscribers, and the manual failover of merge subscribers.
  • The failover of a distributor on an availability database is not supported

 

In short following are the high level steps, the screen shots are provided in the links below,

 

https://blogs.msdn.microsoft.com/alwaysonpro/2014/01/30/setting-up-replication-on-a-database-that-is-part-of-an-alwayson-availability-group/

http://ronak.extreme-advice.com/20140619-configure-replication-database-part-alwayson-group/

 

Hope this helps.

Download PDF

About the Author: Nitin G

Indian born, trekker, biker, photographer, lover of monsoons. I've been working full time with SQL Server since year 2005 and blogs to post the content aquired during my research on new topics or fixing issues faced by me as a DBA while working in different kind of projects, hope some of my posts may helps others in SQLDBA community. Everything you read on my blog is my own personal opinion and any code is provided "AS-IS" with no warranties!

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 38 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

January 2018
M T W T F S S
« Nov    
1234567
891011121314
15161718192021
22232425262728
293031  

View Post by Categories

%d bloggers like this: