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