Monday, October 27, 2014

Recover SharePoint config database from Suspect/Recovery mode to online state

Follow the steps given below in sequence one after another-

Steps
1.
use master
EXEC sp_resetstatus 'SharePoint_Config';
2.
ALTER DATABASE SharePoint_Config SET EMERGENCY
3.
DBCC checkdb('SharePoint_Config')
4.
ALTER DATABASE SharePoint_Config SET SINGLE_USER WITH ROLLBACK IMMEDIATE
5.
DBCC CheckDB ('SharePoint_Config', REPAIR_ALLOW_DATA_LOSS)
6.
ALTER DATABASE SharePoint_Config SET MULTI_USER

No comments: