How to recover SharePoint 2013 Databases from Suspect Mode ?

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.

Please follow and like us:

Leave a Reply

Enjoy this blog? Please spread the word :)