Red Gate forums :: View topic - Database Status OFFLINE
Return to www.red-gate.com RSS Feed Available

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

Database Status OFFLINE

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jadionne



Joined: 08 Aug 2013
Posts: 3

PostPosted: Thu Aug 08, 2013 4:52 pm    Post subject: Database Status OFFLINE Reply with quote

I am having problems finding why my database is showing a status of OFFLINE. I can get to the db in ssms, why is redgate saying it is offline?

any guidance would be great on this.
Back to top
View user's profile Send private message
chriskelly



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

PostPosted: Mon Aug 12, 2013 8:19 am    Post subject: Reply with quote

We are not sure why this happens, but restarting the SQL Server service and then the SQL Monitor Base Monitor service seems to clear it up. This has worked for users who have reported this previously, but please let me know if it does not work for you.
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
jadionne



Joined: 08 Aug 2013
Posts: 3

PostPosted: Tue Aug 13, 2013 6:44 pm    Post subject: Re: Reply with quote

chriskelly wrote:
We are not sure why this happens, but restarting the SQL Server service and then the SQL Monitor Base Monitor service seems to clear it up. This has worked for users who have reported this previously, but please let me know if it does not work for you.


I completely rebooted the SQL box and restarted the monitor service, but all of the databases are still reporting as off line.

This SQL box is the repository for the monitoring tool, is that a problem?
Back to top
View user's profile Send private message
chriskelly



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

PostPosted: Mon Aug 19, 2013 2:07 pm    Post subject: Reply with quote

Thank you for your reply.

There is no issue at all with monitoring the SQL Server instance which hosts the RedGateMonitor database.

Which "monitor service" have you restarted? The "SQL Monitor 3 Base Monitor" service is the important one here.
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
jadionne



Joined: 08 Aug 2013
Posts: 3

PostPosted: Mon Aug 19, 2013 2:21 pm    Post subject: Re: Reply with quote

chriskelly wrote:
Thank you for your reply.

There is no issue at all with monitoring the SQL Server instance which hosts the RedGateMonitor database.

Which "monitor service" have you restarted? The "SQL Monitor 3 Base Monitor" service is the important one here.


I restarted the SQL Monitor 3 Base and the SQL Monitor Web. Are there any other logs that you need?
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