5
(3)

Error Description:

Error: 644, Severity: 21, State:
server Index row entry for data row id (1234, 0) is missing from index page 5678 of index id 3 of table 'test' in database 'TestDB'. Xactid is (123456,30). Drop and re-create the index.

Resolution:

Step#1: Find out object id from the given object name

use TestDB
go
select id from sysobjects where name='test'
go

———————

123456789
987654321

Step#2: Find out index name using given indexid and object id obtained in step#1

select name from sysindexes where id=123456789 and indid=3
go

—————-

index1

repeat the same for other object id

select name from sysindexes where id=987654321 and indid=3
go

—————-

index2

Step#3: Drop and re-create these 2 indexes and it should resolve the issue.
Step#4: To verify if affected table is now error free, run dbcc checktable and dbcc tablealloc

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 3

No votes so far! Be the first to rate this post.