[MSSQL] FIX DATABASE SUSPECT

use master

EXEC sp_resetstatus dbname

ALTER DATABASE dbname SET EMERGENCY 

DBCC checkdb(dbname) 

ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE 

DBCC CheckDB (dbname, REPAIR_ALLOW_DATA_LOSS) 

ALTER DATABASE dbname SET MULTI_USER