Post reply

Table error: table 'sys.sysschobjs' corrupt

  • July 22, 2016 at 1:59 am

    #315441

    Dear All

    i've problems with sys.sysschobjs table

    I'run dbcc

    DBCC CHECKDB('PRI701',REPAIR_ALLOW_DATA_LOSS)

    WITH NO_INFOMSGS,ALL_ERRORMSGS

    and output is

    Msg 8951, Level 16, State 1, Line 2

    Table error: table 'sys.sysschobjs' (ID 34). Data row does not have a matching index row in the index 'nc1' (ID 2).

    Possible missing or invalid keys for the index row matching:

    Msg 8955, Level 16, State 1, Line 2

    Data row (1:145562:35) identified by (id = 1278131469) with index values 'nsclass = 0 and nsid = 1 and name = ', and id = 1278131469'.

    Msg 8951, Level 16, State 1, Line 2

    Table error: table 'sys.sysschobjs' (ID 34). Data row does not have a matching index row in the index 'nc2' (ID 3).

    Possible missing or invalid keys for the index row matching:

    Msg 8955, Level 16, State 1, Line 2

    Data row (1:145562:35) identified by (id = 1278131469) with index values 'name = 'TMP_EmpresasAplicacoes' and nsid = 1 and nsclass = 0 and id = 1278131469'.

    Msg 8951, Level 16, State 1, Line 2

    Table error: table 'sys.sysschobjs' (ID 34). Data row does not have a matching index row in the index 'nc3' (ID 4).

    Possible missing or invalid keys for the index row matching:

    Msg 8955, Level 16, State 1, Line 2

    Data row (1:145562:35) identified by (id = 1278131469) with index values 'pid = 0 and pclass = 1 and id = 1278131469'.

    CHECKDB found 0 allocation errors and 3 consistency errors in table 'sys.sysschobjs' (object ID 34).

    Msg 8935, Level 16, State 1, Line 2

    Table error: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). The previous link (1:49982) on page (1:414) does not match the previous page (1:49598) that the parent (1:6243), slot 154 expects for this page.

    Msg 8978, Level 16, State 1, Line 2

    Table error: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). Page (1:414) is missing a reference from previous page (1:49982). Possible chain linkage problem.

    Msg 10054, Level 20, State 0, Line 0

    The erro is the entry 'name = 'TMP_EmpresasAplicacoes' id = 1278131469'

    i work in Dedicated Admin Connection

    DELETE FROM sys.sysschobjs where id = 1278131469 is not possible

    I read

    http://www.sqlskills.com/blogs/paul/disaster-recovery-101-fixing-metadata-corruption-without-a-backup/

    but i don't find solution 🙁

    Thanks in Advance.

  • July 22, 2016 at 2:31 am

    #1891511

    Quick questions, do you have recent good backups? What did you try before using REPAIR_ALLOW_DATA_LOSS?

    😎

  • July 22, 2016 at 2:42 am

    #1891512

    Unhappy I don't have a valid backup.

    I've PRIMAVERA 8 ERP, i want to upgrade version 9,

    but the process has errors .

    It is this moment when i discovered this error in sys.sysschobjs.

    🙁

  • July 22, 2016 at 3:23 am

    #1891515

    Restore from your last good backup. Damaged system table, that DB is toast, not repairable.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 22, 2016 at 3:46 am

    #1891517

    I' dont have a good backup 🙁

  • July 22, 2016 at 3:53 am

    #1891519

    Then you're going to need to script objects, export data and recreate the DB from scratch (and some stuff may fail to script or export due to the corruption)

    Once you get the DB recreated, set up a proper backup strategy along with regular integrity checks.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 26, 2016 at 12:18 am

    #1891962

    smura (7/22/2016)

    I' dont have a good backup 🙁

    In such situation third party MS SQL data recovery[/url] is the best option for you to recover corrupt SQL server table without any data lose.

Viewing 7 posts - 1 through 6 (of 6 total)

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