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.