Welcome To DBA Share

Database is in suspect mode how to recover it ?

0 comments

I have seen that one of my database is in suspect mode. I really worried about it because that is in mission criticle server. and I try to recover it, Finally i got suceed in that. Here i'm sharing for you...
Step 1: First we need to remove the suspect mode flag on the database to do this we need to issue the following query
EXEC SP_RESETSTATUS 'JOQDB'
GO
Step 2: First we need to keep database into Emergency move
USE MASTER
GO
ALTER DATABASE JOQDB SET EMERGENCY
GO

Step 3: Set the database into Single user mode
ALTER DATABASE JOQDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Step 4: Checking the database by issuing below query
DBCC CHECKDB (JOQDB, REPAIR_ALLOW_DATA_LOSS)
GO

Step 5: If above query ran successfully we can put database into multy user mode by firing the below query

ALTER DATABASE JOQDB SET MULTY_USER
GO
That's pretty much it. Database will work perfectly.

Share this article :

Post a Comment

 
Support : 2005 | 2008 | 2008R2 | 2012 | 2014 | SQL Server DBA
Copyright © 2013. DBA Share - All Rights Reserved
Template Created by Creating Website Modify by CaraGampang.Com
Proudly powered by Blogger