VMware Communities: Message List - Virtual Center database in suspect state after reboot http://communities.vmware.com/community/vmtn/mgmt/vc?view=discussions Most recent forum messages en Wed, 20 Aug 2008 09:32:51 GMT Clearspace 1.10.12 (http://jivesoftware.com/products/clearspace/) 2008-08-20T09:32:51Z en Re: Virtual Center database in suspect state after reboot http://communities.vmware.com/message/1028750?tstart=0#1028750 For some reason the SQL Server wasn't shutdown the way it should have been. If this continous after each reboot try to manually shutdown the SQL instance first...<br /> <p /> <p /> Duncan<br /> My virtualisation blog:<br /> <a class="jive-link-external" href="http://www.yellow-bricks.com">http://www.yellow-bricks.com</a><br /> <br /> If you find this information useful, please award points for "correct" or "helpful". Wed, 20 Aug 2008 09:32:51 GMT depping http://communities.vmware.com/message/1028750?tstart=0#1028750 2008-08-20T09:32:51Z 1 year, 3 months ago Re: Virtual Center database in suspect state after reboot http://communities.vmware.com/message/1028712?tstart=0#1028712 Hello , if the database is suspect then you'll need to restore it from a backup. You can use the <a class="jive-link-external" href="http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796">SQL Express Management Studio</a> to check the status of the database. The database is for update manager and your VirtualCenter db is still OK. Thus you can login and use VirtualCenter. You will see some errors if you try to use Update Manager. Wed, 20 Aug 2008 08:36:31 GMT Dave.Mishchenko http://communities.vmware.com/message/1028712?tstart=0#1028712 2008-08-20T08:36:31Z 1 year, 3 months ago Virtual Center database in suspect state after reboot http://communities.vmware.com/message/1028687?tstart=0#1028687 <br /> Hello all,<br /> <p /> On our Virtual Center 2.5U1 server we are running SQL Express 2005. Everything seems to work fine but after reboot our server monitoring system (MOM 2005) detects degraded database health. At one or two occasions after reboot an alarm is raised that database is in suspect state. After that no more alarms occurs. I have found nothing in eventlogs that points to a problem with the database.<br /> <p /> Anyone seen this? Any thoughts?<br /> <p /> Thank you! <img class="jive-emoticon" border="0" src="http://communities.vmware.com/images/emoticons/happy.gif" alt=":)" /><br /> <p /> /Bj&ouml;rn<br /> <p /> Here is the alarm:<br /> <p /> <table class="jive-wiki-table"> <tr> <td>Description: The database VIM_UMDB in instance SQLEXP_VIM is in a critical state. The state is Suspect.</td> <th>Name:</th> <td>SQL Server Database Health - Database is unhealthy</td> </tr> <tr> <td>Severity:</td> <td>Warning</td> </tr> <tr> <td>Resolution State:</td> <td>New</td> </tr> <tr> <td>Domain:</td> <td>DOMAIN</td> </tr> <tr> <td>Computer:</td> <td>SERVER</td> </tr> <tr> <td>Time of First Event:</td> <td>2008-08-19 22:30:04</td> </tr> <tr> <td>Time of Last Event:</td> <td>2008-08-20 03:00:03</td> </tr> <tr> <td>Alert latency:</td> <td>4 sec</td> </tr> <tr> <td>Problem State:</td> <td>Active</td> </tr> <tr> <td>Repeat Count:</td> <td>1</td> </tr> <tr> <td>Age:</td> </tr> <tr> <td>Source:</td> <td>SQL Server 2005 Database Health</td> </tr> <tr> <td>Alert Id:</td> <td>c991af06-fa4c-4f01-858c-38563d0377d1</td> </tr> <tr> <td>Rule (enabled):</td> <td>Microsoft SQL Server\SQL Server 2005\State Monitoring and Service Discovery\SQL Server Database Health - Database is unhealthy</td> </tr> <tr> </tr> </table> <br clear="left" /> <p /> Wed, 20 Aug 2008 08:10:32 GMT BjornJohansson http://communities.vmware.com/message/1028687?tstart=0#1028687 2008-08-20T08:10:32Z 1 year, 3 months ago 2