Allocation and Consistency Errors

  • Hi all! I am not a DBA per se, but I do have enough experience with SQL to get assigned tickets in my organization concerning corrupt databases apparently.. :w00t:

    We have a developer that submitted a ticket saying that all of his production, UAT, and development databases are corrupt, and I'm the lucky sys ad that gets to investigate!

    I'm hoping you SQL geniuses will point me in the right direction here.. First, i'll let you know the steps I've taken on a copy of this db in our dev environment:

    1. ran DBCC CHECKDB (treasury) WITH NO_INFOMSGS, ALL_ERRORMSGS (output below)

    2. put the db into single user mode and tried to repair:

    ALTER DATABASE treasury SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

    BEGIN TRANSACTION;

    DBCC CHECKDB ('treasury', REPAIR_ALLOW_DATA_LOSS);

    3. Dropped and recreated the indexes using the following queries..

    DECLARE @SchemaName VARCHAR(256)DECLARE @TableName VARCHAR(256)

    DECLARE @IndexName VARCHAR(256)

    DECLARE @TSQLDropIndex VARCHAR(MAX)

    DECLARE CursorIndexes CURSOR FOR

    SELECT schema_name(t.schema_id), t.name, i.name

    FROM sys.indexes i

    INNER JOIN sys.tables t ON t.object_id= i.object_id

    WHERE i.type>0 and t.is_ms_shipped=0 and t.name<>'sysdiagrams'

    and (is_primary_key=0 and is_unique_constraint=0)

    OPEN CursorIndexes

    FETCH NEXT FROM CursorIndexes INTO @SchemaName,@TableName,@IndexName

    WHILE @@fetch_status = 0

    BEGIN

    SET @TSQLDropIndex = 'DROP INDEX '+QUOTENAME(@SchemaName)+ '.' + QUOTENAME(@TableName) + '.' +QUOTENAME(@IndexName)

    PRINT @TSQLDropIndex

    FETCH NEXT FROM CursorIndexes INTO @SchemaName,@TableName,@IndexName

    END

    :-D:-D:-D:-D

    and to reccreate:

    declare @SchemaName varchar(100)declare @TableName varchar(256)

    declare @IndexName varchar(256)

    declare @ColumnName varchar(100)

    declare @is_unique varchar(100)

    declare @IndexTypeDesc varchar(100)

    declare @FileGroupName varchar(100)

    declare @is_disabled varchar(100)

    declare @IndexOptions varchar(max)

    declare @IndexColumnId int

    declare @IsDescendingKey int

    declare @IsIncludedColumn int

    declare @TSQLScripCreationIndex varchar(max)

    declare @TSQLScripDisableIndex varchar(max)

    declare CursorIndex cursor for

    select schema_name(t.schema_id) [schema_name], t.name, ix.name,

    case when ix.is_unique = 1 then 'UNIQUE ' else '' END

    , ix.type_desc,

    case when ix.is_padded=1 then 'PAD_INDEX = ON, ' else 'PAD_INDEX = OFF, ' end

    + case when ix.allow_page_locks=1 then 'ALLOW_PAGE_LOCKS = ON, ' else 'ALLOW_PAGE_LOCKS = OFF, ' end

    + case when ix.allow_row_locks=1 then 'ALLOW_ROW_LOCKS = ON, ' else 'ALLOW_ROW_LOCKS = OFF, ' end

    + case when INDEXPROPERTY(t.object_id, ix.name, 'IsStatistics') = 1 then 'STATISTICS_NORECOMPUTE = ON, ' else 'STATISTICS_NORECOMPUTE = OFF, ' end

    + case when ix.ignore_dup_key=1 then 'IGNORE_DUP_KEY = ON, ' else 'IGNORE_DUP_KEY = OFF, ' end

    + 'SORT_IN_TEMPDB = OFF, FILLFACTOR =' + CAST(ix.fill_factor AS VARCHAR(3)) AS IndexOptions

    , ix.is_disabled , FILEGROUP_NAME(ix.data_space_id) FileGroupName

    from sys.tables t

    inner join sys.indexes ix on t.object_id=ix.object_id

    where ix.type>0 and ix.is_primary_key=0 and ix.is_unique_constraint=0 --and schema_name(tb.schema_id)= @SchemaName and tb.name=@TableName

    and t.is_ms_shipped=0 and t.name<>'sysdiagrams'

    order by schema_name(t.schema_id), t.name, ix.name

    open CursorIndex

    fetch next from CursorIndex into @SchemaName, @TableName, @IndexName, @is_unique, @IndexTypeDesc, @IndexOptions,@is_disabled, @FileGroupName

    while (@@fetch_status=0)

    begin

    declare @IndexColumns varchar(max)

    declare @IncludedColumns varchar(max)

    set @IndexColumns=''

    set @IncludedColumns=''

    declare CursorIndexColumn cursor for

    select col.name, ixc.is_descending_key, ixc.is_included_column

    from sys.tables tb

    inner join sys.indexes ix on tb.object_id=ix.object_id

    inner join sys.index_columns ixc on ix.object_id=ixc.object_id and ix.index_id= ixc.index_id

    inner join sys.columns col on ixc.object_id =col.object_id and ixc.column_id=col.column_id

    where ix.type>0 and (ix.is_primary_key=0 or ix.is_unique_constraint=0)

    and schema_name(tb.schema_id)=@SchemaName and tb.name=@TableName and ix.name=@IndexName

    order by ixc.index_column_id

    open CursorIndexColumn

    fetch next from CursorIndexColumn into @ColumnName, @IsDescendingKey, @IsIncludedColumn

    while (@@fetch_status=0)

    begin

    if @IsIncludedColumn=0

    set @IndexColumns=@IndexColumns + @ColumnName + case when @IsDescendingKey=1 then ' DESC, ' else ' ASC, ' end

    else

    set @IncludedColumns=@IncludedColumns + @ColumnName +', '

    fetch next from CursorIndexColumn into @ColumnName, @IsDescendingKey, @IsIncludedColumn

    end

    close CursorIndexColumn

    deallocate CursorIndexColumn

    set @IndexColumns = substring(@IndexColumns, 1, len(@IndexColumns)-1)

    set @IncludedColumns = case when len(@IncludedColumns) >0 then substring(@IncludedColumns, 1, len(@IncludedColumns)-1) else '' end

    -- print @IndexColumns

    -- print @IncludedColumns

    set @TSQLScripCreationIndex =''

    set @TSQLScripDisableIndex =''

    set @TSQLScripCreationIndex='CREATE '+ @is_unique +@IndexTypeDesc + ' INDEX ' +QUOTENAME(@IndexName)+' ON ' + QUOTENAME(@SchemaName) +'.'+ QUOTENAME(@TableName)+ '('+@IndexColumns+') '+

    case when len(@IncludedColumns)>0 then CHAR(13) +'INCLUDE (' + @IncludedColumns+ ')' else '' end + CHAR(13)+'WITH (' + @IndexOptions+ ') ON ' + QUOTENAME(@FileGroupName) + ';'

    if @is_disabled=1

    set @TSQLScripDisableIndex= CHAR(13) +'ALTER INDEX ' +QUOTENAME(@IndexName) + ' ON ' + QUOTENAME(@SchemaName) +'.'+ QUOTENAME(@TableName) + ' DISABLE;' + CHAR(13)

    print @TSQLScripCreationIndex

    print @TSQLScripDisableIndex

    fetch next from CursorIndex into @SchemaName, @TableName, @IndexName, @is_unique, @IndexTypeDesc, @IndexOptions,@is_disabled, @FileGroupName

    end

    close CursorIndex

    deallocate CursorIndex

    :w00t::w00t::w00t::w00t:

    I'm still receiving the errors (below).. will someone please point me in the right direction?

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128320) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128360) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128368) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128384) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128400) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128408) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128416) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128424) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128432) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128440) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128448) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128464) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128472) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128480) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128496) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128504) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128512) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128536) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128392) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128488) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128520) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128376) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128456) in database ID 43 is allocated by more than one allocation object.

    Msg 8904, Level 16, State 1, Line 1

    Extent (1:2128528) in database ID 43 is allocated by more than one allocation object.

    CHECKDB found 24 allocation errors and 0 consistency errors not associated with any single object.

    Msg 8961, Level 16, State 2, Line 1

    Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data). The off-row data node at page (1:38606), slot 0, text ID 812187648 does not match its reference from page (1:27800), slot 0.

    Msg 8929, Level 16, State 1, Line 1

    Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data): Errors found in off-row data with ID 812187648 owned by data record identified by RID = (1:27800:0)

    CHECKDB found 0 allocation errors and 2 consistency errors in table 'sys.sysobjvalues' (object ID 60).

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128536) is allocated to 'dbo.zaudit_data_email_sent' and at least one other object.

    CHECKDB found 1 allocation errors and 0 consistency errors in table 'zaudit_data_email_sent' (object ID 293990382).

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128320) is allocated to 'dbo.data_postawards_submitted, IX_data_postawards_submitted_aid' and at least one other object.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128320) allocated to object ID 547604155, index ID 2, partition ID 72057664723812352, alloc unit ID 72057664733773824 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128321) allocated to object ID 547604155, index ID 2, partition ID 72057664723812352, alloc unit ID 72057664733773824 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128322) allocated to object ID 547604155, index ID 2, partition ID 72057664723812352, alloc unit ID 72057664733773824 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128323) allocated to object ID 547604155, index ID 2, partition ID 72057664723812352, alloc unit ID 72057664733773824 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128324) allocated to object ID 547604155, index ID 2, partition ID 72057664723812352, alloc unit ID 72057664733773824 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128325) allocated to object ID 547604155, index ID 2, partition ID 72057664723812352, alloc unit ID 72057664733773824 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128326) allocated to object ID 547604155, index ID 2, partition ID 72057664723812352, alloc unit ID 72057664733773824 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128327) allocated to object ID 547604155, index ID 2, partition ID 72057664723812352, alloc unit ID 72057664733773824 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    CHECKDB found 1 allocation errors and 8 consistency errors in table 'data_postawards_submitted' (object ID 547604155).

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128360) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128368) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128384) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128400) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128408) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128416) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128424) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128432) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128440) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128448) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128464) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128472) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128480) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128496) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128504) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128512) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128536) is allocated to 'dbo.change_log' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128392) is allocated to 'dbo.change_log, IX_change_log_aid' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128488) is allocated to 'dbo.change_log, IX_change_log_aid' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128520) is allocated to 'dbo.change_log, IX_change_log_aid' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128376) is allocated to 'dbo.change_log, IX_change_log_fieldname_id' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128456) is allocated to 'dbo.change_log, IX_change_log_fieldname_id' and at least one other object.

    Msg 8913, Level 16, State 3, Line 1

    Extent (1:2128528) is allocated to 'dbo.change_log, IX_change_log_fieldname_id' and at least one other object.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128360) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128361) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128362) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128363) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128364) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128365) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128366) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128367) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128368) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128369) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128370) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128371) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128372) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128373) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128374) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128375) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128384) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128385) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128386) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128387) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128388) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128389) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128390) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128391) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128400) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128401) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128402) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128403) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128404) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128405) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128406) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128407) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128408) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128409) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128410) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128411) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128412) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128413) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128414) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128415) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128416) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128417) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128418) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128419) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128420) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128421) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128422) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128423) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128424) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128425) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128426) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128427) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128428) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128429) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128430) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128431) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128432) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128433) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128434) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128435) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128436) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128437) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128438) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128439) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128440) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128441) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128442) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128443) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128444) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128445) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128446) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128447) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128448) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128449) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128450) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128451) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128452) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128453) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128454) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128455) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128464) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128465) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128466) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128467) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128468) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128469) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128470) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128471) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128472) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128473) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128474) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128475) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128476) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128477) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128478) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128479) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128480) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128481) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128482) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128483) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128484) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128485) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128486) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128487) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128496) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128497) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128498) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128499) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128500) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128501) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128502) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128503) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128504) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128505) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128506) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128507) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128508) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128509) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128510) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128511) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128512) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128513) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128514) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128515) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128516) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128517) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128518) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128519) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128536) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128537) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128538) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128539) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128540) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128541) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128542) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128543) allocated to object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128392) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128393) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128394) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128395) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128396) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128397) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128398) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128399) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128488) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128489) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128490) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128491) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128492) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128493) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128494) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128495) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128520) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128521) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128522) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128523) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128524) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128525) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128526) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128527) allocated to object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128376) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128377) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128378) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128379) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128380) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128381) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128382) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128383) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128456) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128457) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128458) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128459) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128460) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128461) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128462) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128463) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128528) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128529) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128530) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128531) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128532) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128533) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128534) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:2128535) allocated to object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). Index node page (1:3759818), slot 49 refers to child page (1:2128377) and previous child (1:3760983), but they were not encountered.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). Index node page (1:3600235), slot 224 refers to child page (1:2128378) and previous child (1:3734928), but they were not encountered.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). Index node page (1:3729694), slot 100 refers to child page (1:2128379) and previous child (1:3734929), but they were not encountered.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). Index node page (1:3621735), slot 147 refers to child page (1:2128380) and previous child (1:3734930), but they were not encountered.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). Index node page (1:3630804), slot 185 refers to child page (1:2128381) and previous child (1:3734931), but they were not encountered.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). Index node page (1:3621833), slot 194 refers to child page (1:2128382) and previous child (1:3734932), but they were not encountered.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). Index node page (1:3747353), slot 156 refers to child page (1:2128383) and previous child (1:3734933), but they were not encountered.

    Msg 8976, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2128392) was not seen in the scan although its parent (1:2636102) and previous (1:2653133) refer to it. Check any previous errors.

    Msg 8981, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). The next pointer of (1:2316480) refers to page (1:2128393). Neither (1:2128393) nor its parent were encountered. Possible bad chain linkage.

    Msg 8976, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2128394) was not seen in the scan although its parent (1:3735007) and previous (1:2394981) refer to it. Check any previous errors.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Index node page (1:3755142), slot 182 refers to child page (1:2128395) and previous child (1:2658296), but they were not encountered.

    Msg 8976, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2128396) was not seen in the scan although its parent (1:3735007) and previous (1:2206501) refer to it. Check any previous errors.

    Msg 8976, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2128397) was not seen in the scan although its parent (1:2336942) and previous (1:2643079) refer to it. Check any previous errors.

    Msg 8976, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2128398) was not seen in the scan although its parent (1:2660632) and previous (1:2660690) refer to it. Check any previous errors.

    Msg 8976, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2128399) was not seen in the scan although its parent (1:3709197) and previous (1:2652909) refer to it. Check any previous errors.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). Index node page (1:3631728), slot 211 refers to child page (1:2128456) and previous child (1:3734934), but they were not encountered.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). Index node page (1:3755204), slot 163 refers to child page (1:2128457) and previous child (1:3734935), but they were not encountered.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). Index node page (1:3628250), slot 98 refers to child page (1:2128458) and previous child (1:3761832), but they were not encountered.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). Index node page (1:3631732), slot 230 refers to child page (1:2128459) and previous child (1:3761833), but they were not encountered.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). Index node page (1:3662835), slot 150 refers to child page (1:2128460) and previous child (1:3761834), but they were not encountered.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). Index node page (1:3576742), slot 223 refers to child page (1:2128461) and previous child (1:3761835), but they were not encountered.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). Index node page (1:3663896), slot 126 refers to child page (1:2128462) and previous child (1:3761836), but they were not encountered.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). Index node page (1:3752740), slot 210 refers to child page (1:2128463) and previous child (1:3761837), but they were not encountered.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 1, partition ID 72057664723943424, alloc unit ID 72057664733904896 (type In-row data). Index node page (1:3629491), slot 387 refers to child page (1:2128469) and previous child (1:3734940), but they were not encountered.

    Msg 8976, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2128488) was not seen in the scan although its parent (1:3709392) and previous (1:2375720) refer to it. Check any previous errors.

    Msg 8976, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2128489) was not seen in the scan although its parent (1:3708870) and previous (1:2429806) refer to it. Check any previous errors.

    Msg 8976, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2128490) was not seen in the scan although its parent (1:3684223) and previous (1:2385297) refer to it. Check any previous errors.

    Msg 8976, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2128491) was not seen in the scan although its parent (1:2636114) and previous (1:2636095) refer to it. Check any previous errors.

    Msg 8981, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). The next pointer of (1:2280176) refers to page (1:2128492). Neither (1:2128492) nor its parent were encountered. Possible bad chain linkage.

    Msg 8976, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2128493) was not seen in the scan although its parent (1:3735007) and previous (1:2281909) refer to it. Check any previous errors.

    Msg 8976, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2128494) was not seen in the scan although its parent (1:2197757) and previous (1:2218462) refer to it. Check any previous errors.

    Msg 8976, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2128495) was not seen in the scan although its parent (1:2688693) and previous (1:3590049) refer to it. Check any previous errors.

    Msg 8976, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2128520) was not seen in the scan although its parent (1:2197757) and previous (1:2651958) refer to it. Check any previous errors.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). Index node page (1:2930822), slot 362 refers to child page (1:2128528) and previous child (1:3761838), but they were not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2197745) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2197841) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2197869) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2197871) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2200805) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2200846) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2200857) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2202564) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2206131) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2206153) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2206162) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2206189) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2206209) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2206259) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2206383) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2207891) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2207894) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2208061) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2208342) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2210317) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2212259) was not encountered.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2218463) is missing a reference from previous page (1:2128520). Possible chain linkage problem.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2218465) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2218785) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2275342) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2278132) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2278134) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2278135) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2278136) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2278137) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2278138) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2280176) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2285985) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2287174) was not encountered.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2287317) is missing a reference from previous page (1:2128495). Possible chain linkage problem.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2289636) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2289637) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2289663) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2295533) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2297549) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2300413) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2300465) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2305386) was not encountered.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2305514) is missing a reference from previous page (1:2128392). Possible chain linkage problem.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2306957) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2306960) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2307406) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2308829) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2309196) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2310318) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2310351) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2313683) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2313932) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2344429) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2355125) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2359058) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2360614) was not encountered.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2364154) is missing a reference from previous page (1:2128399). Possible chain linkage problem.

    Msg 8936, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). B-tree chain linkage mismatch. (1:2658296)->next = (1:2415118), but (1:2415118)->Prev = (1:2128395).

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2437666) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2636690) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647580) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647581) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647582) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647583) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647584) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647585) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647586) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647587) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647588) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647589) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647590) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647591) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647592) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647593) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647594) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647595) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647596) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647597) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647598) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647599) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647600) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647601) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647602) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647603) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647604) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647605) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647606) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647607) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647608) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647609) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647610) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647611) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647612) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647613) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647614) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647615) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647616) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647617) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647618) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647619) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647620) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647621) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647622) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647623) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647624) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647625) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647626) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647627) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647628) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647629) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647630) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647631) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647632) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647633) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647634) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647635) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647636) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647637) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647638) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647639) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647640) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647641) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647642) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647643) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647644) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647645) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647646) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647647) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647648) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647649) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647650) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647651) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647652) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647653) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647654) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647655) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647656) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647657) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647658) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647659) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647660) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647661) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647662) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647663) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647664) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647665) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647666) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647667) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647668) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647669) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647670) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2647671) was not encountered.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2650878) is missing a reference from previous page (1:2128489). Possible chain linkage problem.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2651799) is missing a reference from previous page (1:2128494). Possible chain linkage problem.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2652181) is missing a reference from previous page (1:2128490). Possible chain linkage problem.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2652560) is missing a reference from previous page (1:2128488). Possible chain linkage problem.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2658940) is missing a reference from previous page (1:2128396). Possible chain linkage problem.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2658947) is missing a reference from previous page (1:2128493). Possible chain linkage problem.

    Msg 8935, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). The previous link (1:2128393) on page (1:2659307) does not match the previous page (1:2316480) that the parent (1:2435111), slot 77 expects for this page.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2659307) is missing a reference from previous page (1:2128393). Possible chain linkage problem.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2660691) is missing a reference from previous page (1:2128398). Possible chain linkage problem.

    Msg 8935, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). The previous link (1:2636095) on page (1:2688671) does not match the previous page (1:2128491) that the parent (1:2636114), slot 142 expects for this page.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:2688671) is missing a reference from previous page (1:2636095). Possible chain linkage problem.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2688700) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2689060) was not encountered.

    Msg 8936, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). B-tree chain linkage mismatch. (1:3761835)->next = (1:2689162), but (1:2689162)->Prev = (1:2128461).

    Msg 8936, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). B-tree chain linkage mismatch. (1:3734929)->next = (1:2689164), but (1:2689164)->Prev = (1:2128379).

    Msg 8936, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). B-tree chain linkage mismatch. (1:3734930)->next = (1:2689165), but (1:2689165)->Prev = (1:2128380).

    Msg 8936, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). B-tree chain linkage mismatch. (1:3734932)->next = (1:2689166), but (1:2689166)->Prev = (1:2128382).

    Msg 8935, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). The previous link (1:3734928) on page (1:2689393) does not match the previous page (1:2128378) that the parent (1:3600235), slot 225 expects for this page.

    Msg 8936, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). B-tree chain linkage mismatch. (1:3734933)->next = (1:2689394), but (1:2689394)->Prev = (1:2128383).

    Msg 8936, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). B-tree chain linkage mismatch. (1:3761837)->next = (1:2689396), but (1:2689396)->Prev = (1:2128463).

    Msg 8936, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). B-tree chain linkage mismatch. (1:3761832)->next = (1:2689399), but (1:2689399)->Prev = (1:2128458).

    Msg 8936, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). B-tree chain linkage mismatch. (1:3734935)->next = (1:2689416), but (1:2689416)->Prev = (1:2128457).

    Msg 8936, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). B-tree chain linkage mismatch. (1:3760983)->next = (1:2689417), but (1:2689417)->Prev = (1:2128377).

    Msg 8936, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). B-tree chain linkage mismatch. (1:3734931)->next = (1:2689420), but (1:2689420)->Prev = (1:2128381).

    Msg 8936, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). B-tree chain linkage mismatch. (1:3761833)->next = (1:2689421), but (1:2689421)->Prev = (1:2128459).

    Msg 8936, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). B-tree chain linkage mismatch. (1:3734934)->next = (1:2689422), but (1:2689422)->Prev = (1:2128456).

    Msg 8936, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). B-tree chain linkage mismatch. (1:3761836)->next = (1:2689425), but (1:2689425)->Prev = (1:2128462).

    Msg 8936, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 3, partition ID 72057664724205568, alloc unit ID 72057664734232576 (type In-row data). B-tree chain linkage mismatch. (1:3761834)->next = (1:2689426), but (1:2689426)->Prev = (1:2128460).

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697380) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697381) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697382) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697383) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697384) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697385) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697386) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697387) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697388) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697389) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697390) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697391) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697392) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697393) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697394) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697395) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697396) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697397) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697398) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697399) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697400) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697401) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697402) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697403) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697404) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697405) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697406) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697407) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697408) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697409) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697410) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697411) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2697412) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2722132) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2722133) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:2868728) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3444141) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3531875) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3535448) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3555475) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3555552) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3560339) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3562077) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3562078) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3567292) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3569738) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3572846) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3591519) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3616477) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3621977) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3629636) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3638181) was not encountered.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:3648727) is missing a reference from previous page (1:2128397). Possible chain linkage problem.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3660425) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3670346) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3671698) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3672963) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3674064) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3680080) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3684007) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3684148) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3685587) was not encountered.

    Msg 8979, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:3685632) is missing references from parent (unknown) and previous (page (1:2128492)) nodes. Possible bad root entry in system catalog.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3685638) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3725202) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3729788) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3729789) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3735241) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3735243) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3735244) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Parent node for page (1:3735247) was not encountered.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:3759944) is missing a reference from previous page (1:2128394). Possible chain linkage problem.

    CHECKDB found 23 allocation errors and 471 consistency errors in table 'change_log' (object ID 563604212).

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128320) is allocated to 'dbo.zaudit_data_apps, PK_zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128360) is allocated to 'dbo.zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128368) is allocated to 'dbo.zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128400) is allocated to 'dbo.zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128408) is allocated to 'dbo.zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128424) is allocated to 'dbo.zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128432) is allocated to 'dbo.zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128448) is allocated to 'dbo.zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128464) is allocated to 'dbo.zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128472) is allocated to 'dbo.zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128496) is allocated to 'dbo.zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128504) is allocated to 'dbo.zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128384) is allocated to 'dbo.zaudit_data_apps, PK_zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128416) is allocated to 'dbo.zaudit_data_apps, PK_zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128440) is allocated to 'dbo.zaudit_data_apps, PK_zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128480) is allocated to 'dbo.zaudit_data_apps, PK_zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128512) is allocated to 'dbo.zaudit_data_apps, PK_zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128520) is allocated to 'dbo.zaudit_data_apps, IX_zaudit_data_apps_date_submitted' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128392) is allocated to 'dbo.zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128488) is allocated to 'dbo.zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128376) is allocated to 'dbo.zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128456) is allocated to 'dbo.zaudit_data_apps' and at least one other object.

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128528) is allocated to 'dbo.zaudit_data_apps' and at least one other object.

    CHECKDB found 23 allocation errors and 0 consistency errors in table 'zaudit_data_apps' (object ID 953468729).

    CHECKDB found 72 allocation errors and 481 consistency errors in database 'treasury'.

    repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (treasury).

  • Quick thoughts, looks like corruption in sys.sysobjvalues (object_id 60) and then some

    Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page (1:3759944) is missing a reference from previous page (1:2128394). Possible chain linkage problem.

    CHECKDB found 23 allocation errors and 471 consistency errors in table 'change_log' (object ID 563604212).

    Msg 8913, Level 16, State 4, Line 1

    Extent (1:2128320) is allocated to 'dbo.zaudit_data_apps, PK_zaudit_data_apps' and at least one other object.

    😎

    Do you have recent healthy backups?

  • dbomgard (7/15/2016)


    I'm still receiving the errors (below).. will someone please point me in the right direction?

    Restore from your last good backup.

    Repair is not the first thing that should be tried. Repair's for when you have no good backups and it's not guaranteed to fix everything.

    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
  • I guess I should've mentioned that there arent any good backups! :w00t:

  • Wonderful.

    First thing, alert the owners of this DB that they've likely lost significant amounts of data, possibly everything, and repairs will take a few days at best, if there's anything to recovery.

    Then, run just DBCC CHECKDB (treasury) WITH NO_INFOMSGS, ALL_ERRORMSGS on the DB that you tried to repair and post the results here.

    Please do nothing else at this point.

    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
  • This was removed by the editor as SPAM

  • Now when you don't have good backup, your options are

    > Use DBCC PAGE to try to figure out which tables in the database are affected and drop their statistics

    or

    > Extract all data out into a new database

    Unless you're really comfortable using DBCC PAGE I would recommend SQL database repair tool[/url].

  • johnwalker10 (7/18/2016)


    Now when you don't have good backup, your options are

    > Use DBCC PAGE to try to figure out which tables in the database are affected and drop their statistics

    or

    > Extract all data out into a new database

    The latter of those may indeed be the way to go here, but we don't know yet.

    Dropping statistics is, however, a waste of time, as the damage has nothing to do with statistics.

    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
  • GilaMonster (7/17/2016)


    Wonderful.

    First thing, alert the owners of this DB that they've likely lost significant amounts of data, possibly everything, and repairs will take a few days at best, if there's anything to recovery.

    Then, run just DBCC CHECKDB (treasury) WITH NO_INFOMSGS, ALL_ERRORMSGS on the DB that you tried to repair and post the results here.

    Please do nothing else at this point.

    The output you requested is in the initial thread.. i actually saw this troubleshooting step in another post you replied to and knew to post up front 😀

  • dbomgard (7/18/2016)


    GilaMonster (7/17/2016)


    Wonderful.

    First thing, alert the owners of this DB that they've likely lost significant amounts of data, possibly everything, and repairs will take a few days at best, if there's anything to recovery.

    Then, run just DBCC CHECKDB (treasury) WITH NO_INFOMSGS, ALL_ERRORMSGS on the DB that you tried to repair and post the results here.

    Please do nothing else at this point.

    The output you requested is in the initial thread.. i actually saw this troubleshooting step in another post you replied to and knew to post up front 😀

    In your initial post you said you'd run CheckDB and posted the output, then after that run repair. If that's a correct interpretation, then the checkDB output in the initial post is pre-repair.

    What I just asked for was the a post-repair CheckDB, so that I can see what hasn't been repaired.

    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
  • removed quote

  • You don't need to quote the whole thing again.

    Is the CheckDB output in the inital post the pre-repair output (as your post implies) or the post-repair output (what I asked for)?

    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
  • GilaMonster (7/20/2016)


    You don't need to quote the whole thing again.

    Is the CheckDB output in the inital post the pre-repair output (as your post implies) or the post-repair output (what I asked for)?

    Dear Gail,

    What he posted initially is the one after repair with data lose i think.

  • VastSQL (7/20/2016)


    GilaMonster (7/20/2016)


    You don't need to quote the whole thing again.

    Is the CheckDB output in the inital post the pre-repair output (as your post implies) or the post-repair output (what I asked for)?

    Dear Gail,

    What he posted initially is the one after repair with data lose i think.

    His initial post implies otherwise.

    First, i'll let you know the steps I've taken:

    1. ran DBCC CHECKDB (treasury) WITH NO_INFOMSGS, ALL_ERRORMSGS (output below)

    2. put the db into single user mode and tried to repair:

    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
  • Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data). The off-row data node at page (1:38606), slot 0, text ID 812187648 does not match its reference from page (1:27800), slot 0.

    Object ID 60: Object ID's less than 500 are the SQL Server system tables - this database will never be repairable. It is history.

    With no backup your only option is to try and extract as much as you can on a table by table basis using either the bcp utility and insert it into a NEW database.

    Or have your developer write code to do it.

    Whatever you cannot extract is lost and you need to work out how to replace it.

Viewing 15 posts - 1 through 15 (of 16 total)

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