AlwaysON Availability groups with replication

Question

Hello Folks,

I have successfully configured AG with transactional Replication by configuring the subsciber with listener name and redirected publishers. Tested failover between publisher AG and Subscribers AG and everything is working fine.

Before asking the question, I would like to share the environment details.

Publisher Cluster 3 nodes:

A, B and C are the nodes and configure ag between these 3 nodes with Listener as LisABC.

Distributor server/node name: D

Subscriber cluster 3 nodes:

E,F and G are the subscriber nodes and configured AG between them with listener as LisEFG.

Configured the Publisher in publisher Cluster and subscriber and subscriber cluster with listener name by using distributor instance D. Configured the remote distributor at all possible publishers

Even configured the redirected publishers. Everything is working as expected and we did tested failovers too.

Recently we lost one of the replica from publisher AG due to storage corruption and we lost all disks for that replica. we did rebuilt the replica and added back to same publisher Cluster and AG.

once we rebuilt the replica we could see it lost the remote distributor config setup and replication related information.

Here once we added back this new built replica to the Publisher AG, what will happen if I failover the AG to this newly rebuit replica? Will that transaction replication function? If it won't work how can I make sure this replica is added back to transaction replication functionality without any impact to existing replication?

Please let me know your suggestions or resolutions.

Thanks in advance,

Nagesh

Answer 1

Hi @Nagesh p ,

If one AG replica is offline, Replication will stop reading transactions until that AG replica is back online.
This is a related article: https://www.sqlpassion.at/archive/2017/09/25/adding-a-replica-back-into-a-sql-server-availability-group/
And here are some failover types and conditions.
If there is any problem, it will report an error.

Best regards,
Seeya

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
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.