What is SQL Server "Suspect" database?
What do you do when you have a database that is marked as Suspect? Restore from the last backup? What is SQL Server database suspect?
Please advise.
SQL Server Database Suspect Sometimes, we got stuck in many critical situations such as a Suspect database. The SQL server database goes into the suspect mode because the primary file (MDF) and other files get damaged and the database fails to repair the damaged file.
First thing is to make sure you DO NOT detach that database. Restoring from the last known goodbackup is fine. Otherwise you will need to use the EMERGENCY repair mode (I am assuming you are running SQL 2005 or higher). Here are a couple of posts from Paul Randal on the subject. Read them both before you start taking any action.