Avatar of SP_2018 .
SP_2018 .
Flag for United States of America asked on

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..
Microsoft SQL Server 2008Microsoft SQL Server

Avatar of undefined
Last Comment
newmath

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
newmath

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SP_2018 .

ASKER
Hi,

I was able to recover the database by restoring it from the last backup.

Thanks
newmath

Glad you got it going.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23