dbcc checktable之后的报错解决办法
在执行dbcc checktable('fin_close')之后报了如下错误:
DBCC results for 'FIN_CLOSE'.
Msg 8952, Level 16, State 1, Line 2
Table error: Table 'FIN_CLOSE' (ID 1026102696). Index row in index 'I_FIN_CLOSE_tender_code_sto_' (ID 2) does not match any data row. Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 2
Index row (1:59049:413) with values (TENDER_CODE = 'AMEX' and STORE_CODE_ID = 16 and Sequence = '1 ' and SESSION_NUMBER = 414) pointing to the data row identified by (STORE_CODE_ID = 16 and Sequence = '1 ' and SESSION_NUMBER = 414 and TENDER_CODE = 'AMEX').
There are 5369 rows in 98 pages for object "FIN_CLOSE".
CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'FIN_CLOSE' (object ID 1026102696).
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKTABLE (xpert_standalone.dbo.FIN_CLOSE).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
请问这段sql server的提示信息主要说的是个什么问题? 大概说一下就行,谢谢了