[SOLVED] How to Recover SharePoint 2013 Databases from Suspect Mode

SharePoint 2013 database suspect mode error

Microsoft SharePoint is a powerful program that are created to meet the multifaceted and the collaborative requirement of the business.  It is very common for the business to face corruption or inaccessibility issues in it. Sometimes we find an error message that are unknown to us.

Recently, many users confirmed they are getting the SharePoint server error after restarting the server and opening the Central Administration they are getting the error message:

Server Error in ‘/’ Application Runtime Error Description: An application error occurred on the server.

01-SharePoint-2013-Server-Error-in-Application-500x66

To resolve this issue you can check a few things:

  • Make sure that your SQL Server services are running
  • Ensure that your IIS application pools are started
  • Review the Windows logs and collect some information regarding the server. You may get the following event:

The SQL Database ‘SharePoint_Config’ on SQL Server instance ‘C4968397007′ not found. The error details are given below.

Cannot open database “SharePoint_Config” requested by the login. The login failed. Login failed for user ‘DC07\SQLSvc’.

 02.1-Windows-logs-500x117

This action indicated that something is wrong with my SQL Server. You tried to open the SQL Server management studio and found that some of the SharePoint databases are missing and set to the suspect mode.

02-SharePoint-2013-databases-are-in-Suspect-mode

What Does the Error Suspect Mode in the SQL Server Database Means?

The database gets into suspect mode is due to the primary filegroup gets damaged and the database can’t be recovered during SQL Server startup.

Well, there are many reasons responsible for the SharePoint 2013 database suspect mode error. Some of the possible once are system malfunction due to improper shutdown of the database server, hardware failure, inaccessible or corrupted database, etc.

This is a bit frustrating issue as you are unable to use SharePoint anymore.  However, the good news is that there are solutions that work for you to recover  SharePoint 2013 Databases from the Suspect mode.

Make sure to follow the solutions given one by one carefully.

How to Recover the SharePoint 2013 Database from Suspect Mode?

First, open your SQL Server management studio and then execute the following query one after another:

  • Run the given query. sp_resetstatus command will then turn off the suspected flag on your database.

EXEC sp_resetstatus ‘SharePoint_Config’;

Once you have executed the following query you will find the given warning. No need to worry it doesn’t mean that you did something wrong.

04-SQL-Server-reset-status-of-database-warning

  • The next step is to set your database to an Emergency mode. You can perform this action by executing the following query:

ALTER DATABASE SharePoint_Config SET EMERGENCY

As soon as you have executed the above query you will find your database like this:

 emergency-mode

Once you have set your database to an Emergency mode then it will become the read-only database.

  • Now just execute the following query in order to check the logical and physical integrity of the objects in your database.

DBCC checkdb(‘SharePoint_Config’)

  •  In order to complete the process run the following queries:

ALTER DATABASE SharePoint_Config SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB (‘SharePoint_Config’, REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE SharePoint_Config SET MULTI_USER DBCC CheckDB (‘SharePoint_Config’)

09-Everything-is-back-to-trackNow just repeat the action for each one of the affected databases. You will find everything on track but if you don’t find everything working properly then you can use a third-party repair tool to get the database accessible form.

Best & Easy Solution to Fix SharePoint 2013 Database from Suspect Mode?

Hopefully, you will be able to recover the SharePoint 2013 database from suspect mode, but if you still encountering the issue then feel free to run the professional SharePoint Database Recovery Software. This software repairs all the corrupt content database of SharePoint.

This tool also allows the user to retrieve the SharePoint database like tables, documents, labels, etc. this software is incorporated with a simple and rich graphical user interface to offer easy SharePoint recovery.

With the help of this tool, you can recover quickly all the crucial site content and uploaded documents to the SharePoint Server which includes articles, blogs, etc. It allows previewing the database objects too actual recovery and helps you to verify the data before saving it to your system. This recovery software:

  • Searches for SharePoint databases
  • Preview of SharePoint Data
  • Upload Database files to SharePoint Server.

Steps to Run the SharePoint Repair Tool

  • Firstly, download, install, and launch the SharePoint Recovery Tool.
  • The interface screen displays two options to recover SharePoint data: ‘Complete Repair‘ and ‘Document Recovery‘. Select as per your requirement.

  • If you choose ‘Complete Repair‘, the screen will show the options for selecting and searching SQL Server (.MDF) files. Click on ‘Browse‘ to select a SharePoint database for repair.
  • If you do not know the actual path of the database which you want to repair, click on the ‘Find‘ to locate the MDF file in a specific drive.
  • After selecting the desired file initiate the scanning process.

  • After finishing the scan, the software would generate a tree of all SharePoint database tables and will display it in the left pane. You can select the table in the tree and can have the entire preview in the right pane. Then click on ‘Repair‘ to begin repairing for the selected database.
  • After clicking on ‘Repair‘, this dialog box will appear. Specify the SQL Server name or Instance name and the desired destination path.
  • Click on the ‘Browse‘ option to choose the destination path. And select the ‘OK‘ button.
  • Once this process gets completed, you would find a dialog box that displays this message ‘Recovered file saved at the desired location.” This shows that Recovery Process has successfully completed’.
  • Select the ‘OK‘ button.
  • You would find another dialog box that asks whether you want to attach the repaired database to the web application. If you click on the ‘Yes‘ button, the above dialog box will be displayed.
  • In the web application type URL, the name of the corrupt database and SQL Server Instance name.
  • Then select the ‘OK‘ button and proceed.
  • When the process gets finished, you would be able to access the repaired database by opening the web application.

Wrapping Things Up:

Undoubtedly the SharePoint 2013 database suspect mode error is very irritating. But luckily there are ways that work for you to recover the database from suspect mode.

Here in this article, I tried my best to list down the possible steps to recover SharePoint 2013 database suspect mode. Make sure to try the steps given carefully.

Hope the solutions given works for you. But if not then run the advanced SharePoint Repair Tool.

If you have any other queries or suggestions, then share it with us on Facebook and Twitter. Also, if you like this article, then share it with the users going through the same issue.