February 1, 2016 at 9:34 pm
Comments posted to this topic are about the item DBCC Error 6
February 1, 2016 at 9:38 pm
Well I got it half right! I thought about picking just the CHECKDB without the REPAIR_REBUILD but thought it wouldn't hurt to run it with the extra option. Regardless this had me do some good research. Thanks for the question Andy.
February 1, 2016 at 11:41 pm
This was removed by the editor as SPAM
February 2, 2016 at 7:27 am
Good question, thanks. I guess the safest and most obvious course would always be to conclude there might be corruption after an event like that and to run DBCC CHECKDB.
But I would disagree -- well, "quibble a bit" -- with your final statement "I wouldn't expect many to know error state 6 - but that piece isn't critical to the puzzle. "
It's true that knowledge is not critical, but knowing that someone pulled the plug on running CHECKDB the first time makes it imperative to re-run it. It also tells me that the first run's message of "terminated abnormally" isn't a statement about the database integrity (even if we aren't out of the woods yet). Too bad that CHECKDB didn't return a more helpful message.
Rich
February 2, 2016 at 7:42 am
Rich, its a fair quibble for the real world. From the perspective of the question taker I was trying to explain that getting it right didn't mean memorizing all the magic numbers that SQL generates. If you knew it you were ahead. If not, what would be logical? Wait, now I'm quibbling about your objection! Thanks for trying the question and offering feedback (my favorite part of the deal).
February 2, 2016 at 7:46 am
Good question Andy. Of course these are always subject to interpretation when the question is "what would you do". Hard to actually be incorrect there. 😉
The one response that would be my first course of action was missing. I would contact the person who this was handed off to and ask them why they cancelled the run. I would not proceed any further until I had that answer.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 2, 2016 at 8:09 am
Sean, I thought adding that and maybe should have, or changing the question to say that person wasn't available (and was obviously a slacker for not taking care of business on their shift!). Yep, thinking about it, not sure why I didn't.
February 2, 2016 at 8:18 am
I thought the most likely cause of the DBCC error message was lack of tempdb space for the snapshot it creates; so restarting the instance would ensure that tempdb was clean and maybe now a run of dbcc would go just fine because other hings might not now be using up space. So picked the restart instance option. However I'm no expert on this sort of stuff, so not too surprised that was wrong.
edit: of course running dbcc again after retarting the instance would be essential, but that would have been a third box to tick.
Tom
February 2, 2016 at 8:51 am
Tom, thats a reasonable guess (and an idea for another question!)
February 2, 2016 at 4:50 pm
An interesting question, which can be interpreted differently, thanks. It is quite unfortunate
that even this piece isn't critical to the puzzle https://support.microsoft.com/en-us/kb/926070%5B/url%5D
February 3, 2016 at 6:08 am
I love learning something new, so thank you.
February 3, 2016 at 10:41 pm
Very interesting question, thanx.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
February 4, 2016 at 4:34 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2016 at 4:18 pm
Thanks for the great question.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply