August 18, 2008 at 6:15 am
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
August 18, 2008 at 6:29 am
I had a similar error last week and ended up rebuilding the indexes. Check the following article:
August 18, 2008 at 7:30 am
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).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply