September 1, 2011 at 7:10 am
Hello, I got an error from DBCC CHECKDB:
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8329440186165493760 (type Unknown), page (7672:1036214843). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -14.
How can I fix it?
Thank you
September 1, 2011 at 8:01 am
I can't help you with analyzing the error, but I can tell you that Ms. Shaw is the go-to lady for this stuff.
She usually says:
GilaMonster
Please run the following and post the full results
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Here's an article[/url] she wrote a little while ago, perhaps it will give you a little more information as to what you are looking at.
Until Ms. Shaw has time to read this, I would suggest not doing any repair operations. Maybe also provide additional information like SQL Server version and edition, whether it's production instance, backup history (you have backups, right?), and if there are HA options enabled.
September 1, 2011 at 8:42 am
What's the output of the checkDB statement that calvo was thoughtful enough to post? (the entire, unedited output)
Do you have a clean backup (one without any corruption)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply