Monday, November 5, 2012

SharePoint Configuration DB (Suspect) - How to recover

Run this Script -- Use the Master database Use Master -- Verify that database has issues EXEC sp_resetstatus 'SharePoint_Config' -- Put the database in emergency mode ALTER DATABASE SharePoint_Config SET EMERGENCY DBCC checkdb('SharePoint_Config') -- Set the database in single user mode ALTER DATABASE SharePoint_Config SET SINGLE_USER WITH ROLLBACK IMMEDIATE -- Repair the database with data loss DBCC CheckDB ('SharePoint_Config', REPAIR_ALLOW_DATA_LOSS) -- Set the database in multi-user mode ALTER DATABASE SharePoint_Config SET MULTI_USER --...