Windows 7 What to do if the database under MS SQL went to Suspect Mode?

Discussion in 'Programming and Scripting' started by alainmarion85, Jul 16, 2015.

Tags:
  1. alainmarion85

    alainmarion85 New Member

    Joined:
    Jul 15, 2015
    Messages:
    1
    Likes Received:
    0
    In the work I came up against a situation when the working database at the end of day went to the Suspect Mode. And the archive was in many hours before. To transfer it in normal mode, until isn't made repaired base it was impossible. DBCC checkdb also refused to run because the database is in this mode. What to do in this case?
     
  2. Josephur

    Josephur Windows Forum Admin
    Staff Member Premium Supporter

    Joined:
    Aug 3, 2010
    Messages:
    1,018
    Likes Received:
    125
    What version of MS SQL are you using?

    Backup the database if at all possible before trying any of this, I'm not responsible if you nuke your data!

    You need to login to the database as the sa user and perform some maintenance.
    EXEC sp_resetstatus 'database_name';
    ALTER DATABASE database_name SET EMERGENCY;
    DBCC checkdb('database_name');
     
    ussnorway likes this.

Share This Page

Loading...