up vote 0 down vote favorite
share [g+] share [fb]

there is a db in emergency mode,which i was told to make it "normal". in the enterprise manager i can not see any objects(like tables, users and stuff). in the guy's computer, i connect to the server via toad, and copied all the tables and users and functions etc.

dbcc checkdb returned 0 errors. and after getting all the data i can get, i typed alter database 'name' set online . which changed nothing, the db was still in emergency mode.

i am not familiar with all those db modes, so i appreciate aany help i can get.

right now, db properties show that its in multi user mode, and still in emergency

Thanks

link|improve this question
Start looking for a recent backup of the database – Remus Rusanu Sep 22 '11 at 15:33
problem about the backup is that there isn't any. – futile Sep 22 '11 at 16:55
feedback

migrated from stackoverflow.com Sep 22 '11 at 15:36

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 2 down vote accepted

The short form is you are hosed, because in SQL Server 2000 there's no documented, official way to bring a database out of emergency mode. In the past, I've just had to restore the database from a backup. This is why a good recovery plan is necessary (including regular testing of backups, so you don't get stuck with a bad backup file). The steps are complicated to try to recover; you should take a look at this article: http://www.sqlskills.com/blogs/paul/post/checkdb-from-every-angle-emergency-mode-repair-the-very-very-last-resort.aspx

link|improve this answer
problem is, noone at that end have any backups of the db. so restore is not an option. i did create another db with all the data i can get, and changed their web application's connection string. it looks like its running. ty for the reply and the link, looks really helpful. – futile Sep 22 '11 at 16:54
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.