June 27, 2005 at 11:23 am
We found the following error 4 times in our SQL Server 2000 Service Pack 4 (SP4) log:
Error: 644, Severity: 21, State: 3
Could not find the index entry for RID '163030314f564d30353034200' in index page (1:40729731), index ID 0, database 'MyDB'..
The last time it happened in the middle of the delete process, previous time during the reading process.
We run checkDB and result is 162 consistency errors in database 'MyDB'. The errors are like that:
Server: Msg 2511, Level 16, State 2, Line 1
Table error: Object ID 1141579105, Index ID 0. Keys out of order on page (1:40729731), slots 14 and 15.
Server: Msg 2512, Level 16, State 1, Line 1
Table error: Object ID 1141579105, Index ID 0. Duplicate keys on page (1:40729731) slot 28 and page (1:40729731) slot 29.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1141579105, Index ID 2. Keys out of order on page (1:41115503), slots 428 and 429.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1141579105, Index ID 2. Keys out of order on page (1:41117738), slots 131 and 132.
What we have to do? Will rebuilding indexes help or we have to do some additional steps? Can Dbcc dbrecover help?
What may be the reason for the problem?
Thank you for your help,
a_k_
June 27, 2005 at 1:01 pm
See my post here:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=194423
by the way when you have index ID = 0 you are actually refering to a HEAP. Can you make sure those tables have a clustered index on it !
* Noel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply