Viewing 15 posts - 1,306 through 1,320 (of 1,790 total)
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 28, 2008 at 2:24 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 28, 2008 at 12:48 pm
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?...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 28, 2008 at 12:10 pm
I guess the restart doesn't surprise me but the error message stunk! Thanks for following up with the final solution.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 28, 2008 at 9:41 am
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,...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 28, 2008 at 9:14 am
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.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 28, 2008 at 9:11 am
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.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 28, 2008 at 8:58 am
Agreed, weird. Something definitely seems to be off though in the version that you are using.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 28, 2008 at 8:25 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 28, 2008 at 8:23 am
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 -...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 28, 2008 at 8:13 am
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?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 28, 2008 at 8:00 am
What were the messages you were seeing in your error logs prior to running the sp_resetstatus?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 28, 2008 at 7:51 am
Try DBCC CHECKDB (YourDB)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 28, 2008 at 7:38 am
Jack Corbett (8/28/2008)
Yeah, that was my humor. Sorry, most people...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 28, 2008 at 7:06 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 28, 2008 at 6:45 am
Viewing 15 posts - 1,306 through 1,320 (of 1,790 total)