SCOM alert offline/recovery pending/suspect... but DBs seems fine

• webrunner

  SSC-Dedicated

  Points: 31711

  More actions

  July 20, 2020 at 6:59 pm

  #3771482

  Hello experts,

  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.

  -- webrunner

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  July 21, 2020 at 7:10 pm

  #3771852

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.