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/