2

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.

Improve this question

1 Answer 1

Reset to default
6
  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

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

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.