Link to home
Start Free TrialLog in
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..
ASKER CERTIFIED SOLUTION
Avatar of newmath
newmath
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SP_2018 .

ASKER

Hi,

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

Thanks
Glad you got it going.