DBCC CheckTable Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

DBCC CheckTable Error

Author

Topic

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-11-28 : 01:25:48

Hello I am getting this error

Msg 8928, Level 16, State 1, Line 1
Object ID 181940070, index ID 1, partition ID 72057599959105536, alloc unit ID 71788042685644800 (type LOB data): Page (3:3540809) could not be processed. See other errors for details.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 181940070, index ID 1, partition ID 72057599959105536, alloc unit ID 71788042685644800 (type LOB data), page (3:3540809). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 29362185 and -1.
Repairing this error requires other errors to be corrected first.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 181940070, index ID 1, partition ID 72057599959105536, alloc unit ID 71788042685644800 (type LOB data). The off-row data node at page (3:3540809), slot 0, text ID 101771514544128 is referenced by page (1:2043616), slot 2, but was not seen in the scan.
Repairing this error requires other errors to be corrected first.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 181940070, index ID 1, partition ID 72057599959105536, alloc unit ID 71788042685644800 (type LOB data). The off-row data node at page (3:3540809), slot 1, text ID 101771625168896 is referenced by page (1:767390), slot 3, but was not seen in the scan.
Repairing this error requires other errors to be corrected first.
Msg 8929, Level 16, State 1, Line 1
Object ID 181940070, index ID 1, partition ID 72057599959105536, alloc unit ID 72057600365035520 (type In-row data): Errors found in off-row data with ID 101771625168896 owned by data record identified by RID = (4:428261:88)
Repairing this error requires other errors to be corrected first.
Msg 8929, Level 16, State 1, Line 1
Object ID 181940070, index ID 1, partition ID 72057599959105536, alloc unit ID 72057600365035520 (type In-row data): Errors found in off-row data with ID 101771514544128 owned by data record identified by RID = (4:428985:71)
Repairing this error requires other errors to be corrected first.
There are 290473 rows in 2430 pages for object "tbl_case_msletter_text".
CHECKTABLE found 0 allocation errors and 6 consistency errors in table 'tbl_case_msletter_text' (object ID 181940070).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (Inszoom.dbo.tbl_case_msletter_text, repair_rebuild).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

=========================================
I dont want to run REPAIR_ALLOW_DATA_LOSS
==========================================

In Love... With Me!

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-11-28 : 05:51:18

Check the objects. If they are indexes you may be able to rebuild them (I doubt it by looking at this).
The other option is to try copying ouut into a new table using a table scan - if that doesn't work try using an index.
Or restore from backup?

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources