Hello all,
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.
Anyone seen this? Any thoughts?
Thank you!
/Björn
Here is the alarm:
| Description: The database VIM_UMDB in instance SQLEXP_VIM is in a critical state. The state is Suspect. | Name: | SQL Server Database Health - Database is unhealthy |
|---|---|---|
| Severity: | Warning | |
| Resolution State: | New | |
| Domain: | DOMAIN | |
| Computer: | SERVER | |
| Time of First Event: | 2008-08-19 22:30:04 | |
| Time of Last Event: | 2008-08-20 03:00:03 | |
| Alert latency: | 4 sec | |
| Problem State: | Active | |
| Repeat Count: | 1 | |
| Age: | ||
| Source: | SQL Server 2005 Database Health | |
| Alert Id: | c991af06-fa4c-4f01-858c-38563d0377d1 | |
| Rule (enabled): | Microsoft SQL Server\SQL Server 2005\State Monitoring and Service Discovery\SQL Server Database Health - Database is unhealthy | |
