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.
That's pretty much it. Database will work perfectly.
Post a Comment