Chain linkage mismatch

• Jayakumar Krishnan

  SSCarpal Tunnel

  Points: 4710

  More actions

  February 20, 2006 at 4:41 am

  #170702

  Hi Folks,

  I'm facing this error in one of my databases.

  Error: 8908, Severity: 22, State: 6 Table error: Database ID 4, object ID 2073058421, index ID 2. Chain linkage mismatch. (1:90740)->next = (1:111895), but (1:111895)->prev = (1:55045).

   

  What could be the reasons for this problem.

  Please help me out ASAP.

   

  waremst

  Jayakumar K.

  Thanks
  Jay
  http://www.sqldbops.com

• SQLZ

  SSChampion

  Points: 12872

  More actions

  February 20, 2006 at 4:43 am

  #621967

  Does this article help?

  http://support.microsoft.com/kb/811205

  Karl
  source control for SQL Server

• Jayakumar Krishnan

  SSCarpal Tunnel

  Points: 4710

  More actions

  February 20, 2006 at 4:51 am

  #621970

  Thanks for your immediate reply.

   

  Jayakumar K

  Thanks
  Jay
  http://www.sqldbops.com

• Balmukund

  SSCertifiable

  Points: 6648

  More actions

  February 20, 2006 at 4:55 am

  #621974

  Did you try running DBCC CHECKDB for the database? This is to make sure there is no corruption in database.