Chiratidzo:
Paunenge uchishandisa DBCC CHECKDB ne REPAIR_ALLOW_DATA_LOSS parameter kugadzirisa yakaora .MDF dhatabhesi, seizvi:
DBCC CHECKDB(xxxx, 'REPAIR_ALLOW_DATA_LOSS')
iwe unoona inotevera meseji yekukanganisa:
Msg 8921, Chikamu 16, State 1, Mutsara 8
Cheki yapera. Kukundikana kwakaonekwa panguva yekuunganidza chokwadi. Pamwe tempdb kunze kwenzvimbo kana tafura yehurongwa haienderane. Tarisa zvikanganiso zvekare.
Msg 8998, Chikamu 16, State 2, Mutsara 8
Kukanganisa kwemapeji paGAM, SGAM, kana PFS mapeji anodzivirira kugovaniswa kwekuvimbika mudatabase ID 39 mapeji kubva (1: 0) kusvika (1:8087). Ona zvimwe zvikanganiso nechikonzero.
CHECKDB yakawana 1 zvikanganiso zvekugovera uye 0 zvikanganiso zvisina hukama nechero chinhu chimwe chete.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:157) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 3, index ID 1, partition ID 196608, alloc unit ID 196608 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
CHECKDB yakawana kukanganisa kwekugoverwa kwe1 uye 0 zvikanganiso zvekuenderana mutafura 'sys.sysrscols' (chinhu ID 3).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:131) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 5, index ID 1, partition ID 327680, alloc unit ID 327680 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
CHECKDB yakawana kukanganisa kwekugoverwa kwe1 uye 0 zvikanganiso zvekuenderana mutafura 'sys.sysrowsets' (chinhu ID 5).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:21) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 7, index ID 1, partition ID 458752, alloc unit ID 458752 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:18) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 7, index ID 2, partition ID 562949953880064, alloc unit ID 562949953880064 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
CHECKDB yakawana zvikanganiso zviviri zvekugovera uye 2 zvikanganiso zvekuenderana mutafura 'sys.sysallocunits' (chinhu ID 0).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:12) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 8, index ID 0, partition ID 524288, alloc unit ID 524288 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
CHECKDB yakawana kukanganisa kwekugoverwa uye 1 kukanganisa kwekuenderana mutafura 'sys.sysfiles0' (chinhu ID 1).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:137) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 20, index ID 1, partition ID 281474978021376, alloc unit ID 281474978021376 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
CHECKDB yakawana 1 zvikanganiso zvekugovera uye 0 kusawirirana kukanganisa mutafura 'sys.sysdbfiles' (chinhu ID 20).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:152) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 23, index ID 1, partition ID 281474978217984, alloc unit ID 281474978217984 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
CHECKDB yakawana zvikanganiso zvekugovera 1 uye 0 zvikanganiso zvekuenderana mutafura 'sys.sysphfg' (chinhu ID 23).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:154) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 24, index ID 1, partition ID 281474978283520, alloc unit ID 281474978283520 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
CHECKDB yakawana kukanganisa kwekugoverwa kwe1 uye 0 zvikanganiso zvekuenderana mutafura 'sys.sysprufiles' (chinhu ID 24).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:92) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 27, index ID 1, partition ID 281474978480128, alloc unit ID 281474978480128 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:288) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 27, index ID 2, partition ID 562949955190784, alloc unit ID 562949955190784 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:96) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 27, index ID 3, partition ID 844424931901440, alloc unit ID 844424931901440 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
CHECKDB yakawana zvikanganiso zvekugovera 3 uye 0 zvikanganiso zvekuenderana mutafura 'sys.sysowners' (chinhu ID 27).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:102) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 29, index ID 1, partition ID 281474978611200, alloc unit ID 281474978611200 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
CHECKDB yakawana kukanganisa kwekugoverwa kwe1 uye 0 zvikanganiso zvekuenderana mutafura 'sys.sysprivs' (chinhu ID 29).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:117) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:295) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 34, index ID 2, partition ID 562949955649536, alloc unit ID 562949955649536 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:368) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 34, index ID 3, partition ID 844424932360192, alloc unit ID 844424932360192 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:123) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 34, index ID 4, partition ID 1125899909070848, alloc unit ID 1125899909070848 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
CHECKDB yakawana zvikanganiso zvina zvekugovera uye 4 zvikanganiso zvekuenderana mutafura 'sys.sysschobjs' (chinhu ID 0).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:108) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:245) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 41, index ID 2, partition ID 562949956108288, alloc unit ID 562949956108288 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
CHECKDB yakawana 2 kukanganisa kwekugoverwa uye 0 kukanganisa kukanganisa mutafura 'sys.syscolpars' (chinhu ID 41).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:10) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 44, index ID 1, partition ID 281474979594240, alloc unit ID 281474979594240 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:286) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 44, index ID 2, partition ID 562949956304896, alloc unit ID 562949956304896 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
CHECKDB yakawana zvikanganiso zviviri zvekugovera uye 2 zvikanganiso zvekuenderana mutafura 'sys.sysnsobjs' (chinhu ID 0).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:76) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 50, index ID 1, partition ID 281474979987456, alloc unit ID 281474979987456 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:292) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 50, index ID 2, partition ID 562949956698112, alloc unit ID 562949956698112 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:294) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 50, index ID 3, partition ID 844424933408768, alloc unit ID 844424933408768 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
CHECKDB yakawana zvikanganiso zvitatu zvekugovera uye 3 zvikanganiso zvekuenderana mutafura 'sys.sysscalartypes' (chinhu ID 0).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:125) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 54, index ID 1, partition ID 281474980249600, alloc unit ID 281474980249600 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:284) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 54, index ID 2, partition ID 562949956960256, alloc unit ID 562949956960256 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
CHECKDB yakawana 2 kukanganisa kwekugoverwa uye 0 zvikanganiso zvekuenderana mutafura 'sys.sysidxstats' (chinhu ID 54).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:141) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 55, index ID 1, partition ID 281474980315136, alloc unit ID 281474980315136 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:55) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 55, index ID 2, partition ID 562949957025792, alloc unit ID 562949957025792 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
CHECKDB yakawana zvikanganiso zviviri zvekugovera uye 2 zvikanganiso zvekuenderana mutafura 'sys.sysicols' (chinhu ID 0).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:13) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 58, index ID 1, partition ID 281474980511744, alloc unit ID 72057594037993472 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:84) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 58, index ID 2, partition ID 562949957222400, alloc unit ID 72057594038059008 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
CHECKDB yakawana zvikanganiso zviviri zvekugovera uye 2 zvikanganiso zvekuenderana mutafura 'sys.sysbinobjs' (chinhu ID 0).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:129) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:45) inongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data) , asi haina kuonekwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
CHECKDB yakawana 2 kukanganisa kwekugoverwa uye 0 zvikanganiso zvekuenderana mutafura 'sys.sysobjvalues' (chinhu ID 60).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:88) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 64, index ID 1, partition ID 281474980904960, alloc unit ID 281474980904960 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:243) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 64, index ID 2, partition ID 562949957615616, alloc unit ID 562949957615616 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
CHECKDB yakawana zvikanganiso zviviri zvekugovera uye 2 zvikanganiso zvekuenderana mutafura 'sys.sysclsobjs' (chinhu ID 0).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:15) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 69, index ID 1, partition ID 281474981232640, alloc unit ID 72057594039697408 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:39) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 69, index ID 2, partition ID 562949957943296, alloc unit ID 72057594039762944 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:290) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 69, index ID 3, partition ID 844424934653952, alloc unit ID 72057594039828480 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
CHECKDB yakawana zvikanganiso zvitatu zvekugovera uye 3 zvikanganiso zvekuenderana mutafura 'sys.sysrts' (chinhu ID 0).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:98) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 74, index ID 1, partition ID 281474981560320, alloc unit ID 281474981560320 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:100) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 74, index ID 2, partition ID 562949958270976, alloc unit ID 562949958270976 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
CHECKDB yakawana zvikanganiso zviviri zvekugovera uye 2 zvikanganiso zvekuenderana mutafura 'sys.syssingleobjrefs' (chinhu ID 0).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:104) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 75, index ID 1, partition ID 281474981625856, alloc unit ID 281474981625856 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:106) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 75, index ID 2, partition ID 562949958336512, alloc unit ID 562949958336512 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
CHECKDB yakawana zvikanganiso zviviri zvekugovera uye 2 zvikanganiso zvekuenderana mutafura 'sys.sysmultiobjrefs' (chinhu ID 0).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:33) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 90, index ID 1, partition ID 281474982608896, alloc unit ID 72057594038583296 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:81) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 90, index ID 2, partition ID 562949959319552, alloc unit ID 72057594038648832 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
CHECKDB yakawana zvikanganiso zviviri zvekugovera uye 2 zvikanganiso zvekuenderana mutafura 'sys.sysqnames' (chinhu ID 0).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:49) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 91, index ID 1, partition ID 281474982674432, alloc unit ID 72057594038779904 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:35) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 91, index ID 2, partition ID 562949959385088, alloc unit ID 72057594038845440 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
CHECKDB yakawana zvikanganiso zviviri zvekugoverwa uye 2 zvikanganiso zvekuenderana mutafura 'sys.sysxmlcomponent' (chinhu ID 0).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:83) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 92, index ID 1, partition ID 281474982739968, alloc unit ID 72057594038976512 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
CHECKDB yakawana kukanganisa kwekugoverwa uye 1 kukanganisa kwekuenderana mutafura 'sys.sysxmlfacet' (chinhu ID 0).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:130) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 93, index ID 1, partition ID 281474982805504, alloc unit ID 72057594039107584 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:22) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 93, index ID 2, partition ID 562949959516160, alloc unit ID 72057594039173120 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
CHECKDB yakawana zvikanganiso zviviri zvekugovera uye 2 zvikanganiso zvekuenderana mutafura 'sys.sysxmlplacement' (chinhu ID 0).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:114) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 97, index ID 1, partition ID 281474983067648, alloc unit ID 72057594038190080 (type In-row data), asi haina kuwanikwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:134) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 97, index ID 2, partition ID 562949959778304, alloc unit ID 72057594038255616 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
CHECKDB yakawana zvikanganiso zviviri zvekugovera uye 2 zvikanganiso zvekuenderana mutafura 'sys.sysbinsubobjs' (chinhu ID 0).
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
Msg 8939, Chikamu 16, State 98, Mutsara 8
Tafura kukanganisa: Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), peji (57311: 268369920). Muedzo (IS_OFF (BUF_IOERR, pBUF->bstat)) wakundikana. Hwaro ndeye 2057 uye -4.
CHECKDB yakawana zvikanganiso zvishanu zvekugovera uye makumi maviri nemasere zvikanganiso mutafura '(Object ID 5)' (chinhu ID 28).
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:120) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045792256 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:118) inongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (type LOB data) , asi haina kuonekwa mu scan.
Hatina kukwanisa kugadzirisa kukanganisa uku.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:126) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 245575913, index ID 2, partition ID 72057594040614912, alloc unit ID 72057594045923328 (type In-row data), asi haina kuwanikwa mu scan.
Kugadzirisa kukanganisa uku kunoda kuti zvimwe zvikanganiso zvigadziriswe kutanga.
CHECKDB yakawana 3 zvikanganiso zvekugovera uye 0 kusawirirana kukanganisa mutafura 'TestTable' (chinhu ID 245575913).
CHECKDB yakawana 58 zvikanganiso zvekugovera uye 28 zvikanganiso zvekuenderana mudhatabhesi 'xxxx'.
uko 'xxxx' izita rehuori MDF dhatabhesi iri kugadziriswa.
Uku kukanganisa kwekugoverwa sezvo paine matambudziko nemapeji eIAM, anoenderana ne Msg 2575 kukanganisa.
Screenshot yemhosho meseji:
Tsanangudzo Yakananga:
Iyo data muMDF faira inochengetwa semapeji, peji rega rega i8KB. Iyo Index Allocation Mepu (IAM) peji inoshandiswa kugovera mapeji muMDF File, uye akabatanidzwa sechinyorwa.
Kana mutemo weDBCC CHECKDB ukaona kuti rondedzero yakabatana yemapeji eIAM haikodzeri uye haikwanise kugadzirisa dambudziko, inozotaura kukanganisa uku.
Unogona kushandisa chigadzirwa chedu DataNumen SQL Recovery kuti uwanezve data kubva kune yakaora MDF faira uye kugadzirisa kukanganisa uku.
Sample Files:
Sample huwori MDF mafaera anokonzeresa iyo Msg 2575 kukanganisa:
| SQL Server mhando | Uori MDF faira | MDF faira rakagadziriswa ne DataNumen SQL Recovery |
| SQL Server 2014 | Error2.mdf | Error2_fixed.mdf |