Solved

Chain Linkage mismatch error 8908

Posted on 2006-11-15
6
2,018 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS - Date Report Options 2 30
how to just get time from a date 6 34
RESTORE A BACKUP IN SQL 2012 from SQL 2008 9 68
AD and SQL Server 2016 2 31
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
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
Via a live example, show how to shrink a transaction log file down to a reasonable size.

821 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