I am getting Error 644 every 15 minutes in my Event Viewer

• bubby

  SSCertifiable

  Points: 5638

  More actions

  August 18, 2008 at 6:15 am

  #189491

  Hello,

  I would highly appreciate if I can attain any help in regard to the below error I am getting every 5 minutes,

  Error: 644, Severity: 21, State: 3

  Could not find the index entry for RID '61271fc71106b06807407407003a02f02f07006f07207406106c02e06306102e069063073' in index page (1:25059), index ID 0, database 'Moss_ssp_DB'.

  I have done few things but I do not get any error,

  1. I have run the command to check the DB

  2. DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS

  4. DBCC CHECKDB (dbname) WITH ALL_ERRORMSGS, NO_INFOMSGS

  5. DBCC PAGE (MOSS_ssp_DB, 1, 25059, 3)

  6. DBCC REINDEX

  Please advice what I can do to resolve this issue,

  I also tried restoring the database of the good backup,

  Thanks,

  Dev

• Felicitywie

  Right there with Babe

  Points: 717

  More actions

  August 18, 2008 at 6:29 am

  #859390

  I had a similar error last week and ended up rebuilding the indexes. Check the following article:

  http://msdn.microsoft.com/en-us/library/aa258731.aspx

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736183

  More actions

  August 18, 2008 at 7:30 am

  #859427

  Corruption errors are almost always hardware related, so I'd get the hardware checked.

  You can try dropping and rebuilding the affected index, however that doesn't necessarily address the underlying cause.

  REPAIR_DATA_LOSS should be your last effort. And you should really call MS before running it. (http://www.sqlskills.com/blogs/paul/2007/09/13/CommonBadAdviceAroundDisasterRecovery.aspx).