Where Did My Availability Group (AG) Go?
Published Jan 15 2019 02:32 PM 210 Views
Microsoft
First published on MSDN on Jul 16, 2012

I ran into an issue where the AG was no longer present on a specific node of my cluster but I had NOT dropped the AG from another node in the cluster.  ( http://blogs.msdn.com/b/psssql/archive/2012/06/13/how-it-works-drop-availability-group-behavior... )

Note: Use the XEvent files captured in the LOG directory to confirm that a DDL command was not issued.

There are protection mechanisms built into the AlwaysOn Availability groups to protect the data.  In this specific case I had the registry on Node 1 become damaged.  In doing so the cluster registry no longer matched the SQL Server metadata and my AG is removed from the node.

Note:  The database(s) still exist on Node 1 but they are no longer joined to the 'My AG' availability group. This protects the data on Node 1 from unexpected/mis-configured changes.

It is recommended that you keep the following backups for proper restore of the Availability Group configuration.

Bob Dorr -  Principal SQL Server Escalation Engineer

Version history
Last update:
‎Jan 15 2019 02:32 PM
Updated by: