question

Nageshp-9322 avatar image
0 Votes"
Nageshp-9322 asked SeeyaXi-msft commented

AlwaysON Availability groups with replication

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

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Nageshp-9322 ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

1 Answer

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered SeeyaXi-msft edited

Hi @Nageshp-9322,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.