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 --...

Thursday, May 17, 2012

Know SharePoint versions

Find out the SharePoint version(standard or enterprise) without the help central administration site. (This is generally useful when you have installed SharePoint and not run the configuration wizard) At this point in time if you need to know the SharePoint version installed used the below approach 1. Get the SKU 2. Map it to the table. Step1: The keys are available in the registry in the below location  Registry path :HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\WSS\InstalledProducts\ Could...