How can I fix MSSQL Suspect Mode error in Simphony?

VladA-Oracle

How can I fix MSSQL Suspect Mode error in Simphony?

VladA-Oracle

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.