Pages

Thursday, November 18, 2010

Sharepoint_Config Suspect Mode

Hello Friends
Just Browse to SharePoint Site and got the error which is a general issue "Cannot Connect to the configuration database"
I have looked into all common resolutions, Checked all services are running or not, especially SQL Server and yes it is running.
Then I just logged in into the "SQL Server management Studio" and check databases where all are functioning normally or not.
I saw "Sharepoint_Config(suspect)." I scared but there is a very simple solution available for that .Just run this to recover the database may be you lose your some of data but it will recover and run your SharePoint successfully.
EXEC ALTER DATABASE yourSharepoint ConfigDBname SET EMERGENCY
DBCC checkdb('yourSharepoint ConfigDBname')

ALTER DATABASE yourSharepoint ConfigDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourSharepoint ConfigDBname', REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE yourSharepoint ConfigDBname SET MULTI_USER sp_resetstatus 'yourSharepoint ConfigDBname';

Hope this scripts helps some one's life!!

Enjoy
Disha Shah

No comments:

Post a Comment