MOM 2005 reporting suspect 2005 SQL DB
Posted on 2006-07-17
Hello I have recently installed MOM 2005 on W2k3 and I have started monitoring several SQL database servers. They are SQL 2000 and 2005. I have one database on a SQL 2005 box that is getting is suspect error message in MOM. All the other databases on the server and other servers report OK. The "suspect" database seems to be working fine and running scripts like DBCC CHECKDB come clean without any errors.
The only thing I can think of is this DB was originally created in SQL 2000 and was moved to 2005. Is it possible that a proper "upgrade" did not occur?
Do I maybe need to just reset the status?
Below is the message from MOM.
Severity: Critical Error
Source: SQL Server 2005 Database Health:MSSQLSERVER:Database(Development)
Name: SQL Server 2005 Database Health
Description: The database "Development" in the instance "MSSQLSERVER" is in a critical state. The state is: Suspect.
Any help would be appreciated!