Error Running Shrink Command

  • We have a database where we just spread the data into new file space and file groups and we are trying to shrink the primary data file.

    We get this error,

    A severe error occured on the current command.

    Running a check db and had some results.

    I am asking to run a check db with repair_rebuild to see if that will fix db and allow to shrink the database but any knowledge of this error would be appreciated.

  • The 'severe error' is because the shrink hit the corruption and resulted in a severity 24 error. That terminated the connection resulting in the error.

    Post the full output of the following, and I'll help you fix the corruption.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    As for the shrink... Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.

    Shrinking causes massive fragmentation and will just result in the data file growing again next time data gets added. When that happens, the entire system will slow down as the file is expanded. Also repeated shrinks and grows will cause fragmentation at the file-system level, which is hard to fix.

    See - http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/

    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
  • Msg 2533, Level 16, State 1, Line 1

    Table error: page (1:11154047) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795672) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795673) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795674) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795675) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795676) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795677) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795678) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795679) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795680) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795681) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795682) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795683) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795684) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795685) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795686) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795687) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795688) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795689) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795690) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795691) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795692) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795693) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795694) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795695) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795696) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795697) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795698) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795699) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795700) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795701) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795702) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795703) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795704) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795705) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795706) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795707) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795708) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795709) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795710) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795711) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795712) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795713) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795714) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795715) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795716) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795717) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795718) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795719) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795720) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795721) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795722) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795723) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795724) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795725) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795726) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795727) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795728) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795729) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795730) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795731) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795732) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795733) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795734) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795735) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795736) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795737) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795738) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795739) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795740) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795741) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795742) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795743) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795744) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795745) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795746) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795747) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795748) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795749) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795750) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795751) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795752) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795753) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795754) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795755) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795756) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795757) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795758) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795759) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795760) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795761) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795762) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795763) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795764) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795765) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795766) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795767) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795768) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795769) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795770) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795771) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795772) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795773) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795774) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795775) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795776) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795777) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795778) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795779) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795780) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795781) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795782) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795783) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795784) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795785) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795786) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795787) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795788) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795789) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795790) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795791) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795792) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795793) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795794) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795795) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795796) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795797) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795798) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795799) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795800) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795801) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795802) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795803) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795804) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (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:19795805) allocated to object ID 1036634836, index ID 0, partition ID 72057594154188800, alloc unit ID 72057594160283648 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    There are 0 rows in 0 pages for object "TEMP_HISTORY_8205".

    CHECKDB found 0 allocation errors and 135 consistency errors in table 'TEMP_HISTORY_8205' (object ID 1036634836).

    DBCC results for 'TBL_ADS_LOAD_0097_HISTORY'.

    There are 0 rows in 0 pages for object "TBL_ADS_LOAD_0097_HISTORY".

    DBCC results for 'TBL_ADS_LOAD_5005_HISTORY_ARCHIVED'.

    There are 308972 rows in 4730 pages for object "TBL_ADS_LOAD_5005_HISTORY_ARCHIVED".

    DBCC results for 'TEMP_HISTORY_8211'.

    Msg 2533, Level 16, State 2, Line 1

    Table error: page (1:14363413) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841792) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841793) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841794) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841795) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841796) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841797) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841798) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841799) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841800) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841801) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841802) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841803) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841804) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841805) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841806) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841807) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841808) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841809) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841810) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841811) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841812) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841813) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841814) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841815) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841816) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841817) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841818) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841819) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841820) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841821) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841822) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841823) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841824) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841825) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841826) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841827) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841828) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841829) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841830) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841831) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841832) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841833) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841834) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841835) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841836) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841837) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841838) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841839) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841840) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841841) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841842) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841843) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841844) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841845) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841846) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841847) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841848) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841849) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841850) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841851) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841852) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841853) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841854) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841855) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841856) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841857) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841858) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841859) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841860) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841861) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841862) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841863) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841864) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841865) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841866) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841867) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841868) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841869) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841870) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841871) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841872) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841873) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841874) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841875) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841876) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841877) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841878) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841879) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841880) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841881) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841882) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841883) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841884) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841885) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841886) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841887) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841888) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841889) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841890) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841891) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841892) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841893) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841894) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841895) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841896) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841897) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841898) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841899) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841900) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841901) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841902) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841903) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841904) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841905) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841906) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841907) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841908) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841909) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841910) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841911) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841912) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841913) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841914) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841915) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841916) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841917) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841918) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841919) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841920) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841921) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841922) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841923) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841924) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841925) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841926) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841927) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841928) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841929) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841930) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841931) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841932) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841933) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841934) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841935) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841936) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841937) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841938) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841939) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841940) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841941) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841942) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841943) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841944) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841945) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841946) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (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:19841947) allocated to object ID 1052634893, index ID 0, partition ID 72057594154254336, alloc unit ID 72057594160349184 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

    There are 0 rows in 0 pages for object "TEMP_HISTORY_8211".

    CHECKDB found 0 allocation errors and 157 consistency errors in table 'TEMP_HISTORY_8211' (object ID 1052634893).

    DBCC results for 'TBL_ADS_LOAD_8060_HISTORY'.

    There are 0 rows in 1 pages for object "TBL_ADS_LOAD_8060_HISTORY".

    DBCC results for 'TBL_ADS_LOAD_3612_HISTORY'.

    There are 3622 rows in 47 pages for object "TBL_ADS_LOAD_3612_HISTORY".

    DBCC results for 'TBL_ADS_LOAD_2021_HISTORY'.

    Msg 2534, Level 16, State 2, Line 1

    Table error: page (1:14363413), whose header indicates that it is allocated to object ID 1056110903, index ID 1, partition ID 72057594145275904, alloc unit ID 72057594150649856 (type In-row data), is allocated by another object.

    Msg 8979, Level 16, State 1, Line 1

    Table error: Object ID 1056110903, index ID 1, partition ID 72057594145275904, alloc unit ID 72057594150649856 (type In-row data). Page (1:14363413) is missing references from parent (unknown) and previous (page (1:9278050)) nodes. Possible bad root entry in system catalog.

    There are 0 rows in 2 pages for object "TBL_ADS_LOAD_2021_HISTORY".

    CHECKDB found 0 allocation errors and 2 consistency errors in table 'TBL_ADS_LOAD_2021_HISTORY' (object ID 1056110903).

    As for shrinking, we have deleted many tables from this database as well as reallocated tables to new file spaces. I don't think there is 1 table assigned to the primary files space. This files space is still about 200GB when if we can run a shrink on it, it will probably reduce to a few gigs.

    GilaMonster (3/31/2010)


    The 'severe error' is because the shrink hit the corruption and resulted in a severity 24 error. That terminated the connection resulting in the error.

    Post the full output of the following, and I'll help you fix the corruption.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    As for the shrink... Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.

    Shrinking causes massive fragmentation and will just result in the data file growing again next time data gets added. When that happens, the entire system will slow down as the file is expanded. Also repeated shrinks and grows will cause fragmentation at the file-system level, which is hard to fix.

    See - http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/

  • That's not the complete output. There should be 2 or 3 more lines at the end saying how many errors checkDB found in the entire database and a repair level if applicable.

    Please post the rest of the output.

    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
  • CHECKDB found 0 allocation errors and 294 consistency errors in database 'History'.

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

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    GilaMonster (3/31/2010)


    That's not the complete output. There should be 2 or 3 more lines at the end saying how many errors checkDB found in the entire database and a repair level if applicable.

    Please post the rest of the output.

  • Ok, two questions...

    1) Why, if the minimum repair level is repair_allow_data_loss, are you requesting that repair_rebuild be run? If repair_rebuild would fix it, it would be listed as the minimum repair level.

    2) Do you have a clean backup (a backup without this corruption)? Because repairing will lose you a fair bit of data.

    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 think the tables that are in error were able to be dropped or recreated. We are currently running another checkdb to see if any new errors occur after we have done so.

    Hopefully, if there are any errors, we will now have the option of repair_rebuild.

  • dwh-1095413 (3/31/2010)


    I think the tables that are in error were able to be dropped or recreated. We are currently running another checkdb to see if any new errors occur after we have done so.

    If there are, post the complete output (don't omit anything)

    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
  • The check db passed successfully and I tried to run a shrink with (emptyfile) so it would distribute the tables to the other filesets that are considered Primary and it failed stating it could not move the system tables. This is fine so I tried to shrink using reorganizing and shrinking to minimum file space size and I get an error that the lock timeout was exceeded.

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

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