Sharepoint Config/administration database status in Suspend Mode

I have received the " Cannot connect to the Sharepoint configuration  database " Error Message when opening the Central admin site and Finally found that " Sharepoint_config" Database was in Suspend Mode.

I ran the following SQL Query Script on the Sql Management, before running the query, please take the backup of the .mdf and ldf file.

– 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’

Now the Sharepointconfiguration database mode should be running smooth and you could open the central admin site as well.

I have Reffered the below urls for the issue.

http://nikspatel.wordpress.com/2011/03/02/sharepoint_config-suspect-mode-cannot-connect-to-the-configuration-database-error/

http://sharepointexists.blogspot.com/2011/01/sharepointconfig-database-in-suspect.html

http://prakashmadarla.blogspot.com/2011/05/sharepoint-central-administration.html