Sysindexes table problems

• RoadRunner

  SSC-Addicted

  Points: 409

  More actions

  October 4, 2004 at 8:19 am

  #85610

  We are running SQL2000 and encountered over 7000 errors, similar

  to those below, when running CHECKDB.

  DBCC results for 'sysindexes'.

  Server: Msg 8929, Level 16, State 1, Line 1

  Object ID 2: Errors found in text ID 196608 owned by data record identified by RID = (1:24:1) id = 1 and indid = 2.

  Server: Msg 8929, Level 16, State 1, Line 1

  Object ID 2: Errors found in text ID 262144 owned by data record identified by RID = (1:24:2) id = 1 and indid = 3.

  Server: Msg 8929, Level 16, State 1, Line 1

  Object ID 2: Errors found in text ID 12517376 owned by data record identified by RID = (1:24:3) id = 2 and indid = 1.

  Is there a way to fix the sysindexes table without doing a restore?

  Would trying to run DBCC DBREINDEX('sysindexes') help?

  TIA.

• cpack

  Ten Centuries

  Points: 1239

  More actions

  October 4, 2004 at 9:06 am

  #525246

  i would definitely try to reindex the database. Not on prod though!!!

  eventid.net might have some more detailed info on your error as well.

  Cody Pack
  MCSE Windows 2000
  MCDBA SQL Server 2000

• N. Subramanian

  SSC Enthusiast

  Points: 178

  More actions

  October 5, 2004 at 6:49 am

  #525374

  hi,

  these are but header problems

  these errors can be fixed

  try this

  dbcc checkdb (dbname,REPAIR_REBUILD)