SQL SUSPECT RECOVERY

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