This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 54%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
We have a setup of 2 node Always on Cluster, at the same time the primary node serves as a distributor and publisher for the replication (that feeds to 2 another servers). Our problem is if primary replica fails over replication stops and we run into downtime. So we want to configure distributor to be part of always on group so that even if primary node fails over, replication will continue. What are the steps we need to follow to configure distributor as a part of always on failover group ?
We are not sql server 2014 SP3-CU4-GDR
Additional SQL Server features and topics not covered by specific categories
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi SQLServerBro,
Please refer to the following articles which might help:
Configure replication with Always On availability groups
Configuring distribution databases in Always On Availability Groups
Adding Distribution Database to Always ON
Best Regards,
Amelia
Thats correct. We want to have distributor to be part of always on. Currently all our transactional databases and publisher are part of always on (Node A) alongwith distributor. so If we want to reboot Node A for patching etc it will stop our replication and bring downtime. Currently we are on SQL 2014 so it seems we have to upgrade to SQL 2016 SP2 - CU3 .
In this case if we move distribution to be part of Always on, then what are the steps we need to follow particularly if publisher database is also part of always on HA too. Any link or documentation will be appreciated.
Hi SQLServerBro,
Do you mean you want to configure replication distribution database in Always On availability group?
If I misunderstood, please feel free to let me know.
SQL Server 2017 CU6 and SQL Server 2016 SP2-CU3 support for replication distribution database in an AG. Please refer to this article for more details.
Best Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.