Post reply

Error="8952" Severity="16" State="1 what is error number 8952 stands and solution?

  • April 23, 2013 at 5:52 am

    #277000

    What is the error number 8952 and remedy to fix the same.

    <DbccResults>

    <Dbcc ID="0" Error="8952" Severity="16" State="1">Table error: table 'backupmediaset' (ID 1858105660). Index row

    in index 'backupmediasetuuid' (ID 2) does not match any data row. Possible extra or invalid keys for:</Dbcc>

    <Dbcc ID="1" Error="8956" Severity="16" State="1">Index row (1:952:151) with values (media_uuid = 'F039C1AB-8103-

    4D9D-B0F6-86D4968938C3' and media_set_id = 22433) pointing to the data row identified by (media_set_id = 22433).<

    /Dbcc>

    <Dbcc ID="2" Error="8952" Severity="16" State="1">Table error: table 'backupmediaset' (ID 1858105660). Index row

    in index 'backupmediasetuuid' (ID 2) does not match any data row. Possible extra or invalid keys for:</Dbcc>

    <Dbcc ID="3" Error="8956" Severity="16" State="1">Index row (1:1127:36) with values (media_uuid = '9F1D7A44-16E9-

    417B-B58C-DF4CEB8ACFBD' and media_set_id = 22431) pointing to the data row identified by (media_set_id = 22431).<

    /Dbcc>

    Regards,
    Amit[font="Arial"][/font]

  • April 23, 2013 at 6:07 am

    #1609012

    according to microsoft This Link for Error 8952 says it's a hardware error, and suggests a default restore from backup, i think.

    Table error: Database 'DBNAME', index 'OBJNAME.INDNAME' (ID O_ID) (index ID I_ID). Extra or invalid key for the keys:

    Explanation

    Every data row in a table (heap or clustered index) must have exactly one matching index row in every non-clustered index over that table. This error means that a non-clustered index has an index row that does not match any data row.

    There will be an accompanying 8956 message that identifies the index row and its keys, and the data row that the index row thinks it matches. There may also be accompanying 8951 and 8955 errors.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 23, 2013 at 7:21 am

    #1609039

    Thanks Lowel

    I wanted to inform you that SQL Error 8952 severity=16 and state=1 occures on SQL2005 , let me know your suggestion to reindex or create fresh indexfile.

    Regards,
    Amit[font="Arial"][/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply