How to Repair SQL Server Suspect Database

If your Database is marked as Suspected, here are the steps to fix it :

EXEC sp_resetstatus WSS_Content_1234;

ALTER DATABASE WSS_Content_1234 SET EMERGENCY

DBCC checkdb (WSS_Content_1234)

ALTER DATABASE WSS_Content_1234 SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB (WSS_Content_1234, REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE WSS_Content_1234 SET MULTI_USER