Error 644

Severity Level 21

Message Text

The non_clustered leaf row entry for page %ld row %d was not found in index page %ld indexid %d database '%.*s'

Explanation

This error occurs when the nonclustered index indicated by indexid is corrupt. The corruption is detected when a process tries to delete a nonexistent row.

Action

Drop and re-create the index, as follows:

  1. Record the value of index page and indexid specified in the error text.
  2. Identify which table and index correspond to the index page number. Use the instructions in "Associating a Page with an Object," in Chapter 24, "Additional Problem-solving Techniques."
  3. Note the object ID.

    If the object with the error is a system table (the object ID is less than 100), you cannot drop the index. Restore the database from a known clean backup.

  4. If the object ID is greater than 100, drop and re-create the index using the table name and index name obtained in step 1. In most cases, this will clear the corruption.
  5. Run dbcc checktable and dbcc CHECKALLOC on the affected table to verify that all problems have been resolved. For information about using DBCC, see the Microsoft SQL Server Transact-SQL Reference.

If problems persist, this procedure might not be sufficient to clean up the index corruption. In this case, contact your primary support provider. Have the output from the appropriate DBCC statements available for review.