Uphawu:

Xa usebenzisa DBCC CHECKDB kunye REPAIR_ALLOW_DATA_LOSS iparameter ukulungisa idatabase ye.MDF eyonakeleyo, ngolu hlobo:

I-DBCC CHECKDB(xxxx, 'REPAIR_ALLOW_DATA_LOSS')

ubona lo myalezo wemposiso ulandelayo:

Nksg 8921, iNqanaba 16, i-State 1, i-Line 8
Ukukhangela kuphelisiwe. Ukusilela kwafunyaniswa ngelixa kuqokelelwa iinyani. Inokwenzeka ukuba i-temdb iphume kwindawo okanye inkqubo yetafile ayihambelani. Jonga iimpazamo zangaphambili.
Nksg 8998, iNqanaba 16, i-State 2, i-Line 8
Iimpazamo zephepha kumaphepha e-GAM, e-SGAM, okanye e-PFS zithintela ukutshekishwa kwengqibelelo yolwabiwo kwi-ID yedatha engama-39 amaphepha ukusuka (1:0) ukuya ku-(1:8087). Bona ezinye iimpazamo ngesizathu.
I-CHECKDB ifumene iimpazamo ezi-1 zolwabiwo kunye neempazamo ezi-0 zokuhambelana ezingahambelani nayo nayiphi na into enye.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:157) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 3, index ID 1, partition ID 196608, alloc unit ID 196608 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
I-CHECKDB ifumene iimpazamo ezi-1 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.sysrscols' (i-ID yento 3).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:131) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 5, index ID 1, partition ID 327680, alloc unit ID 327680 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
I-CHECKDB ifumene iimpazamo ezi-1 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.sysrowsets' (i-ID yento 5).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:21) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 7, index ID 1, partition ID 458752, alloc unit ID 458752 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:18) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 7, index ID 2, partition ID 562949953880064, alloc unit ID 562949953880064 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
I-CHECKDB ifumene iimpazamo ezi-2 zolwabiwo kunye neempazamo ezi-0 zokungqinelana kwitheyibhile 'sys.sysallocunits' (i-ID yento yesi-7).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:12) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 8, index ID 0, partition ID 524288, alloc unit ID 524288 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
I-CHECKDB ifumene iimpazamo ezi-1 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.sysfiles1' (i-ID yento yesi-8).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:137) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 20, index ID 1, partition ID 281474978021376, alloc unit ID 281474978021376 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
I-CHECKDB ifumene iimpazamo ezi-1 zolwabiwo kunye neemposiso ezi-0 ezihambelanayo kwitheyibhile 'sys.sysdbfiles' (i-ID yento engama-20).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:152) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 23, index ID 1, partition ID 281474978217984, alloc unit ID 281474978217984 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
I-CHECKDB ifumene iimpazamo ezi-1 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.sysphfg' (i-ID yento engama-23).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:154) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 24, index ID 1, partition ID 281474978283520, alloc unit ID 281474978283520 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
I-CHECKDB ifumene iimpazamo ezi-1 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.sysprufiles' (i-ID yento engama-24).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:92) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 27, index ID 1, partition ID 281474978480128, alloc unit ID 281474978480128 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:288) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 27, index ID 2, partition ID 562949955190784, alloc unit ID 562949955190784 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:96) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 27, index ID 3, partition ID 844424931901440, alloc unit ID 844424931901440 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
I-CHECKDB ifumene iimpazamo ezi-3 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.sysowners' (i-ID yento engama-27).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:102) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 29, index ID 1, partition ID 281474978611200, alloc unit ID 281474978611200 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
I-CHECKDB ifumene iimpazamo ezi-1 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.sysprivs' (i-ID yento engama-29).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:117) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:295) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 34, index ID 2, partition ID 562949955649536, alloc unit ID 562949955649536 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:368) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 34, index ID 3, partition ID 844424932360192, alloc unit ID 844424932360192 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:123) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 34, index ID 4, partition ID 1125899909070848, alloc unit ID 1125899909070848 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
I-CHECKDB ifumene iimpazamo ezi-4 zolwabiwo kunye neempazamo ze-0 zokuhambelana kwitheyibhile 'sys.sysschobjs' (i-ID yento 34).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:108) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:245) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 41, index ID 2, partition ID 562949956108288, alloc unit ID 562949956108288 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
I-CHECKDB ifumene iimpazamo ezi-2 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.syscocolpars' (i-ID yento 41).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:10) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 44, index ID 1, partition ID 281474979594240, alloc unit ID 281474979594240 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:286) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 44, index ID 2, partition ID 562949956304896, alloc unit ID 562949956304896 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
I-CHECKDB ifumene iimpazamo ezi-2 zolwabiwo kunye neempazamo ze-0 zokuhambelana kwitheyibhile 'sys.sysnsobjs' (i-ID yento 44).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:76) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 50, index ID 1, partition ID 281474979987456, alloc unit ID 281474979987456 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:292) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 50, index ID 2, partition ID 562949956698112, alloc unit ID 562949956698112 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:294) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 50, index ID 3, partition ID 844424933408768, alloc unit ID 844424933408768 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
I-CHECKDB ifumene iimpazamo ezi-3 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.sysscalartypes' (i-ID yento engama-50).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:125) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 54, index ID 1, partition ID 281474980249600, alloc unit ID 281474980249600 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:284) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 54, index ID 2, partition ID 562949956960256, alloc unit ID 562949956960256 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
I-CHECKDB ifumene iimpazamo ezi-2 zolwabiwo kunye neempazamo ezi-0 zokungqinelana kwitheyibhile 'sys.sysidxstats' (i-ID yento engama-54).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:141) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 55, index ID 1, partition ID 281474980315136, alloc unit ID 281474980315136 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:55) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 55, index ID 2, partition ID 562949957025792, alloc unit ID 562949957025792 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
I-CHECKDB ifumene iimpazamo ezi-2 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.sysicols' (i-ID yento 55).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:13) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 58, index ID 1, partition ID 281474980511744, alloc unit ID 72057594037993472 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:84) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 58, index ID 2, partition ID 562949957222400, alloc unit ID 72057594038059008 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
I-CHECKDB ifumene iimpazamo ezi-2 zolwabiwo kunye neempazamo ze-0 zokuhambelana kwitheyibhile 'sys.sysbinobjs' (i-ID yento 58).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:129) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:45) ilathiswe kwisalathiso esilandelayo sephepha le-IAM (0:0) kwi-ID ye-ID 60, i-ID yesalathisi 1, i-ID yecandelo 281474980642816, i-alloc unit ID 71776119065149440 (uhlobo lwedatha ye-LOB) , kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
I-CHECKDB ifumene iimpazamo ezi-2 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.sysobjvalues' (i-ID yento 60).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:88) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 64, index ID 1, partition ID 281474980904960, alloc unit ID 281474980904960 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:243) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 64, index ID 2, partition ID 562949957615616, alloc unit ID 562949957615616 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
I-CHECKDB ifumene iimpazamo ezi-2 zolwabiwo kunye neempazamo ze-0 zokuhambelana kwitheyibhile 'sys.sysclsobjs' (i-ID yento 64).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:15) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 69, index ID 1, partition ID 281474981232640, alloc unit ID 72057594039697408 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:39) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 69, index ID 2, partition ID 562949957943296, alloc unit ID 72057594039762944 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:290) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 69, index ID 3, partition ID 844424934653952, alloc unit ID 72057594039828480 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
I-CHECKDB ifumene iimpazamo ezi-3 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.sysrts' (i-ID yento 69).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:98) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 74, index ID 1, partition ID 281474981560320, alloc unit ID 281474981560320 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:100) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 74, index ID 2, partition ID 562949958270976, alloc unit ID 562949958270976 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
I-CHECKDB ifumene iimpazamo ezi-2 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.syssingleobjrefs' (i-ID yento 74).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:104) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 75, index ID 1, partition ID 281474981625856, alloc unit ID 281474981625856 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:106) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 75, index ID 2, partition ID 562949958336512, alloc unit ID 562949958336512 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
I-CHECKDB ifumene iimpazamo ezi-2 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.sysmultiobjrefs' (i-ID yento 75).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:33) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 90, index ID 1, partition ID 281474982608896, alloc unit ID 72057594038583296 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:81) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 90, index ID 2, partition ID 562949959319552, alloc unit ID 72057594038648832 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
I-CHECKDB ifumene iimpazamo ezi-2 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.sysqnames' (i-ID yento engama-90).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:49) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 91, index ID 1, partition ID 281474982674432, alloc unit ID 72057594038779904 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:35) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 91, index ID 2, partition ID 562949959385088, alloc unit ID 72057594038845440 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
I-CHECKDB ifumene iimpazamo ezi-2 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.sysxmlcomponent' (i-ID yento engama-91).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:83) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 92, index ID 1, partition ID 281474982739968, alloc unit ID 72057594038976512 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
I-CHECKDB ifumene iimpazamo ezi-1 zolwabiwo kunye neempazamo ezi-0 zokungqinelana kwitheyibhile 'sys.sysxmlfacet' (i-ID yento engama-92).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:130) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 93, index ID 1, partition ID 281474982805504, alloc unit ID 72057594039107584 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:22) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 93, index ID 2, partition ID 562949959516160, alloc unit ID 72057594039173120 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
I-CHECKDB ifumene iimpazamo ezi-2 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.sysxmlplacement' (i-ID yento engama-93).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:114) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 97, index ID 1, partition ID 281474983067648, alloc unit ID 72057594038190080 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:134) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 97, index ID 2, partition ID 562949959778304, alloc unit ID 72057594038255616 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
I-CHECKDB ifumene iimpazamo ezi-2 zolwabiwo kunye neempazamo ezi-0 zokuhambelana kwitheyibhile 'sys.sysbinsubobjs' (i-ID yento 97).
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Ayikwazanga ukulungisa le mpazamo.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Ayikwazanga ukulungisa le mpazamo.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Ayikwazanga ukulungisa le mpazamo.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Ayikwazanga ukulungisa le mpazamo.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Ayikwazanga ukulungisa le mpazamo.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
Nksg 8939, iNqanaba 16, i-State 98, i-Line 8
Impazamo yetheyibhile: I-ID yeNto 99, i-ID yesalathiso 0, i-ID yokwahlula 0, i-alloc unit ID 6488064 (uhlobo lwedatha yoLwabiwo lweSistim), iphepha (57311:268369920). Uvavanyo (IS_OFF (BUF_IOERR, pBUF->bstat)) aluphumelelanga. Amaxabiso ngama-2057 kunye -4.
I-CHECKDB ifumene iimpazamo ezi-5 zolwabiwo kunye neempazamo ezingama-28 zokungqinelana kwitheyibhile '(Object ID 99)' (i-ID yento 99).
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:120) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 245575913, index ID 0, partition ID 72057594040549376, alloc unit ID 72057594045792256 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:118) ilathiswe kwisalathiso esilandelayo sephepha le-IAM (0:0) kwi-ID ye-ID 245575913, i-ID yesalathisi 0, i-ID yecandelo 72057594040549376, i-alloc unit ID 72057594045857792 (uhlobo lwedatha ye-LOB) , kodwa ayizange ibonwe kwiscan.
Ayikwazanga ukulungisa le mpazamo.
Nksg 2575, iNqanaba 16, i-State 1, i-Line 8
I-Index Allocation Map (IAM) iphepha (1:126) ilathiswa kwisalathiso esilandelayo sephepha le-IAM (0:0) kwinto ID 245575913, index ID 2, partition ID 72057594040614912, alloc unit ID 72057594045923328 (uhlobo olukumqolo data), kodwa ayizange ibonwe kwiscan.
Ukulungisa le mpazamo kufuna ezinye iimpazamo ukuba zilungiswe kuqala.
I-CHECKDB ifumene iimpazamo ezi-3 zolwabiwo kunye neempazamo ezingama-0 zokungqinelana kwitheyibhile 'TestTable' (i-ID yento 245575913).
I-CHECKDB ifumene iimpazamo ezi-58 zolwabiwo kunye neempazamo ezi-28 ezihambelanayo kwiziko ledatha 'xxxx'.

