Emergency Status on Database

[kgreer]

I have a database in Emergency Status mode. I can not find anything that tells me how to reverse it back to normal status. HELP ANYONE.

 

[JayKusch]

When it is in Emergency Mode, the best you can hope for is getting the data out. Here is a FAQ I created in this very subject matter. Hope it help!

faq962-4210

Thanks

J. Kusch

 

[Corran007]

I dont know if you can. This may work but i make no guarntees. Usually when a database is in emergancy mode, you have no other choice than to start exporting data. Ive never tried it for real. I know that doing this will take it out of emergancy mode, but im unsure if it has any affect on the database.

USE master
GO
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO

UPDATE master..sysdatabases
SET status = 16
WHERE name = 'DatabaseName'

Stop and restart all sql server services.

 

[kgreer]

I am starting to copy the data into a new database. then I am going to try to restore the old one. Hope this works.