Creating, detaching, re-attaching, and fixing a SUSPECT database

http://www.sqlskills.com/blogs/paul/creating-detaching-re-attaching-and-fixing-a-suspect-database/

Recover MS SQL SERVER 2008 R2

EXEC sp_resetstatus ‘DataBaseName’
 ALTER DATABASE DataBaseName SET EMERGENCY
 DBCC checkdb(‘DataBaseName’)
 ALTER DATABASE DataBaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
 DBCC CheckDB (‘DataBaseName’, REPAIR_ALLOW_DATA_LOSS)
 ALTER DATABASE DataBaseName SET MULTI_USER


Ref : http://durgaprasadch.wordpress.com/2012/04/26/recover-database-from-suspect-mode-sql-server-2008-r2/