Database Status OFFLINE

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Database Status OFFLINE

Postby jadionne » Thu Aug 08, 2013 4:52 pm

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.
jadionne
 
Posts: 3
Joined: Thu Aug 08, 2013 4:49 pm

Postby chriskelly » Mon Aug 12, 2013 8:19 am

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
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Re:

Postby jadionne » Tue Aug 13, 2013 6:44 pm

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?
jadionne
 
Posts: 3
Joined: Thu Aug 08, 2013 4:49 pm

Postby chriskelly » Mon Aug 19, 2013 2:07 pm

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
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Re:

Postby jadionne » Mon Aug 19, 2013 2:21 pm

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?
jadionne
 
Posts: 3
Joined: Thu Aug 08, 2013 4:49 pm


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests

cron