做DBCC數(shù)據(jù)庫(kù)屢次報(bào)同樣的錯(cuò)誤不止

rekcah0

Checking SKTXSJLM
Msg 2509, Level 16, State 1
Table Corrupt: The row number and offset of each row in the page should have a matching entry in row number table; check this page (page#=143474  row#=0  offset in row number table=32)
Msg 2509, Level 16, State 1
Table Corrupt: The row number and offset of each row in the page should have a matching entry in row number table; check this page (page#=143858  row#=0  offset in row number table=32)
The total number of data pages in this table is 3200.
Table has 220734 data rows.
Checking SPFPCJC
The total number of data pages in this table is 16713.
Table has 112503 data rows.
Msg 2510, Level 16, State 1
Key mismatch between index page 392079 (row 0) and data page 325889 in database <|>;YYSC_JXC<|>;. Drop and re-create index id 4 of table <|>;SPFPCJC<|>;.

重建索引或表后, 過十幾天,有相近又錯(cuò)誤出現(xiàn),且錯(cuò)誤一直出現(xiàn)在差不多相同的表上面, 百思不得其解, 求教各位前輩高人!!!!

Blackrose

建議你在業(yè)務(wù)停止時(shí)，最好在數(shù)據(jù)庫(kù)單用戶情況下做一次dbcc checkalloc
看情況再說

bluetune

請(qǐng)檢查錯(cuò)誤日志，這種情況有可能是硬件有問題，如果真是如此，錯(cuò)誤日志中會(huì)報(bào)告硬件I/O錯(cuò)誤。