Database in emergency mode

SP_2018 .
SP_2018 . used Ask the Experts™
on
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..
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Have you looked at this? http://support.microsoft.com/kb/2015760
SP_2018 .IT Consultant

Author

Commented:
Hi,

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

Thanks

Commented:
Glad you got it going.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial