Chain linkage mismatch....

[DLu]

Server: Msg 8908, Level 22, State 6,
on index defragmentation on a table.

Table error: Database ID 490, object ID 517576882, index ID 0. Chain linkage mismatch. (1:13020)->next = (1:13021), but (1:13021)->prev = (1:13080).

from error.log found corresponding error on dbcc checkdatabase on this same database:
I/O error (bad page ID) detected during read at offset 0x00000006614000 in file
'T:\Data\ABC\ABC_data.mdf'..
Waiting for type 0x4, current count 0x100022, current owning EC 0x76A85540.
Error: 823, Severity: 24, State: 2

is there a way to fix this chain linkage mismatch error?
thanks
-D

[rmiao]

Tried 'with repair' option in dbcc?

[DLu]

rmiao:
thanks for the info. But which DBCC to go with 'with repair' option?
both checkdb and indexdefrag don't have this option.
-D

[rmiao]

Use 'dbcc checkdb' or 'dbcc check table', both have three repair options.

[DLu]

Thank you Rmiao, it works.