This SharePoint tutorial explains, how to solve sharepoint_config (suspect) error which comes in SharePoint 2019/2016/2013.
Learn how to solve sharepoint config database suspect and sharepoint configuration database suspect issue.
Recently when I tried to open the SharePoint 2019 site, the site did not open. Then when I checked in the SQL Server database, I saw the error in the SharePoint_Config database as sharepoint_config (suspect).
The issue comes if the SharePoint_Config database got corrupted for some reason. Now to solve SharePoint_Config (Suspect), run the below queries in SQL Server. Here I have the SharePoint 2019 farm with SQL Server 2016 installed on the system.
Use Master EXEC sp_resetstatus 'SharePoint_Config' ALTER DATABASE SharePoint_Config SET EMERGENCY DBCC checkdb('SharePoint_Config') 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 EXEC sp_resetstatus 'SharePoint_Config'
You can see it looks like below:
Once you run the above command, the sharepoint_config (suspect) error will not come and the issue got resolve. You can see the SharePoint_Config database will open correctly.
Hello Everyone!! I am Bhawana a SharePoint MVP and having about 10+ years of SharePoint experience as well as in .Net technologies. I have worked in all the versions of SharePoint from wss to Office 365. I have good exposure in Customization and Migration using Nintex, Metalogix tools. Now exploring more in SharePoint 2016 🙂 Hope here I can contribute and share my knowledge to the fullest. As I believe “There is no wealth like knowledge and no poverty like ignorance”