SSISDB Corruption.Does anyone know steps to follow to restore SSISDB from backup

  • Ash

    SSC Eights!

    Points: 826

    I restored SSISDB as is to test server. Here is the full CHECKDB result with ALLOW DATA LOSS from test server. Just looking for steps to restore SSISDB along with packages etc from backup file. Backup seems to be safe.

     

    Nonqualified transactions are being rolled back. Estimated rollback completion: 0%.
    Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.
    Msg 1505, Level 16, State 1, Line 8
    The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'internal.execution_parameter_values' and the index name 'PK_Execution_Parameter_value'. The duplicate key value is (4170603).
    The statement has been terminated.
    Msg 1505, Level 16, State 1, Line 8
    The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'internal.execution_parameter_values' and the index name 'IX_ExecutionParameterValue_ExecutionId'. The duplicate key value is (371784, 4170603).
    The statement has been terminated.
    DBCC results for 'SSISDB'.
    Service Broker Msg 9675, State 1: Message Types analyzed: 14.
    Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
    Service Broker Msg 9667, State 1: Services analyzed: 3.
    Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
    Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
    Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
    Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
    Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
    Repair: The extent (1:4786968) has been deallocated from object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown).
    Msg 8909, Level 16, State 1, Line 8
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:4786940) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
    The error has been repaired.
    Msg 8909, Level 16, State 1, Line 8
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:4786941) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
    The error has been repaired.
    Msg 8909, Level 16, State 1, Line 8
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:4786942) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
    The error has been repaired.
    Msg 8909, Level 16, State 1, Line 8
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:4786948) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
    The error has been repaired.
    Msg 8905, Level 16, State 1, Line 8
    Extent (1:4786968) in database ID 35 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
    The error has been repaired.
    Msg 8909, Level 16, State 1, Line 8
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:4786968) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
    The error has been repaired.
    Msg 8909, Level 16, State 1, Line 8
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:4786976) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
    The error has been repaired.
    Msg 8905, Level 16, State 1, Line 8
    Extent (1:4786984) in database ID 35 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
    The error has been repaired.
    Msg 8909, Level 16, State 1, Line 8
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:4786989) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
    The error has been repaired.
    Msg 8909, Level 16, State 1, Line 8
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:4786989) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
    The error has been repaired.
    Msg 8909, Level 16, State 1, Line 8
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:4786993) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
    The error has been repaired.
    Msg 8909, Level 16, State 1, Line 8
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:4786994) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
    The error has been repaired.
    Msg 8909, Level 16, State 1, Line 8
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:4786995) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
    The error has been repaired.
    Msg 8909, Level 16, State 1, Line 8
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:4786996) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
    The error has been repaired.
    Msg 8909, Level 16, State 1, Line 8
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:4786997) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
    The error has been repaired.
    Msg 8909, Level 16, State 1, Line 8
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:4787008) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
    The error has been repaired.
    Msg 8909, Level 16, State 1, Line 8
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:4787009) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
    The error has been repaired.
    CHECKDB found 2 allocation errors and 15 consistency errors not associated with any single object.
    CHECKDB fixed 2 allocation errors and 15 consistency errors not associated with any single object.
    DBCC results for 'sys.sysrscols'.
    There are 1203 rows in 15 pages for object "sys.sysrscols".
    DBCC results for 'sys.sysrowsets'.
    There are 174 rows in 2 pages for object "sys.sysrowsets".
    DBCC results for 'sys.sysclones'.
    There are 0 rows in 0 pages for object "sys.sysclones".
    DBCC results for 'sys.sysallocunits'.
    There are 216 rows in 3 pages for object "sys.sysallocunits".
    DBCC results for 'sys.sysfiles1'.
    There are 2 rows in 1 pages for object "sys.sysfiles1".
    DBCC results for 'sys.sysseobjvalues'.
    There are 0 rows in 0 pages for object "sys.sysseobjvalues".
    DBCC results for 'sys.syspriorities'.
    There are 0 rows in 0 pages for object "sys.syspriorities".
    DBCC results for 'sys.sysdbfrag'.
    There are 0 rows in 0 pages for object "sys.sysdbfrag".
    DBCC results for 'sys.sysfgfrag'.
    There are 0 rows in 0 pages for object "sys.sysfgfrag".
    DBCC results for 'sys.sysdbfiles'.
    There are 2 rows in 1 pages for object "sys.sysdbfiles".
    DBCC results for 'sys.syspru'.
    There are 0 rows in 0 pages for object "sys.syspru".
    DBCC results for 'sys.sysbrickfiles'.
    There are 0 rows in 0 pages for object "sys.sysbrickfiles".
    DBCC results for 'sys.sysphfg'.
    There are 1 rows in 1 pages for object "sys.sysphfg".
    DBCC results for 'sys.sysprufiles'.
    There are 2 rows in 1 pages for object "sys.sysprufiles".
    DBCC results for 'sys.sysftinds'.
    There are 0 rows in 0 pages for object "sys.sysftinds".
    DBCC results for 'sys.sysowners'.
    There are 27 rows in 1 pages for object "sys.sysowners".
    DBCC results for 'sys.sysdbreg'.
    There are 0 rows in 0 pages for object "sys.sysdbreg".
    DBCC results for 'sys.sysprivs'.
    There are 271 rows in 2 pages for object "sys.sysprivs".
    DBCC results for 'sys.sysschobjs'.
    There are 2439 rows in 41 pages for object "sys.sysschobjs".
    DBCC results for 'sys.syscolpars'.
    There are 1769 rows in 31 pages for object "sys.syscolpars".
    DBCC results for 'sys.sysxlgns'.
    There are 0 rows in 0 pages for object "sys.sysxlgns".
    DBCC results for 'sys.sysxsrvs'.
    There are 0 rows in 0 pages for object "sys.sysxsrvs".
    DBCC results for 'sys.sysnsobjs'.
    There are 1 rows in 1 pages for object "sys.sysnsobjs".
    DBCC results for 'sys.sysusermsgs'.
    There are 0 rows in 0 pages for object "sys.sysusermsgs".
    DBCC results for 'sys.syscerts'.
    There are 35448 rows in 11821 pages for object "sys.syscerts".
    DBCC results for 'sys.sysrmtlgns'.
    There are 0 rows in 0 pages for object "sys.sysrmtlgns".
    DBCC results for 'sys.syslnklgns'.
    There are 0 rows in 0 pages for object "sys.syslnklgns".
    DBCC results for 'sys.sysxprops'.
    There are 0 rows in 0 pages for object "sys.sysxprops".
    DBCC results for 'sys.sysscalartypes'.
    There are 51 rows in 1 pages for object "sys.sysscalartypes".
    DBCC results for 'sys.systypedsubobjs'.
    There are 0 rows in 0 pages for object "sys.systypedsubobjs".
    DBCC results for 'sys.sysidxstats'.
    There are 392 rows in 10 pages for object "sys.sysidxstats".
    DBCC results for 'sys.sysiscols'.
    There are 596 rows in 3 pages for object "sys.sysiscols".
    DBCC results for 'sys.sysendpts'.
    There are 0 rows in 0 pages for object "sys.sysendpts".
    DBCC results for 'sys.syswebmethods'.
    There are 0 rows in 0 pages for object "sys.syswebmethods".
    DBCC results for 'sys.sysbinobjs'.
    There are 23 rows in 1 pages for object "sys.sysbinobjs".
    DBCC results for 'sys.sysaudacts'.
    There are 0 rows in 0 pages for object "sys.sysaudacts".
    DBCC results for 'sys.sysobjvalues'.
    There are 563 rows in 164 pages for object "sys.sysobjvalues".
    DBCC results for 'sys.syscscolsegments'.
    There are 0 rows in 0 pages for object "sys.syscscolsegments".
    DBCC results for 'sys.syscsdictionaries'.
    There are 0 rows in 0 pages for object "sys.syscsdictionaries".
    DBCC results for 'sys.sysclsobjs'.
    There are 35468 rows in 387 pages for object "sys.sysclsobjs".
    DBCC results for 'sys.sysrowsetrefs'.
    There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
    DBCC results for 'sys.sysremsvcbinds'.
    There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
    DBCC results for 'sys.sysxmitqueue'.
    There are 0 rows in 0 pages for object "sys.sysxmitqueue".
    DBCC results for 'sys.sysrts'.
    There are 1 rows in 1 pages for object "sys.sysrts".
    DBCC results for 'sys.sysconvgroup'.
    There are 0 rows in 0 pages for object "sys.sysconvgroup".
    DBCC results for 'sys.sysdesend'.
    There are 0 rows in 0 pages for object "sys.sysdesend".
    DBCC results for 'sys.sysdercv'.
    There are 0 rows in 0 pages for object "sys.sysdercv".
    DBCC results for 'sys.syssingleobjrefs'.
    There are 71238 rows in 545 pages for object "sys.syssingleobjrefs".
    DBCC results for 'sys.sysmultiobjrefs'.
    There are 1809 rows in 16 pages for object "sys.sysmultiobjrefs".
    DBCC results for 'sys.sysguidrefs'.
    There are 35449 rows in 176 pages for object "sys.sysguidrefs".
    DBCC results for 'sys.sysfoqueues'.
    There are 0 rows in 0 pages for object "sys.sysfoqueues".
    DBCC results for 'sys.syschildinsts'.
    There are 0 rows in 0 pages for object "sys.syschildinsts".
    DBCC results for 'sys.syscompfragments'.
    There are 0 rows in 0 pages for object "sys.syscompfragments".
    DBCC results for 'sys.sysftsemanticsdb'.
    There are 0 rows in 0 pages for object "sys.sysftsemanticsdb".
    DBCC results for 'sys.sysftstops'.
    There are 0 rows in 0 pages for object "sys.sysftstops".
    DBCC results for 'sys.sysftproperties'.
    There are 0 rows in 0 pages for object "sys.sysftproperties".
    DBCC results for 'sys.sysxmitbody'.
    There are 0 rows in 0 pages for object "sys.sysxmitbody".
    DBCC results for 'sys.sysfos'.
    There are 0 rows in 0 pages for object "sys.sysfos".
    DBCC results for 'sys.sysqnames'.
    There are 100 rows in 1 pages for object "sys.sysqnames".
    DBCC results for 'sys.sysxmlcomponent'.
    There are 100 rows in 1 pages for object "sys.sysxmlcomponent".
    DBCC results for 'sys.sysxmlfacet'.
    There are 112 rows in 1 pages for object "sys.sysxmlfacet".
    DBCC results for 'sys.sysxmlplacement'.
    There are 19 rows in 1 pages for object "sys.sysxmlplacement".
    DBCC results for 'sys.sysobjkeycrypts'.
    There are 35460 rows in 781 pages for object "sys.sysobjkeycrypts".
    DBCC results for 'sys.sysasymkeys'.
    There are 0 rows in 0 pages for object "sys.sysasymkeys".
    DBCC results for 'sys.syssqlguides'.
    There are 0 rows in 0 pages for object "sys.syssqlguides".
    DBCC results for 'sys.sysbinsubobjs'.
    There are 3 rows in 1 pages for object "sys.sysbinsubobjs".
    DBCC results for 'sys.syssoftobjrefs'.
    There are 649 rows in 16 pages for object "sys.syssoftobjrefs".
    DBCC results for 'internal.folders'.
    There are 12 rows in 1 pages for object "internal.folders".
    DBCC results for 'internal.object_versions'.
    There are 96 rows in 9 pages for object "internal.object_versions".
    DBCC results for 'internal.projects'.
    There are 18 rows in 1 pages for object "internal.projects".
    DBCC results for 'internal.packages'.
    There are 648 rows in 30 pages for object "internal.packages".
    DBCC results for 'internal.object_parameters'.
    There are 6216 rows in 206 pages for object "internal.object_parameters".
    DBCC results for 'internal.environments'.
    There are 0 rows in 0 pages for object "internal.environments".
    DBCC results for 'internal.environment_variables'.
    There are 0 rows in 0 pages for object "internal.environment_variables".
    DBCC results for 'internal.environment_references'.
    There are 0 rows in 0 pages for object "internal.environment_references".
    DBCC results for 'internal.operations'.
    There are 29525 rows in 1074 pages for object "internal.operations".
    DBCC results for 'internal.extended_operation_info'.
    There are 3 rows in 1 pages for object "internal.extended_operation_info".
    DBCC results for 'internal.operation_os_sys_info'.
    There are 28691 rows in 219 pages for object "internal.operation_os_sys_info".
    DBCC results for 'internal.operation_messages'.
    Repair: The Clustered index successfully rebuilt for the object "internal.operation_messages" in database "SSISDB".
    Repair: The Nonclustered index successfully rebuilt for the object "internal.operation_messages, IX_OperationMessages_Operation_id" in database "SSISDB".
    Msg 8945, Level 16, State 1, Line 8
    Table error: Object ID 821577965, index ID 1 will be rebuilt.
    The error has been repaired.
    Msg 8935, Level 16, State 1, Line 8
    Table error: Object ID 821577965, index ID 1, partition ID 72057594040287232, alloc unit ID 72057594045267968 (type In-row data). The previous link (1:466422) on page (1:753635) does not match the previous page (1:4786927) that the parent (1:4784915), slot 456 expects for this page.
    The error has been repaired.
    Msg 8936, Level 16, State 1, Line 8
    Table error: Object ID 821577965, index ID 1, partition ID 72057594040287232, alloc unit ID 72057594045267968 (type In-row data). B-tree chain linkage mismatch. (1:4786927)->next = (1:753635), but (1:753635)->Prev = (1:466422).
    The error has been repaired.
    Msg 8978, Level 16, State 1, Line 8
    Table error: Object ID 821577965, index ID 1, partition ID 72057594040287232, alloc unit ID 72057594045267968 (type In-row data). Page (1:4786952) is missing a reference from previous page (1:753635). Possible chain linkage problem.
    The error has been repaired.
    Msg 8945, Level 16, State 1, Line 8
    Table error: Object ID 821577965, index ID 2 will be rebuilt.
    The error has been repaired.
    Msg 8978, Level 16, State 1, Line 8
    Table error: Object ID 821577965, index ID 2, partition ID 72057594043301888, alloc unit ID 72057594050117632 (type In-row data). Page (1:165003) is missing a reference from previous page (1:4786968). Possible chain linkage problem.
    The error has been repaired.
    Msg 8976, Level 16, State 1, Line 8
    Table error: Object ID 821577965, index ID 2, partition ID 72057594043301888, alloc unit ID 72057594050117632 (type In-row data). Page (1:4786968) was not seen in the scan although its parent (1:164569) and previous (1:4786678) refer to it. Check any previous errors.
    The error has been repaired.
    There are 29463368 rows in 1128150 pages for object "internal.operation_messages".
    CHECKDB found 0 allocation errors and 5 consistency errors in table 'internal.operation_messages' (object ID 821577965).
    CHECKDB fixed 0 allocation errors and 5 consistency errors in table 'internal.operation_messages' (object ID 821577965).
    DBCC results for 'internal.executions'.
    There are 28695 rows in 883 pages for object "internal.executions".
    DBCC results for 'internal.executables'.
    There are 9234 rows in 452 pages for object "internal.executables".
    DBCC results for 'internal.executable_statistics'.
    There are 1724787 rows in 79813 pages for object "internal.executable_statistics".
    DBCC results for 'internal.execution_data_statistics'.
    There are 0 rows in 0 pages for object "internal.execution_data_statistics".
    DBCC results for 'internal.execution_component_phases'.
    There are 0 rows in 1 pages for object "internal.execution_component_phases".
    DBCC results for 'internal.execution_data_taps'.
    There are 0 rows in 0 pages for object "internal.execution_data_taps".
    DBCC results for 'internal.event_messages'.
    Repair: The Clustered index successfully rebuilt for the object "internal.event_messages" in database "SSISDB".
    Repair: The page (1:4786948) has been deallocated from object ID 1157579162, index ID 1, partition ID 72057594040811520, alloc unit ID 72057594046513152 (type In-row data).
    Repair: The Nonclustered index successfully rebuilt for the object "internal.event_messages, IX_EventMessages_Operation_id" in database "SSISDB".
    Repair: The page (1:4786976) has been deallocated from object ID 1157579162, index ID 2, partition ID 72057594043498496, alloc unit ID 72057594050314240 (type In-row data).
    Msg 8945, Level 16, State 1, Line 8
    Table error: Object ID 1157579162, index ID 1 will be rebuilt.
    The error has been repaired.
    Msg 8928, Level 16, State 1, Line 8
    Object ID 1157579162, index ID 1, partition ID 72057594040811520, alloc unit ID 72057594046513152 (type In-row data): Page (1:4786948) could not be processed. See other errors for details.
    The error has been repaired.
    Msg 8976, Level 16, State 1, Line 8
    Table error: Object ID 1157579162, index ID 1, partition ID 72057594040811520, alloc unit ID 72057594046513152 (type In-row data). Page (1:4786948) was not seen in the scan although its parent (1:4786865) and previous (1:4786947) refer to it. Check any previous errors.
    The error has been repaired.
    Msg 8978, Level 16, State 1, Line 8
    Table error: Object ID 1157579162, index ID 1, partition ID 72057594040811520, alloc unit ID 72057594046513152 (type In-row data). Page (1:4786949) is missing a reference from previous page (1:4786948). Possible chain linkage problem.
    The error has been repaired.
    Msg 8945, Level 16, State 1, Line 8
    Table error: Object ID 1157579162, index ID 2 will be rebuilt.
    The error has been repaired.
    Msg 8978, Level 16, State 1, Line 8
    Table error: Object ID 1157579162, index ID 2, partition ID 72057594043498496, alloc unit ID 72057594050314240 (type In-row data). Page (1:239707) is missing a reference from previous page (1:4786976). Possible chain linkage problem.
    The error has been repaired.
    Msg 8928, Level 16, State 1, Line 8
    Object ID 1157579162, index ID 2, partition ID 72057594043498496, alloc unit ID 72057594050314240 (type In-row data): Page (1:4786976) could not be processed. See other errors for details.
    The error has been repaired.
    Msg 8976, Level 16, State 1, Line 8
    Table error: Object ID 1157579162, index ID 2, partition ID 72057594043498496, alloc unit ID 72057594050314240 (type In-row data). Page (1:4786976) was not seen in the scan although its parent (1:4781655) and previous (1:4786686) refer to it. Check any previous errors.
    The error has been repaired.
    There are 29463376 rows in 3093603 pages for object "internal.event_messages".
    CHECKDB found 0 allocation errors and 6 consistency errors in table 'internal.event_messages' (object ID 1157579162).
    CHECKDB fixed 0 allocation errors and 6 consistency errors in table 'internal.event_messages' (object ID 1157579162).
    DBCC results for 'internal.event_message_context'.
    Repair: The Clustered index successfully rebuilt for the object "internal.event_message_context" in database "SSISDB".
    Repair: The page (1:4786940) has been deallocated from object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data).
    Repair: The page (1:4786941) has been deallocated from object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data).
    Repair: The page (1:4786942) has been deallocated from object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data).
    Repair: The page (1:4786993) has been deallocated from object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data).
    Repair: The page (1:4786994) has been deallocated from object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data).
    Repair: The page (1:4786995) has been deallocated from object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data).
    Repair: The page (1:4786996) has been deallocated from object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data).
    Repair: The page (1:4786997) has been deallocated from object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data).
    Repair: The page (1:4787008) has been deallocated from object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data).
    Repair: The page (1:4787009) has been deallocated from object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data).
    Repair: The Nonclustered index successfully rebuilt for the object "internal.event_message_context, IX_EventMessageContext_Operation_id" in database "SSISDB".
    Msg 8945, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 1 will be rebuilt.
    The error has been repaired.
    Msg 8935, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data). The previous link (1:789511) on page (1:831275) does not match the previous page (1:4786999) that the parent (1:4786615), slot 397 expects for this page.
    The error has been repaired.
    Msg 8936, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data). B-tree chain linkage mismatch. (1:4786999)->next = (1:831275), but (1:831275)->Prev = (1:789511).
    The error has been repaired.
    Msg 8928, Level 16, State 1, Line 8
    Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data): Page (1:4786940) could not be processed. See other errors for details.
    The error has been repaired.
    Msg 8980, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data). Index node page (1:4786615), slot 385 refers to child page (1:4786940) and previous child (1:4786939), but they were not encountered.
    The error has been repaired.
    Msg 8928, Level 16, State 1, Line 8
    Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data): Page (1:4786941) could not be processed. See other errors for details.
    The error has been repaired.
    Msg 8980, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data). Index node page (1:4786615), slot 386 refers to child page (1:4786941) and previous child (1:4786940), but they were not encountered.
    The error has been repaired.
    Msg 8928, Level 16, State 1, Line 8
    Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data): Page (1:4786942) could not be processed. See other errors for details.
    The error has been repaired.
    Msg 8980, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data). Index node page (1:4786615), slot 387 refers to child page (1:4786942) and previous child (1:4786941), but they were not encountered.
    The error has been repaired.
    Msg 8978, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data). Page (1:4786943) is missing a reference from previous page (1:4786942). Possible chain linkage problem.
    The error has been repaired.
    Msg 8928, Level 16, State 1, Line 8
    Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data): Page (1:4786993) could not be processed. See other errors for details.
    The error has been repaired.
    Msg 8976, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data). Page (1:4786993) was not seen in the scan although its parent (1:4786615) and previous (1:4786992) refer to it. Check any previous errors.
    The error has been repaired.
    Msg 8928, Level 16, State 1, Line 8
    Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data): Page (1:4786994) could not be processed. See other errors for details.
    The error has been repaired.
    Msg 8980, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data). Index node page (1:4786615), slot 391 refers to child page (1:4786994) and previous child (1:4786993), but they were not encountered.
    The error has been repaired.
    Msg 8928, Level 16, State 1, Line 8
    Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data): Page (1:4786995) could not be processed. See other errors for details.
    The error has been repaired.
    Msg 8980, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data). Index node page (1:4786615), slot 392 refers to child page (1:4786995) and previous child (1:4786994), but they were not encountered.
    The error has been repaired.
    Msg 8928, Level 16, State 1, Line 8
    Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data): Page (1:4786996) could not be processed. See other errors for details.
    The error has been repaired.
    Msg 8980, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data). Index node page (1:4786615), slot 393 refers to child page (1:4786996) and previous child (1:4786995), but they were not encountered.
    The error has been repaired.
    Msg 8928, Level 16, State 1, Line 8
    Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data): Page (1:4786997) could not be processed. See other errors for details.
    The error has been repaired.
    Msg 8980, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data). Index node page (1:4786615), slot 394 refers to child page (1:4786997) and previous child (1:4786996), but they were not encountered.
    The error has been repaired.
    Msg 8978, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data). Page (1:4786998) is missing a reference from previous page (1:4786997). Possible chain linkage problem.
    The error has been repaired.
    Msg 8928, Level 16, State 1, Line 8
    Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data): Page (1:4787008) could not be processed. See other errors for details.
    The error has been repaired.
    Msg 8980, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data). Index node page (1:4786615), slot 398 refers to child page (1:4787008) and previous child (1:831275), but they were not encountered.
    The error has been repaired.
    Msg 8928, Level 16, State 1, Line 8
    Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data): Page (1:4787009) could not be processed. See other errors for details.
    The error has been repaired.
    Msg 8980, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data). Index node page (1:4786615), slot 399 refers to child page (1:4787009) and previous child (1:4787008), but they were not encountered.
    The error has been repaired.
    Msg 8978, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046709760 (type In-row data). Page (1:4787010) is missing a reference from previous page (1:4787009). Possible chain linkage problem.
    The error has been repaired.
    Msg 8945, Level 16, State 1, Line 8
    Table error: Object ID 1221579390, index ID 2 will be rebuilt.
    The error has been repaired.
    There are 5490088 rows in 188446 pages for object "internal.event_message_context".
    CHECKDB found 0 allocation errors and 25 consistency errors in table 'internal.event_message_context' (object ID 1221579390).
    CHECKDB fixed 0 allocation errors and 25 consistency errors in table 'internal.event_message_context' (object ID 1221579390).
    DBCC results for 'internal.execution_parameter_values'.
    Repair: The extent (1:4786984) has been allocated to object ID 1285579618, index ID 1, partition ID 72057594042515456, alloc unit ID 72057594049200128 (type In-row data).
    Repair: The page (1:4786989) has been deallocated from object ID 1285579618, index ID 1, partition ID 72057594042515456, alloc unit ID 72057594049200128 (type In-row data).
    Msg 8945, Level 16, State 1, Line 8
    Table error: Object ID 1285579618, index ID 1 will be rebuilt.
    Could not repair this error.
    Msg 8978, Level 16, State 1, Line 8
    Table error: Object ID 1285579618, index ID 1, partition ID 72057594042515456, alloc unit ID 72057594049200128 (type In-row data). Page (1:4786985) is missing a reference from previous page (1:4786847). Possible chain linkage problem.
    The error has been repaired.
    Msg 8978, Level 16, State 1, Line 8
    Table error: Object ID 1285579618, index ID 1, partition ID 72057594042515456, alloc unit ID 72057594049200128 (type In-row data). Page (1:4786988) is missing a reference from previous page (1:4786989). Possible chain linkage problem.
    The error has been repaired.
    Msg 8928, Level 16, State 1, Line 8
    Object ID 1285579618, index ID 1, partition ID 72057594042515456, alloc unit ID 72057594049200128 (type In-row data): Page (1:4786989) could not be processed. See other errors for details.
    The error has been repaired.
    Msg 8976, Level 16, State 1, Line 8
    Table error: Object ID 1285579618, index ID 1, partition ID 72057594042515456, alloc unit ID 72057594049200128 (type In-row data). Page (1:4786989) was not seen in the scan although its parent (1:4785292) and previous (1:4786986) refer to it. Check any previous errors.
    The error has been repaired.
    Msg 8945, Level 16, State 1, Line 8
    Table error: Object ID 1285579618, index ID 2 will be rebuilt.
    Could not repair this error.
    There are 1114489 rows in 25321 pages for object "internal.execution_parameter_values".
    CHECKDB found 0 allocation errors and 4 consistency errors in table 'internal.execution_parameter_values' (object ID 1285579618).
    CHECKDB fixed 0 allocation errors and 4 consistency errors in table 'internal.execution_parameter_values' (object ID 1285579618).
    DBCC results for 'internal.execution_property_override_values'.
    There are 0 rows in 0 pages for object "internal.execution_property_override_values".
    DBCC results for 'internal.validations'.
    There are 1 rows in 1 pages for object "internal.validations".
    DBCC results for 'internal.catalog_properties'.
    There are 9 rows in 1 pages for object "internal.catalog_properties".
    DBCC results for 'internal.folder_permissions'.
    There are 0 rows in 0 pages for object "internal.folder_permissions".
    DBCC results for 'internal.project_permissions'.
    There are 72 rows in 1 pages for object "internal.project_permissions".
    DBCC results for 'internal.environment_permissions'.
    There are 0 rows in 0 pages for object "internal.environment_permissions".
    DBCC results for 'internal.operation_permissions'.
    There are 86385 rows in 389 pages for object "internal.operation_permissions".
    DBCC results for 'internal.data_type_mapping'.
    There are 58 rows in 1 pages for object "internal.data_type_mapping".
    DBCC results for 'internal.catalog_encryption_keys'.
    There are 18 rows in 1 pages for object "internal.catalog_encryption_keys".
    DBCC results for 'sys.queue_messages_1977058079'.
    There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
    DBCC results for 'sys.queue_messages_2009058193'.
    There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
    DBCC results for 'sys.queue_messages_2041058307'.
    There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
    DBCC results for 'sys.filestream_tombstone_2073058421'.
    There are 0 rows in 0 pages for object "sys.filestream_tombstone_2073058421".
    DBCC results for 'sys.syscommittab'.
    There are 0 rows in 0 pages for object "sys.syscommittab".
    DBCC results for 'sys.filetable_updates_2105058535'.
    There are 0 rows in 0 pages for object "sys.filetable_updates_2105058535".
    CHECKDB found 2 allocation errors and 55 consistency errors in database 'SSISDB'.
    CHECKDB fixed 2 allocation errors and 55 consistency errors in database 'SSISDB'.
    DBCC execution completed. If DBCC printed error messages, contact your system administrator.
  • Ash

    SSC Eights!

    Points: 826

    Forgot to mention, Encryption key no longer available. FOllowing steps on this link: https://docs.microsoft.com/en-us/sql/integration-services/backup-restore-and-move-the-ssis-catalog?view=sql-server-2014

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

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