July 13, 2005 at 9:26 pm
Hi all,
I got serious problem about index but i still don't know season why.
Yesterday i came to my company and found an error in Window 2000 advanced server event log:
Error: 7987, Severity: 22, State: 1
A possible database consistency problem has been detected on database 'HRP'. DBCC CHECKDB and DBCC CHECKCATALOG should be run on database 'HRP'.
I run DBCC CHECKDB and found some red error:
An index on table ... node.. error..
Could you help me to find the reason and solution???
My sql server had sp4 service pack already.
Thanks
July 13, 2005 at 9:39 pm
What's the exact error?? Hard to help you without that.
July 13, 2005 at 10:43 pm
Hi, the error description is:
Table error: Object DC_Errors index 1013331120 Index node page 124452, slot 122345 refers to child page 124535 and previous child 122344, but they were not encountered.
Could u help me or give me some support link please!!!
thanks
July 14, 2005 at 8:07 am
Good news. You've got an index allocation error. Easiest kind to fix. Drop the index and recreate it. Make sure you've got the recreate script handy prior to dropping of course.
Keep an eye on the system. The occasional (read once every 18 months) allocation error is to be expected, anything more than that is an indication of a real problem; disks, fiber cards, etc..
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply