Database displayed as Offline

kmonroe@psecu.com

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

chriskelly

Simply restart the SQL Server service. This will reset the configuration flag which SQL Monitor uses to determine the state of the databases.

kmonroe@psecu.com

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

chriskelly

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.