How to recover SQL Server database from suspect mode?

[Atiq]

Please use this script to recover database from suspect mode in MS SQL Server 2008, 2005 through SQL Server management Studio.

EXEC sp_resetstatus 'yourDBname';
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER

Note: change yourDBname with database name you want to recover from suspect mode.

References:

https://support.aspnix.com/index.php...kbarticleid=32

[Roma]

Great post! very helpful