Database in emergency mode
Hi,
One of the database in our production server had been in suspect mode.
I tried using the below command to recover it :
EXEC sp_resetstatus 'dbname';
ALTER DATABASE dbname SET EMETEGENCY
DBCC checkdb('dbname')
ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('dbname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE dbname SET MULTI_USER
However when i ran the above command it went into emergency mode and i get the below message:
The Database ID 8, Page (1:159), slot 0 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE.
Please advise what should be my next steps to recover the database .
Thanks..
One of the database in our production server had been in suspect mode.
I tried using the below command to recover it :
EXEC sp_resetstatus 'dbname';
ALTER DATABASE dbname SET EMETEGENCY
DBCC checkdb('dbname')
ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('dbname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE dbname SET MULTI_USER
However when i ran the above command it went into emergency mode and i get the below message:
The Database ID 8, Page (1:159), slot 0 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE.
Please advise what should be my next steps to recover the database .
Thanks..
Who is Participating?
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