apho 'xxxx' ligama lesiseko sedatha esonakeleyo se-MDF elungiswayo.

Le yimposiso yolwabiwo kuba kukho iingxaki kumaphepha e-IAM, ahambelanayo UMsg 2575 mpazamo.

Umfanekiso weskrini wemposiso:

Ingcaciso echanekileyo:

Idatha kwifayile ye-MDF igcinwe njengamaphepha, iphepha ngalinye yi-8KB. Isalathiso seMaphu yoLwabiwo lwephepha (IAM) sisetyenziselwa ukwaba amaphepha kwiFayile yeMDF, kwaye adityaniswe njengoluhlu.

Ukuba umyalelo we-DBCC CHECKDB ufumana uluhlu oludityanisiweyo lwamaphepha e-IAM alusebenzi kwaye alunako ukuyilungisa ingxaki, ngoko izakuxela le mpazamo.

Ungasebenzisa imveliso yethu DataNumen SQL Recovery ukubuyisela idatha kwifayile ye-MDF eyonakele kwaye uyisombulule le mpazamo.

Iifayili zesampulu:

Isampulu yeefayile zeMDF ezonakeleyo eziya kubangela i Msg 2575 impazamo:

SQL Server Inguqulelo Ifayile ye-MDF eyonakele Ifayile ye-MDF ilungiswe ngu DataNumen SQL Recovery
SQL Server 2014 Imposiso2.mdf Imposiso2_ilungisiwe.mdf

 

Iingxelo:

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