Home > IT Answers > SQL Server > SQL Server error message 'Could not find the ...

Question

Asked: May 7 2008 4:21 PM GMT
Asked by: SQL Server Ask the Experts

SQL Server error message 'Could not find the index entry for RID '1628000000a412030044160000869a0000040000' in the database

I'm getting the error 'Could not find the index entry for RID '1628000000a412030044160000869a0000040000' in the database. The table is a very big table and lots of transactions are happening every minute. Please let me know what would be the possible cause and solution for this problem.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.

Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER

View History

RATE THIS ANSWER

0
Click to Vote:

Last Answered: May 7 2008 6:16 PM GMT by Mrdenny

This is generaly an indication that your index has become corrupt and needs to be rebuilt. If you have SQL 2005 Enterprise Edtion you can do this online without an outage to your users. If you have SQL 2005 Standard, or SQL 2000 any edition you will need to schedule an outage window to do this operation.

How large is the table?