question

JF0001-9520 avatar image
0 Votes"
JF0001-9520 asked Criszhan-msft commented

Failing Over on one of the SQL Server AG at one Location breaks the Distributed AG

I have configured a SQL Server Distributed Availability Group (AG), containing a Windows cluster with an AG at one location, and a second cluster with its own AG at another location (thus, two AGs). Everything is working fine. However, upon failing over at the first location from the Primary Replica to the Secondary one in the first cluster/AG (not the Distributed AG), breaks the Distributed AG, and the node (of the Distributed AG) at the other location on the second AG shows as disconnected. Do I need to perform an additional step in order to complete the process?

Thank you. J

sql-server-general
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.

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

Hi,

Welcome to Microsoft Q&A!

A failover within a AG at one Location will cause the distributed availability group to re-establish the connection from the global primary.

You may need to check the SQL Server Errorlog or Windows logs to see if there is relevant information that can help diagnose the problem.

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.

JF0001-9520 avatar image
1 Vote"
JF0001-9520 answered Criszhan-msft commented

Thank you @Criszhan-msft I have finally fixed the issue. I was missing one rule on the firewall of one of the servers.

· 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,
I’m glad to hear that your problem has been resolved. Thank you for sharing.

0 Votes 0 ·