Some time we come to see the database are in Suspect Mode after coming to the shift and checking the databases as part of the daily routine checks.
To Fix this follow the below steps.
- 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 MULTIUSER;