cchitsiang
11/3/2013 - 6:19 PM

Recover SharePoint 2013 Databases from Suspect Mode

Recover SharePoint 2013 Databases from Suspect Mode

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
DBCC CheckDB ('SharePoint_Config')