Database generally Database moves to SUSPECT State due to following Reasons

  • Database is corrupted
  • ldf file is corrupted
  • Disk Hardware Failure or Lack of Disk Space
  • SQL Server does not have sufficient memory to Start SQL Server

Step 1

Never detach a suspect database it end up without re attach .as it is a Suspect database we can’t
take Backup of it. take the database into EMERGENCY MODE

— Take the database into Emergency mode
ALTER DATABASE [Database Name] SET EMERGENCY
GO
Step 2

set the database into single user mode using
— Change into single user mode
ALTER DATABASE [Database Name] SET SINGLE_USER

Step 3

Run DBCC Checkdb with allow data loss, by using this command all the open transactions will
be deleted ,
— Then run DBCC CheckDB command. Warning! REPAIR_ALLOW_DATA_LOSS can cause
some data to be lost!.
DBCC CheckDB (<[Database Name]> , REPAIR_ALLOW_DATA_LOSS)

Step 4

when the database repair is done set the database in multi user mode using
— Change from multiuser
ALTER DATABASE dbName SET MULTI_USER

4 thoughts on “How to recovery Database from SUSPECT Mode

  1. Firstly you need to use built-in function of Restore a Database Backup through SQL Server Management Studio. It will help you in case of availability a database backup copy.

    If database backup is absent or corrupted, you may take into use Recovery Toolbox for SQL Server

    For more info click here http://www.sql.recoverytoolbox.com/

    Either given tool helps if your sql database is huge, software is able to repair sql databases in the amount of up to 16TB.

  2. Hi
    I tried this but still I get an error after executing DBCC CHECKDB then immediately bring the database in SINGLE USER MODE I run this query. As a result i found error again .

    ALTER DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
    Example: ALTER DATABASE sigmatelDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    To solve this critical issues i use SQL repair tool to recover SQL database from suspect mode for help visit here http://www.sqlrepairtool.org

Leave a Reply

Your email address will not be published. Required fields are marked *