Resolve database suspect (suspect) status

Run the database in the virtual machine accidentally forced shutdown, the result is an important database followed by a suspect keyword, in the manager can not open, the program will not run.

There are many methods of analysis on the net, try some not to work, finally solved with this method, record.

Execute the following code, where dbtest is the problematic database.

' DbTest ';  

ALTER DATABASE  DbTest SET EMERGENCY  

DBCC checkdb (' DbTest ')  

ALTER DATABASE  DbTest SET single_user with ROLLBACK IMMEDIATE  

DBCC CheckDB (' DbTest ', Repair_allow_data_loss)  

ALTER DATABASE  DbTest SET multi_user