Red Gate forums :: View topic - Database displayed as Offline
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 4
SQL Monitor 4 forum

Database displayed as Offline

Search in SQL Monitor 4 forum
Post new topic   Reply to topic
Jump to:  
Author Message
kmonroe@psecu.com



Joined: 06 Dec 2012
Posts: 5
Location: Pennsylvania, US

PostPosted: Tue Jan 21, 2014 1:31 pm    Post subject: Database displayed as Offline Reply with quote

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
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 328
Location: Cambridge, UK

PostPosted: Wed Jan 22, 2014 9:11 pm    Post subject: Reply with quote

Simply restart the SQL Server service. This will reset the configuration flag which SQL Monitor uses to determine the state of the databases.
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
kmonroe@psecu.com



Joined: 06 Dec 2012
Posts: 5
Location: Pennsylvania, US

PostPosted: Wed Jan 22, 2014 9:35 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 328
Location: Cambridge, UK

PostPosted: Wed Jan 22, 2014 10:04 pm    Post subject: Reply with quote

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.
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group