Database Corruption

  • Got the below error on our database on day 1

    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=12,depid=0,depsubid=0) was found in the system table sys.syssingleobjrefs (class=12).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=13,depid=1,depsubid=0) was found in the system table sys.syssingleobjrefs (class=13).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=1,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=1,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=13,depid=2,depsubid=0) was found in the system table sys.syssingleobjrefs (class=13).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=2,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=3,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=4,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=5,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=6,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=8,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=9,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=259,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=260,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=261,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=262,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=264,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=265,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=292,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=331,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=331,depsubid=0,indepid=9,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=332,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=346,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=357,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=358,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=14,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=15,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=22,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=28,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=61,depid=353,depsubid=0) was found in the system table sys.syssingleobjrefs (class=61).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=65536,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=101) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=103) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=104) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=105) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=107) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65537,depsubid=101) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65537,depsubid=103) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65537,depsubid=107) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65539,depsubid=103) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65539,depsubid=107) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65541,depsubid=101) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65541,depsubid=103) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65541,depsubid=107) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=69,depid=65542,depsubid=0) was found in the system table sys.syssingleobjrefs (class=69).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=69,depid=65543,depsubid=0) was found in the system table sys.syssingleobjrefs (class=69).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=23,depid=269244014,depsubid=0) was found in the system table sys.syssingleobjrefs (class=23).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3858, State 1: The attribute (namespace_class=20) of row (object_id=269244014) in sys.objects has an invalid value.
    CHECKDB found 0 allocation errors and 48 consistency errors not associated with any single object.
    Msg 8906, Level 16, State 1, Line 1
    Page (1:10) in database ID 18 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
    CHECKDB found 1 allocation errors and 0 consistency errors in table '(Object ID 99)' (object ID 99).
    CHECKDB found 1 allocation errors and 48 consistency errors in database 'Test'.

  • What do you mean by "day 1"? As in at product launch? If so, why not rollback to the pre-release version, as that should be the same?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • Is that a new user database or is it a master database that has been restored from another instance?
    The errors are pretty much the same as what you would get when you restore master to another server and run dbcc checkdb

    Sue

  • VastSQL - Monday, February 11, 2019 4:16 AM

    Got the below error on our database on day 1

    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=12,depid=0,depsubid=0) was found in the system table sys.syssingleobjrefs (class=12).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=13,depid=1,depsubid=0) was found in the system table sys.syssingleobjrefs (class=13).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=1,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=1,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=13,depid=2,depsubid=0) was found in the system table sys.syssingleobjrefs (class=13).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=2,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=3,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=4,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=5,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=6,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=8,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=9,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=259,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=260,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=261,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=262,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=264,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=265,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=292,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=331,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=331,depsubid=0,indepid=9,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=332,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=346,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=357,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=358,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=14,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=15,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=22,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=28,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=61,depid=353,depsubid=0) was found in the system table sys.syssingleobjrefs (class=61).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=65536,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=101) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=103) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=104) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=105) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=107) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65537,depsubid=101) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65537,depsubid=103) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65537,depsubid=107) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65539,depsubid=103) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65539,depsubid=107) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65541,depsubid=101) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65541,depsubid=103) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65541,depsubid=107) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=69,depid=65542,depsubid=0) was found in the system table sys.syssingleobjrefs (class=69).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=69,depid=65543,depsubid=0) was found in the system table sys.syssingleobjrefs (class=69).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=23,depid=269244014,depsubid=0) was found in the system table sys.syssingleobjrefs (class=23).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3858, State 1: The attribute (namespace_class=20) of row (object_id=269244014) in sys.objects has an invalid value.
    CHECKDB found 0 allocation errors and 48 consistency errors not associated with any single object.
    Msg 8906, Level 16, State 1, Line 1
    Page (1:10) in database ID 18 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
    CHECKDB found 1 allocation errors and 0 consistency errors in table '(Object ID 99)' (object ID 99).
    CHECKDB found 1 allocation errors and 48 consistency errors in database 'Test'.

    Quick questions,
    1. Can you please post the full and unedited output of DBCC CHECKDB (DBName) WITH NO_INFOMSGS, ALL_ERRORMSGS; ?
    2. Do you have an un-corrupted backup or any other ways of rebuilding the database?
    3. Is this a user database with the db_id of 18?
    😎

  • Thom A - Monday, February 11, 2019 4:39 AM

    What do you mean by "day 1"? As in at product launch? If so, why not rollback to the pre-release version, as that should be the same?

    The next day the backup of database failed the error list was even bigger. Thought will post that once get some insight into this.

  • Sue_H - Monday, February 11, 2019 8:00 AM

    Is that a new user database or is it a master database that has been restored from another instance?
    The errors are pretty much the same as what you would get when you restore master to another server and run dbcc checkdb

    Sue

    Yes sue. its a master database with many user objects from a test server

  • Eirikur Eiriksson - Monday, February 11, 2019 8:14 AM

    VastSQL - Monday, February 11, 2019 4:16 AM

    Got the below error on our database on day 1

    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=12,depid=0,depsubid=0) was found in the system table sys.syssingleobjrefs (class=12).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=13,depid=1,depsubid=0) was found in the system table sys.syssingleobjrefs (class=13).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=1,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=1,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=13,depid=2,depsubid=0) was found in the system table sys.syssingleobjrefs (class=13).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=2,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=3,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=4,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=5,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=6,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=8,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=9,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=259,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=260,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=261,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=262,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=264,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=265,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=292,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=331,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=331,depsubid=0,indepid=9,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=332,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=346,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=357,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=358,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=14,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=15,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=22,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=104,depid=28,depsubid=0) was found in the system table sys.syssingleobjrefs (class=104).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=61,depid=353,depsubid=0) was found in the system table sys.syssingleobjrefs (class=61).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=65536,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=101) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=103) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=104) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=105) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=107) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65537,depsubid=101) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65537,depsubid=103) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65537,depsubid=107) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65539,depsubid=103) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65539,depsubid=107) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65541,depsubid=101) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65541,depsubid=103) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65541,depsubid=107) was found in the system table sys.syssingleobjrefs (class=76).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=69,depid=65542,depsubid=0) was found in the system table sys.syssingleobjrefs (class=69).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=69,depid=65543,depsubid=0) was found in the system table sys.syssingleobjrefs (class=69).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3851, State 1: An invalid row (class=23,depid=269244014,depsubid=0) was found in the system table sys.syssingleobjrefs (class=23).
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3858, State 1: The attribute (namespace_class=20) of row (object_id=269244014) in sys.objects has an invalid value.
    CHECKDB found 0 allocation errors and 48 consistency errors not associated with any single object.
    Msg 8906, Level 16, State 1, Line 1
    Page (1:10) in database ID 18 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
    CHECKDB found 1 allocation errors and 0 consistency errors in table '(Object ID 99)' (object ID 99).
    CHECKDB found 1 allocation errors and 48 consistency errors in database 'Test'.

    Quick questions,
    1. Can you please post the full and unedited output of DBCC CHECKDB (DBName) WITH NO_INFOMSGS, ALL_ERRORMSGS; ?
    2. Do you have an un-corrupted backup or any other ways of rebuilding the database?
    3. Is this a user database with the db_id of 18?
    😎

    Thanks Eirikur for the response.
    1.This is full after restoring the backup to a different server.
    2.We have got different error on second day with backup even failed and then only the user informed us.
    3.this is a master database where the user created objects on it.

  • VastSQL - Monday, February 11, 2019 9:45 PM

    Sue_H - Monday, February 11, 2019 8:00 AM

    Is that a new user database or is it a master database that has been restored from another instance?
    The errors are pretty much the same as what you would get when you restore master to another server and run dbcc checkdb

    Sue

    Yes sue. its a master database with many user objects from a test server

    The issue is it's master and that's a known issue when you restore master onto another server. There is meta data that can only exist in master (a database named master). That's where the error for page 10 on file 1 comes from. I know I read about in a few place but can only find this link right now:
    Is my master database really corrupt?

    Sue

  • Sue_H - Tuesday, February 12, 2019 6:24 AM

    VastSQL - Monday, February 11, 2019 9:45 PM

    Sue_H - Monday, February 11, 2019 8:00 AM

    Is that a new user database or is it a master database that has been restored from another instance?
    The errors are pretty much the same as what you would get when you restore master to another server and run dbcc checkdb

    Sue

    Yes sue. its a master database with many user objects from a test server

    The issue is it's master and that's a known issue when you restore master onto another server. There is meta data that can only exist in master (a database named master). That's where the error for page 10 on file 1 comes from. I know I read about in a few place but can only find this link right now:
    Is my master database really corrupt?

    Sue

    The issue occurred when the database was master of a server but with user objects .I restored it to another server to find the error.

  • This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

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