Database Status

[ashlee]

In my SQL Server there are some databases marked as suspected. What does this mean? I could not understand what it means and so could not clear the errors. Kindly help me to resolve this database status.

[Adrian]

You can make use of DBCC CHECKDB for resolving this. The reason for doing this process is suspected database are mainly caused by some missing files or non availability of drive accessed during database process. So one must first ensure, whether all these are in correct shape before proceeding. The above process would help you to notify this and check the database.

[Ralph]

Before going for the process of DBCC CHECKDB as an initial step you can yourself make a manual check on SQL Server logs and logs of windows event. If some failures happened due to disk failures these can be corrected simply by looking at the logs. If nothing could be figured out in the logs as a next process one can go for DBCC CHECKDB.