How to Recover MS SQL Database from Suspect Mode

1) EXEC sp_resetstatus ‘db_name’; ALTER DATABASE db_name SET EMERGENCY

2) DBCC CHECKDB (‘database_name’)

3) ALTER DATABASE database_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE

4) DBCC CHECKDB (‘database_name’, REPAIR_REBUILD)

5) DBCC CHECKDB (‘database_name’, REPAIR_ALLOW_DATA_LOSS)

6) ALTER DATABASE database_name SET MULTI_USER