Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Is there a way to start a SQL 2000 instance without loading one specific database? We've got a database that is crashing the server at a certain point during the db recovery process, and we're going to try to recover from backup. But we can't start the restore when the instance keeps restarting itself.

(If you're curious, a huge table re-indexing that went bad. It was cancelled, and tried to roll back, but for some reason the SQL service restarted itself during the rollback. Now we're in a situation where the service restarts, it tries to recover the db, then somewhere in the middle it gets stuck and restarts the service again.)

Any help or ideas are appreciated.

share|improve this question

1 Answer 1

up vote 6 down vote accepted
  1. stop sql server
  2. rename data & log files of the db with the issues
  3. start sql server

The db will be marked 'suspect' when you start, but at least it wont be trying to rollback. From there you can drop the database & do a restore

share|improve this answer
    
sounds like that should work. Will give it a try. –  BradC Aug 16 '09 at 18:06
    
That worked, thanks. Database didn't appear as "suspect" in SSMS, though. Just missing the [+] in front, and obviously not accessable. –  BradC Aug 17 '09 at 0:26

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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