MSG 7105 - Best course of action?

Question

question

Moz asked May 21, '13

MSG 7105 - Best course of action?

I have a database with one table in particular that is inaccessible. A SELECT on the table produces the following message and no results: Msg 7105, Level 22, State 13, Line 1 The Database ID 7, Page (1:1176881), slot 0 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE. I attempt to run CHECKTABLE for more information but get the same message. My questions are: 1) Can I get CHECKTABLE to run on this table? 2) What is the best course of action in this situation? Many Thanks, Dave.

error

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · May 24, 2013 at 09:53 AM

For all answers that were helpful, please indicate them by clicking on the thumbs up symbol next to all those answers. If any one answer lead you to a solution, you can indicate that answer by clicking on the check box next to that answer.

0 ·

Answer 1 · 2013-05-21T10:00:18Z

Grant Fritchey answered May 21, '13

The documentation provided is good. I would first check to see if you guys are using NO_LOCK. If that's not the issue, then I'd suggest running a full DBCC CHECKDB instead of just a CHECKTABLE. If it's not a problem from NO_LOCK, you don't want to miss any corruption within the database.

3

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Moz commented · May 21, 2013 at 02:44 PM

Thanks Grant. I have followed your suggestions. We are recovering the database from a backup.

0 ·

Grant Fritchey ♦♦ commented · May 21, 2013 at 02:59 PM

So you had serious corruption then? I hate when that happens.

0 ·

ThomasRushton ♦♦ commented · May 24, 2013 at 10:36 AM

@Grant - at least @Moz had a backup to go back to. I've seen situations where they've had DBCC errors for *2 years*...

0 ·

Answer 2 · 2013-05-21T09:55:20Z

raadee answered May 21, '13

[How to troubleshoot Msg 7105 in SQL Server][1] [1]: http://support.microsoft.com/kb/2015760

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Moz commented · May 21, 2013 at 10:05 AM

Thanks, but I have found and read the page, but as I'm unable to run CHECKTABLE to completion (I just get the same Msg 7105) then I am unsure which option is best. Is there anyway to get CHECKTABLE to run to completion?

0 ·

question