Red Gate forums :: View topic - Databases shown as offline
Return to www.red-gate.com RSS Feed Available

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

Databases shown as offline

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jonwilk



Joined: 09 Sep 2005
Posts: 18

PostPosted: Fri May 27, 2011 8:32 am    Post subject: Databases shown as offline Reply with quote

Hi

Just upgraded to 2.3

We're monitoring a few servers and all is well, however, the 1 and only cluster we're monitornig is showing the databases as offline when viewed from the overview page.

The status shows as OK (on the overview page), the status on the configuration>monitored servers is showing as Monitoring/Connected, and the monitoring show log is clear and highlighted in green.

Not sure what to check to get them shown as online in this page (everything else seems ok - ie alerts etc)

Happy to post a screen shot if it helps

Thanks
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Fri May 27, 2011 11:56 am    Post subject: Reply with quote

Hi Jon,

Could you login to this instance via SSMS (SQL Server Management Studio) and connect to this particular instance and verify if the databse listed in Overview is actually offline or not?

Thanks,
Priya
Back to top
View user's profile Send private message
jonwilk



Joined: 09 Sep 2005
Posts: 18

PostPosted: Fri May 27, 2011 12:06 pm    Post subject: Reply with quote

hi
all of the databases are online and working fine (this is a production server)
they are all showing as offline in sql monitor
this worked fine in 2.2
thanks
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Fri May 27, 2011 12:31 pm    Post subject: Reply with quote

Hi Jon,

Could you please email a screen shot of Overview page and SSMS (showing the database) to priya.sinha@red-gate.com?

Thanks,
Priya
Back to top
View user's profile Send private message
gmjones



Joined: 07 Mar 2012
Posts: 2

PostPosted: Wed Mar 07, 2012 7:53 pm    Post subject: Databases shown as offline Reply with quote

Having the exact same problem. Monitoring a SQL 2008 instance, all databases are showing offline. Still collecting data though.
Back to top
View user's profile Send private message
fionag



Joined: 05 Jan 2012
Posts: 32
Location: Red Gate

PostPosted: Mon Mar 12, 2012 10:46 am    Post subject: Reply with quote

gmjones - Would you be able to email through your log files to fiona.gazeley@red-gate.com
The following article explains how to get your log files.
http://www.red-gate.com/supportcenter/content/SQL_Monitor/knowledgebase/SM_LogFilesKB
Many thanks
Fiona
Back to top
View user's profile Send private message
gmjones



Joined: 07 Mar 2012
Posts: 2

PostPosted: Mon Mar 12, 2012 1:22 pm    Post subject: Databases shown as offline Reply with quote

Fiona, thanks for the followup. This was a new install, and the error automagically cleared up after a couple of hours. Support already has the log files for research, and has flagged the ticket as inactive.
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