Do you need to do anything different for merge replication on a SQL Cluster with an availability group?

Question

Never setup merge replication on a SQL Cluster with an availability group(a copy of the database on another machine that does not have sql server installed, that's how my client setup their system). Do I need to do anything different than setting up merge replication on a machine with SQL Server on it without the cluster and availability group?

Answer 1

Hi @MR BILL ，

Please read the related documents first:
Configure replication with Always On availability groups
Set up replication distribution database in Always On availability group

Replication Subscribers and Always On Availability Groups (SQL Server)
For merge subscribers, a replication administrator must manually reconfigure the subscriber, by recreating the subscription.

Here's an article for your reference, although the example in it is transactional replication.
https://www.sqlshack.com/configure-sql-server-replication-for-a-database-in-sql-server-always-on-availability-groups/

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.