We are using SCOM to monitor SQL Server AOAG, and I am having trouble resolving this alert:
Database is in offline/recovery pending/suspect/emergency state
I use the alert details to check the status of the databases on each of the AOAG replicas, as well as the Always On High Availability Dashboard. The dashboard is all green.
I also checked this query, and the databases in question report ONLINE for the state.
SELECT name, state_desc FROM sys.databases
Does anyone know how I can find out exactly what SCOM thinks is wrong, and how to fix it so that the alert is addressed?
Thanks for any help.