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

  • 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

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

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply