Posts

Showing posts from October, 2022

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.