What is Suspect Mode ?

Suspect mode might be caused by many reasons like unavailable or corrupted database files, hardware failure etc.

Steps to recover database from the Suspect mode:

Pre-Requisites

Make sure a user who is performing the below given steps has the administrator rights for the sql server/

  1. Open SQL Server Management Studio with Run as Administrator
  2. Run the following query one by one
  3. EXEC sp_resetstatus ‘SharePoint_Config’;
  4. ALTER DATABASE SharePoint_Config SET EMERGENCY
  5. DBCC checkdb(‘SharePoint_Config’)
  6. ALTER DATABASE SharePoint_Config SET SINGLE_USER WITH ROLLBACK IMMEDIATE
  7. DBCC CheckDB (‘SharePoint_Config’, REPAIR_ALLOW_DATA_LOSS)
  8. ALTER DATABASE SharePoint_Config SET MULTI_USER
  9. DBCC CheckDB (‘SharePoint_Config’)

You might need to repeat these steps for each one of the affected databases.

By Sigar Dave

Technical Solutions Professional | Modern Workplace Architect Lead | Microsoft 365 | SharePoint | Power Platform | MS Teams | React

Leave a Reply

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

However, the sheer intensity of loud sounds can overwhelm the microphones, leading to distortions in the recorded audio. Expand your mind with these fascinating general knowledge questions and answers. Car inspections & auction inspections.