SQL server database in suspect mode
Results 1 to 6 of 6

Thread: SQL server database in suspect mode

  1. #1
    Join Date
    May 2015
    Posts
    19

    SQL server database in suspect mode

    Hi,

    I am using SQL Server database 2008 R2. How can I repair my database from the suspect mode?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    restoring from good backup is best way.

  3. #3
    Join Date
    May 2015
    Posts
    19
    I do not have updated backup

  4. #4
    Join Date
    Oct 2015
    Posts
    3

  5. #5
    Join Date
    Oct 2015
    Posts
    3
    Run this query:

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

    in 80% cases, this query help to repair the database.

    Good Luck!

  6. #6
    Join Date
    May 2015
    Posts
    19
    Thanks a lot Nicholas for your help. It works

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •