Chizindikiro:

Mukamagwiritsa ntchito Kufufuza ndi KONZANITSA_ALLOW_DATA_LOSS parameter kuti akonze database yachinyengo ya .MDF, monga chonchi:

DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')

mukuwona uthenga wolakwikawu:

Msg 8921, Mzere wa 16, State 1, Line 8
Chongani wathetsa. Kulephera kunapezeka pamene kusonkhanitsa zenizeni. Mwinanso kutuluka mumlengalenga kapena tebulo lamachitidwe sikungafanane. Onani zolakwika zam'mbuyomu.
Msg 8998, Mzere wa 16, State 2, Line 8
Zolakwika pamasamba pamasamba a GAM, SGAM, kapena PFS zimalepheretsa kuwunika koyenera pamasamba ID 39 kuchokera ku (1: 0) mpaka (1: 8087). Onani zolakwika zina pazifukwa.
CHECKDB idapeza zolakwika 1 kugawa ndi zolakwika 0 zosagwirizana ndi chinthu chilichonse.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 157) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 3, index ID 1, ID yogawa 196608, gawo logawira ID 196608 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
CHECKDB idapeza zolakwitsa 1 ndi magawidwe osasinthasintha mu tebulo 'sys.ysyscols' (chinthu ID 0).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 131) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 5, index ID 1, ID yogawa 327680, gawo logawira ID 327680 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
CHECKDB idapeza zolakwitsa 1 ndi magawidwe osasinthasintha 0 mu tebulo 'syssysrowsets' (chinthu ID 5).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 21) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 7, index ID 1, ID yogawa 458752, gawo logawira ID 458752 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 18) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 7, index ID 2, ID yogawa 562949953880064, gawo logawira ID 562949953880064 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
CHECKDB idapeza zolakwika ziwiri pakugawa ndi zolakwika za 2 m'matabule 'sys.sysallocunits' (chinthu ID 0).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 12) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 8, index ID 0, ID yogawa 524288, gawo logawira ID 524288 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
CHECKDB idapeza zolakwitsa 1 ndi magawidwe osasinthasintha 0 patebulo 'sys.sysfiles1' (chinthu ID 8).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 137) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 20, index ID 1, ID yogawa 281474978021376, gawo logawira ID 281474978021376 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
CHECKDB idapeza zolakwitsa 1 ndi magawidwe osasinthasintha mu tebulo 'sys.sysdbfiles '(chinthu ID 20).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 152) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 23, index ID 1, ID yogawa 281474978217984, gawo logawira ID 281474978217984 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
CHECKDB idapeza zolakwitsa 1 ndi magawidwe osasinthasintha mu tebulo 'sys.sysphfg' (chinthu ID 0).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 154) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 24, index ID 1, ID yogawa 281474978283520, gawo logawira ID 281474978283520 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
CHECKDB idapeza zolakwitsa 1 ndi magawidwe osasinthasintha mu tebulo 'sys.sysprufiles' (chinthu ID 0).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 92) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 27, index ID 1, ID yogawa 281474978480128, gawo logawira ID 281474978480128 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 288) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 27, index ID 2, ID yogawa 562949955190784, gawo logawira ID 562949955190784 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 96) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 27, index ID 3, ID yogawa 844424931901440, gawo logawira ID 844424931901440 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
CHECKDB idapeza zolakwitsa 3 ndi magawidwe osasinthasintha 0 mu tebulo 'sysysersers' (chinthu ID 27).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 102) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 29, index ID 1, ID yogawa 281474978611200, gawo logawira ID 281474978611200 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
CHECKDB idapeza zolakwitsa 1 ndi magawidwe osasinthasintha 0 mu tebulo 'sys.sysprivs' (chinthu ID 29).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 117) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 34, index ID 1, ID yogawa 281474978938880, gawo logawira ID 281474978938880 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 295) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 34, index ID 2, ID yogawa 562949955649536, gawo logawira ID 562949955649536 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 368) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 34, index ID 3, ID yogawa 844424932360192, gawo logawira ID 844424932360192 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 123) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 34, index ID 4, ID yogawa 1125899909070848, gawo logawira ID 1125899909070848 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
CHECKDB idapeza zolakwika zakugawika 4 ndi zolakwika zina za 0 patebulo 'sys.sysschobjs' (chinthu ID 34).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 108) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 41, index ID 1, ID yogawa 281474979397632, gawo logawira ID 281474979397632 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 245) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 41, index ID 2, ID yogawa 562949956108288, gawo logawira ID 562949956108288 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
CHECKDB idapeza zolakwika za kugawa 2 ndi zolakwika zina 0 patebulo 'sys.syscolpars' (chinthu ID 41).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 10) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 44, index ID 1, ID yogawa 281474979594240, gawo logawira ID 281474979594240 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 286) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 44, index ID 2, ID yogawa 562949956304896, gawo logawira ID 562949956304896 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
CHECKDB idapeza zolakwika za kugawa kwa 2 ndi zolakwika zina za 0 patebulo 'sys.sysnsobjs' (chinthu ID 44).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 76) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 50, index ID 1, ID yogawa 281474979987456, gawo logawira ID 281474979987456 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 292) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 50, index ID 2, ID yogawa 562949956698112, gawo logawira ID 562949956698112 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 294) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 50, index ID 3, ID yogawa 844424933408768, gawo logawira ID 844424933408768 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
CHECKDB idapeza zolakwika zitatu kugawa ndi 3 zolakwika zosasinthika mu tebulo 'sys.sysscalartypes' (chinthu ID 0).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 125) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 54, index ID 1, ID yogawa 281474980249600, gawo logawira ID 281474980249600 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 284) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 54, index ID 2, ID yogawa 562949956960256, gawo logawira ID 562949956960256 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
CHECKDB idapeza zolakwika za kugawa 2 ndi zolakwika zina 0 patebulo 'sys.sysidxstats' (chinthu ID 54).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 141) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 55, index ID 1, ID yogawa 281474980315136, gawo logawira ID 281474980315136 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 55) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 55, index ID 2, ID yogawa 562949957025792, gawo logawira ID 562949957025792 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
CHECKDB idapeza zolakwika ziwiri pakugawa ndi zolakwika zosasinthasintha 2 mu tebulo 'sys.sysiscols' (chinthu ID 0).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 13) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 58, index ID 1, ID yogawa 281474980511744, gawo logawira ID 72057594037993472 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 84) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 58, index ID 2, ID yogawa 562949957222400, gawo logawira ID 72057594038059008 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
CHECKDB idapeza zolakwika zakugawana 2 ndi zolakwika 0 zosasinthika mu tebulo 'sys.sysbinobjs' (chinthu ID 58).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 129) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 60, index ID 1, ID yogawa 281474980642816, gawo logawira ID 281474980642816 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1:45) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (mtundu wa LOB data) , koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
CHECKDB idapeza zolakwika za kugawa 2 ndi zolakwika zosasinthika 0 mu tebulo 'sys.sysobjvalues' (chinthu ID 60).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 88) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 64, index ID 1, ID yogawa 281474980904960, gawo logawira ID 281474980904960 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 243) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 64, index ID 2, ID yogawa 562949957615616, gawo logawira ID 562949957615616 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
CHECKDB idapeza zolakwika ziwiri pakugawa ndi zolakwika 2 zosagwirizana pa tebulo 'sys.sysclsobjs' (chinthu ID 0).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 15) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 69, index ID 1, ID yogawa 281474981232640, gawo logawira ID 72057594039697408 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 39) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 69, index ID 2, ID yogawa 562949957943296, gawo logawira ID 72057594039762944 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 290) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 69, index ID 3, ID yogawa 844424934653952, gawo logawira ID 72057594039828480 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
CHECKDB idapeza zolakwika zitatu kugawa ndi zolakwika 3 patebulo 'sys.ysysrts' (chinthu ID 0).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 98) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 74, index ID 1, ID yogawa 281474981560320, gawo logawira ID 281474981560320 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 100) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 74, index ID 2, ID yogawa 562949958270976, gawo logawira ID 562949958270976 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
CHECKDB idapeza zolakwika ziwiri pakugawa ndi zolakwika 2 zosagwirizana patebulo 'sysysslelejjrefs' (chinthu ID 0).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 104) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 75, index ID 1, ID yogawa 281474981625856, gawo logawira ID 281474981625856 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 106) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 75, index ID 2, ID yogawa 562949958336512, gawo logawira ID 562949958336512 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
CHECKDB idapeza zolakwika ziwiri pakugawa ndi zolakwika 2 zosagwirizana patebulo 'sys.sysmultiobjrefs' (chinthu ID 0).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 33) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 90, index ID 1, ID yogawa 281474982608896, gawo logawira ID 72057594038583296 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 81) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 90, index ID 2, ID yogawa 562949959319552, gawo logawira ID 72057594038648832 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
CHECKDB idapeza zolakwika ziwiri pakugawa ndi zolakwika za 2 m'matabule 'sys.sysqnames' (chinthu ID 0).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 49) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 91, index ID 1, ID yogawa 281474982674432, gawo logawira ID 72057594038779904 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 35) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 91, index ID 2, ID yogawa 562949959385088, gawo logawira ID 72057594038845440 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
CHECKDB idapeza zolakwika ziwiri pakugawa ndi zolakwika zosasinthasintha 2 mu tebulo 'sys.sysxmlcomponent' (chinthu ID 0).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 83) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 92, index ID 1, ID yogawa 281474982739968, gawo logawira ID 72057594038976512 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
CHECKDB idapeza zolakwika za 1 ndi zolakwika zosasinthasintha mu tebulo 'sys.sysxmlfacet' (chinthu ID 0).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 130) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 93, index ID 1, ID yogawa 281474982805504, gawo logawira ID 72057594039107584 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 22) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 93, index ID 2, ID yogawa 562949959516160, gawo logawira ID 72057594039173120 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
CHECKDB idapeza zolakwika ziwiri pakugawa ndi zolakwika zosasinthasintha 2 mu tebulo 'sys.sysxmlplacement' (chinthu ID 0).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 114) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 97, index ID 1, ID yogawa 281474983067648, gawo logawira ID 72057594038190080 (lembani mzere data), koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 134) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 97, index ID 2, ID yogawa 562949959778304, gawo logawira ID 72057594038255616 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
CHECKDB idapeza zolakwika ziwiri pakugawa ndi zolakwika 2 zosagwirizana patebulo 'sys.sysbinsubobjs' (chinthu ID 0).
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Sitinathe kukonza vutoli.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Sitinathe kukonza vutoli.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Sitinathe kukonza vutoli.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Sitinathe kukonza vutoli.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Sitinathe kukonza vutoli.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
Msg 8939, Mzere wa 16, State 98, Line 8
Zolakwitsa patebulo: ID ya Object 99, index ID 0, ID ID 0, gawo logawira ID 6488064 (mtundu wogawa Kwadongosolo), tsamba (57311: 268369920). Mayeso (IS_OFF (BUF_IOERR, pBUF-> bstat)) alephera. Makhalidwe ndi 2057 ndi -4.
CHECKDB idapeza zolakwika zisanu kugawa ndi zolakwika 5 zosasinthika patebulo '(Object ID 28)' (object ID 99).
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 120) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 245575913, index ID 0, ID yogawa 72057594040549376, gawo logawira ID 72057594045792256 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1:118) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045857792 (mtundu wa LOB data) , koma sichinapezeke pakuwunika.
Sitinathe kukonza vutoli.
Msg 2575, Mzere wa 16, State 1, Line 8
Tsamba la Index Allocation Map (IAM) (1: 126) likuwonetsedwa ndi cholozera chotsatira cha tsamba la IAM (0: 0) mu ID ID 245575913, index ID 2, ID yogawa 72057594040614912, gawo logawira ID 72057594045923328 (lembani mzere data), koma sichinapezeke pakuwunika.
Kukonza cholakwika ichi kumafuna zolakwika zina kuti zikonzedwe kaye.
CHECKDB idapeza zolakwika 3 kugawa ndi zolakwika 0 patebulo 'TestTable' (chinthu ID 245575913).
CHECKDB idapeza zolakwika za kugawa 58 ndi zolakwika 28 zosasinthika mu database 'xxxx'.

pomwe 'xxxx' ndi dzina la database yachinyengo ya MDF yomwe ikukonzedwa.

Uku ndikulakwitsa pagawidwe popeza pali zovuta pamasamba a IAM, ofanana ndi Msg 2575 Zolakwika.

Chithunzi chojambula cha uthenga wolakwika:

Kufotokozera Kwenikweni:

Zomwe zili mu fayilo ya MDF zimasungidwa ngati masamba, tsamba lililonse ndi 8KB. Tsamba la Index Allocation Map (IAM) limagwiritsidwa ntchito kugawa masamba mu MDF File, ndipo amalumikizidwa ngati mndandanda.

Ngati lamulo la DBCC CHECKDB lapeza kuti mndandanda wamasamba a IAM ndiwosavomerezeka ndipo sungathetse vutolo, ndiye kuti lipoti ili.

Mutha kugwiritsa ntchito mankhwala athu DataNumen SQL Recovery kuti mubwezeretse zomwe zili mu fayilo yoyipa ya MDF ndikuthana ndi vutoli.

Zitsanzo owona:

Zitsanzo za mafayilo achinyengo a MDF omwe angayambitse fayilo ya Msg 2575 cholakwika:

SQL Server Baibulo Ziphuphu MDF wapamwamba Fayilo ya MDF yokonzedwa ndi DataNumen SQL Recovery
SQL Server 2014 Cholakwika2.mdf Zolakwika2_fixed.mdf

 

Zothandizira:

1. https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-2575-database-engine-error?view=sql-server-ver15