修复DBCC CHECKDB错误

Question

我运行了一个CHECKDB，它显示了以下错误

Msg 8928, Level 16, State 1, Line 1
Object ID 302676176, index ID 1, partition ID 72057594076135424, alloc unit ID 72057594090225664 (type In-row data): Page (1:262631) could not be processed.  See other errors for details.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 302676176, index ID 1, partition ID 72057594076135424, alloc unit ID 72057594090225664 (type In-row data). Page (1:262631) was not seen in the scan although its parent (1:263401) and previous (1:262630) refer to it. Check any previous errors.
Msg 8944, Level 16, State 13, Line 1
Table error: Object ID 302676176, index ID 1, partition ID 72057594076135424, alloc unit ID 72057594090225664 (type In-row data), page (1:262631), row 95. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1730 and 45.
Msg 8944, Level 16, State 13, Line 1
Table error: Object ID 302676176, index ID 1, partition ID 72057594076135424, alloc unit ID 72057594090225664 (type In-row data), page (1:262631), row 95. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1730 and 45.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 302676176, index ID 1, partition ID 72057594076135424, alloc unit ID 72057594090225664 (type In-row data). Page (1:262640) is missing a reference from previous page (1:262631). Possible chain linkage problem.
Msg 8928, Level 16, State 1, Line 1
Object ID 302676176, index ID 1, partition ID 72057594076135424, alloc unit ID 72057594090225664 (type In-row data): Page (1:3143601) could not be processed.  See other errors for details.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 302676176, index ID 1, partition ID 72057594076135424, alloc unit ID 72057594090225664 (type In-row data). Page (1:3143601) was not seen in the scan although its parent (1:3143681) and previous (1:3143600) refer to it. Check any previous errors.
Msg 8944, Level 16, State 13, Line 1

如何修复表中的一致性错误？

Answer 1

对我来说，这更多的是索引一致性问题，尽管您可以尝试删除并重新创建对象302676176的索引ID=1 (select object_name(302676176)将为您提供表名)。

第二个选项是DBCC CHECKTABLE (，REPAIR_REBUILD)

第三个也是最后一个选项是DBCC CHECKTABLE (，REPAIR_ALLOW_DATA_LOSS)。