Sample Header Ad - 728x90

How to determine the global primary instance in a SQL Server distributed availability group using T-SQL?

1 vote
1 answer
296 views
I have a SQL Server distributed availability group set up, and I'm currently connected to the forwarder instance. I would like to know how to use T-SQL to query the appropriate DMVs or catalog views to determine which instance is currently serving as the global primary in the distributed availability group. I'm looking for a T-SQL script or query that I can execute on the forwarder instance to retrieve this information. Any help or guidance on this topic would be greatly appreciated. Thank you in advance!
Asked by Just a learner (2082 rep)
Apr 26, 2024, 01:06 AM
Last activity: Jul 3, 2024, 04:58 PM