Solved

Chain Linkage mismatch error 8908

Posted on 2006-11-15
6
1,992 Views
Last Modified: 2009-12-16
I have got the following error on SQL server 2000 SP 3a


Event Type:      Error
Event Source:      MSSQLSERVER
Event Category:      (2)
Event ID:      17052
Date:            15/Nov/2006
Time:            11:11:58
User:            N/A
Computer:      ZAJHBMUR-SQL01
Description:
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.

Please advise
Mike Ward
0
Comment
Question by:MURSHIP
  • 4
  • 2
6 Comments
 
LVL 6

Expert Comment

by:wtapsell
ID: 17946258
select
0
 
LVL 6

Expert Comment

by:wtapsell
ID: 17946270
Have you tried looking in the sysobjects table of the relevant database?
0
 
LVL 6

Accepted Solution

by:
wtapsell earned 500 total points
ID: 17946285
For the relevant table:

select      *
from      sysobjects
where      id = 73207461


For the relevant index:

select      *
from      sysindexes
where      id = 73207461
and            indid = 6
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 

Author Comment

by:MURSHIP
ID: 17946350
Many thanks that worked I have the index name and table now.

If I drop the index and recreate it would this fix the error?

Regards
Mike
0
 
LVL 6

Expert Comment

by:wtapsell
ID: 17946826

That should work.
0
 

Author Comment

by:MURSHIP
ID: 17946843
Many thanks

Regards
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now