Forum Stats

  • 3,677,522 Users
  • 2,363 Discussions
  • 2,121 Comments

Discussions

How can I fix MSSQL Suspect Mode error in Simphony?

How can I fix MSSQL Suspect Mode error in Simphony?

Best Answer

  • VladA-Oracle
    VladA-Oracle Employee
    Answer ✓

    Due to some database errors, MSSQL status was changed into Suspect Mode. Run the following queries, individually, in the present order:

    EXEC sp_resetstatus ‘dbName’;

    ALTER DATABASE ‘dbName’ SET EMERGENCY;

    DBCC checkdb(‘dbName’);

    ALTER DATABASE ‘dbName’ SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

    DBCC CheckDB (‘dbName’, REPAIR_ALLOW_DATA_LOSS);

    ALTER DATABASE ‘dbName’ SET MULTI_USER;

     

    Database should now be back to multi-user mode, and ready for read/write.

     

This discussion has been closed.