SQL database Suspect Solution

• Sometimes when you connect to your database server, you may find it in suspect mode. 
• Your database server won’t allow you to perform any operation on that database until the database is repaired. 
• A database can go in suspect mode for many reasons like improper shutdown of the database server, corruption of the database files etc. 
• To get the exact reason of a database going into suspect mode can be found using the following uery

DBCC CHECKDB (‘YourDBname’) WITH NO_INFOMSGS, ALL_ERRORMSGS 

• Output of the above query will give the errors in the database. To repair the database, run the follow in queries in Query Analyzer, 

EXEC sp_resetstatus ‘BOSUPPLYSUBACCOUNTS’
ALTER DATABASE BOSUPPLYSUBACCOUNTS SET EMERGENCY

Also read :Recover Suspected SQL Database Using Query

DBCC checkdb(BOSUPPLYSUBACCOUNTS)
ALTER DATABASE BOSUPPLYSUBACCOUNTS SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Also read :Recover Suspected SQL Databases in SQL 2005/2008

DBCC CheckDB (BOSUPPLYSUBACCOUNTS, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE BOSUPPLYSUBACCOUNTS SET MULTI_USER 

• You should keep one thing in mind while using the above queries that the repair mode used here , REPAIR_ALLOW_DATA_LOSS, is a one way operation 

i.e. once the database is repaired all the actions performed by these queries can’t be undone. 

• There is no way to go back to the previous state of the database. So as a precautionary step you should take backup of your database before executing above mentioned queries