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