Chain Linkage mismatch error 8908
Posted on 2006-11-15
I have got the following error on SQL server 2000 SP 3a
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Error: 8908, Severity: 22, State: 6
Table error: Database ID 7, object ID 73207461, index ID 6. Chain linkage mismatch. (3:1015910)->next = (3:1015911), but (3:1015911)->prev = (3:2659497).
I know which database it refers to but how can I find out which table it refers?
SQL server log shows the same reference.
I did dbcc checkdb which returned no errors.
It appears to be an index that is involved in which case I have read that a dbcc checktable repair_rebuild may fix the error. However I don't know which table to run it on.