As Greg had stated earlier it is safer to use kill with statusonly after the first kill statement has been executed. Quote from BOL;

"The same status report can be...

Yes, admitting that we don't know how to do something is critical in our work.

Ultimately there is no point in pointing fingers, just learning lessons and growing. Hopefully no...

Unfortunately there is nothing you can do once you have dropped the database. If you had detached it then you might be ok.

Are you sure there are no backups?...

I guess the restart doesn't surprise me but the error message stunk! Thanks for following up with the final solution.

I have worked a 5/4/9 rotation before which is basically first week Mon - Thur 9 hours a day, Friday 8; second week Mon - Thur 9 hours a day,...

Yes, the less physical space that has to be allocated on the drive the less time it will take. The remainder of the restore process will remain unaffected though.

Thanks for posting the outcome. Too bad you can't keep it around to try to work through some type of recovery. Good experience anyway.

Agreed, weird. Something definitely seems to be off though in the version that you are using.

Yeah, ArcServ being the tape backup solution would probably be a mite slow in the restore process as well as the backup process. Are they / you backing up directly...

Did you stop / start the instance after you executed sp_resetstatus? Should have asked earlier. If so, then emergency mode would be the last option.

A couple of links -...

Next question, when / how did it become suspect. Was this during an instance startup or during an Attach database process. Please let me know.

Do you have a backup?

What were the messages you were seeing in your error logs prior to running the sp_resetstatus?

Try DBCC CHECKDB (YourDB)

Jack Corbett (8/28/2008)

---

I'm assuming you mean my rationale for lower case with "_" (I have to hit shift for the "_"). quote]

Yeah, that was my humor. Sorry, most people...

Jack - Is that just so that you don't have to hit the shift key. 😛

Seriously though, I would like to hear your rationale on that. Thanks for sharing in...