Search This Blog

Thursday, April 26, 2012

Recovering SQL Server Database From Suspect Mode

Follow below steps to recover database from suspect mode:

  1. ALTER DATABASE [database_name] SET EMERGENCY 
  2. DBCC checkdb('database_name') 
  3. ALTER DATABASE [database_name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE 
  4. DBCC CheckDB ('database_name', REPAIR_ALLOW_DATA_LOSS)
  5. ALTER DATABASE [database_name SET MULTI_USER

If it does not work for you, then go for thrid party tool or restore database from available backups.