How to find the cluster that an AG database sits on
This explains how to find the name of the cluster that a SQL AG db sits on. This is always confusing because you need to sift through virtual names in Windows and SQL so I'm noting down for future reference:
- Go to Microsoft SQL Server > SQL Server Database Engines > Always On High Availability > Database Replicas
- Search for the db. You will get duplicates because that's how AG dbs work, there's multiple copies!
- Select any db. Down below copy the Availability Group Name value. Note you can also get the SQL instance name from the Primary Replica field
- Go up to Availability Groups and search for the AG name
- Select the AG name. Down below, copy the Cluster Name value
- Go to Microsoft Windows Cluster > Cluster Service State and search for the cluster name
Done. This is the cluster the AG db sits on. You can also can see the cluster nodes.
Comments
Post a Comment