Share via

distribution database always on.

Heisenberg 266 Reputation points
2021-07-12T20:36:05.167+00:00

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

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments No comments

3 answers

Sort by: Most helpful
  1. AmeliaGu-MSFT 14,016 Reputation points Microsoft External Staff
    2021-07-14T08:34:24.44+00:00

    Was this answer helpful?

    0 comments No comments

  2. Heisenberg 266 Reputation points
    2021-07-13T18:41:18.913+00:00

    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.

    Was this answer helpful?

    0 comments No comments

  3. AmeliaGu-MSFT 14,016 Reputation points Microsoft External Staff
    2021-07-13T06:39:53.92+00:00

    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.

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.