SharePoint Config Database gone Suspect Mode..

I had my SQL and SharePoint in VM Nodes. just while a go realized that SharePoint Config DB suddenly gone suspect after restarting my host which was unexpected.

image

Option 1.

The very first option came to my mind is to restore the database through a previous backup but I didn’t had a one since this is a new farm.

Option 2.

luckily there was an another option which is just an query as simple as below.

— 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

— Verify that database is reset
EXEC sp_resetstatus ‘SharePoint_Config’

after running this the issue was fixed and I was able to get in to the Central Administration and other Web applications

image

Note: This can happen on any SQL DB and as per most of the blogs on web, SharePoint DB get corrupted occasionally when VM s restarts unexpectedly

so make sure that you save your VM before restart your host though it’s on staging or development because recovering takes time so better to avoid it without wasting.

Advertisements

3 thoughts on “SharePoint Config Database gone Suspect Mode..

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s