Options

Database displayed as Offline

edited January 22, 2014 4:04PM in SQL Monitor Previous Versions
I have an instance that I'm monitoring that has 45 databases. Two of the databases are displaying "Offline" in SQL Monitor but in SQL Server they are online.

Any Ideas??

Kevin
Kevin Monroe
SQL Server DBA

Comments

  • Options
    Simply restart the SQL Server service. This will reset the configuration flag which SQL Monitor uses to determine the state of the databases.
  • Options
    Thanks for the Reply Chris. So SQL Monitor doesn't periodically recheck to see if the database is back online after being marked as offline?

    I know that it repeatedly checks to see if the state changes from online to anything other than online. I've seen the database unavailable alert when performing a restore or if SQL monitor checks a SQL Server after a restart before all of the databases have gone through crash recovery.

    Either way, that is good to know. I'll have to remember to recheck the instance in SQL Monitor the next time the instance is restarted.

    Thanks again,
    Kevin
    Kevin Monroe
    SQL Server DBA
  • Options
    It does periodically check the status of the database. But there are some scenarios where the status flag that SQL Monitor uses for this check does not get correctly updated in SQL Server. I'm not sure why this happens, but restarting the SQL Server service seems to force this to be correctly updated. This means that the next time that it is checked, it is correct.
Sign In or Register to comment.