Letšoao:

Ha o sebelisa TLHOKOMELISO DBCC le LOKISETSA_ALLOW_DATA_LOSS paramethara ho lokisa database e senyehileng ea .MDF, e kang ena:

DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')

u bona molaetsa o latelang oa phoso:

Msg 8921, Level 16, State 1, Line 8
Cheke e emisitsoe. Ho hloleha ho fumanoe ha ho ntse ho bokelloa lintlha. Mohlomong tempdb kantle ho sebaka kapa tafole ea sistimi ha e lumellane. Lekola liphoso tse fetileng.
Msg 8998, Level 16, State 2, Line 8
Liphoso tsa maqephe ho maqephe a GAM, SGAM, kapa PFS li thibela ho lekoa hoa botšepehi ho maqephe a ID ea database ho tloha ho (39: 1) ho isa ho (0: 1). Bona liphoso tse ling ka lebaka.
CHECKDB e fumane liphoso tse 1 tsa kabo le liphoso tse 0 tse sa amaneng le letho.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 157) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 3, index ID 1, karohano ID 196608, unit unit ID 196608 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
CHECKDB e fumane liphoso tse 1 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.ysyscols' (ntho ea ID 3).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 131) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 5, index ID 1, karohano ID 327680, unit unit ID 327680 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
CHECKDB e fumane liphoso tse 1 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysrowsets' (ntho ea ID 5).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 21) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 7, index ID 1, karohano ID 458752, unit unit ID 458752 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 18) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 7, index ID 2, karohano ID 562949953880064, unit unit ID 562949953880064 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
CHECKDB e fumane liphoso tse 2 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysallocunits' (ntho ea ID 7).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 12) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 8, index ID 0, karohano ID 524288, unit unit ID 524288 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
CHECKDB e fumane liphoso tse 1 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysfiles1' (ntho ea ID 8).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 137) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 20, index ID 1, karohano ID 281474978021376, unit unit ID 281474978021376 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
CHECKDB e fumane liphoso tse 1 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysdbfiles '(ntho ea ID 20).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 152) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 23, index ID 1, karohano ID 281474978217984, unit unit ID 281474978217984 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
CHECKDB e fumane liphoso tse 1 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysphfg' (ntho ea ID 23).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 154) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 24, index ID 1, karohano ID 281474978283520, unit unit ID 281474978283520 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
CHECKDB e fumane liphoso tse 1 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysprufiles' (ntho ea ID 24).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 92) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 27, index ID 1, karohano ID 281474978480128, unit unit ID 281474978480128 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 288) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 27, index ID 2, karohano ID 562949955190784, unit unit ID 562949955190784 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 96) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 27, index ID 3, karohano ID 844424931901440, unit unit ID 844424931901440 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
CHECKDB e fumane liphoso tse 3 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysowners' (ntho ea ID 27).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 102) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 29, index ID 1, karohano ID 281474978611200, unit unit ID 281474978611200 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
CHECKDB e fumane liphoso tse 1 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysprivs' (ntho ea ID 29).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 117) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 34, index ID 1, karohano ID 281474978938880, unit unit ID 281474978938880 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 295) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 34, index ID 2, karohano ID 562949955649536, unit unit ID 562949955649536 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 368) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 34, index ID 3, karohano ID 844424932360192, unit unit ID 844424932360192 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 123) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 34, index ID 4, karohano ID 1125899909070848, unit unit ID 1125899909070848 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
CHECKDB e fumane liphoso tse 4 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysschobjs' (ntho ID 34).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 108) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 41, index ID 1, karohano ID 281474979397632, unit unit ID 281474979397632 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 245) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 41, index ID 2, karohano ID 562949956108288, unit unit ID 562949956108288 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
CHECKDB e fumane liphoso tsa kabo tse 2 le liphoso tse 0 tse sa fetoheng tafoleng 'sys.syscolpars' (ntho ID 41).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 10) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 44, index ID 1, karohano ID 281474979594240, unit unit ID 281474979594240 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 286) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 44, index ID 2, karohano ID 562949956304896, unit unit ID 562949956304896 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
CHECKDB e fumane liphoso tse 2 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysnsobjs' (ntho ID 44).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 76) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 50, index ID 1, karohano ID 281474979987456, unit unit ID 281474979987456 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 292) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 50, index ID 2, karohano ID 562949956698112, unit unit ID 562949956698112 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 294) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 50, index ID 3, karohano ID 844424933408768, unit unit ID 844424933408768 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
CHECKDB e fumane liphoso tse 3 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysscalartypes' (ntho ea ID 50).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 125) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 54, index ID 1, karohano ID 281474980249600, unit unit ID 281474980249600 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 284) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 54, index ID 2, karohano ID 562949956960256, unit unit ID 562949956960256 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
CHECKDB e fumane liphoso tsa kabo tse 2 le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysidxstats' (ntho ID 54).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 141) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 55, index ID 1, karohano ID 281474980315136, unit unit ID 281474980315136 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 55) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 55, index ID 2, karohano ID 562949957025792, unit unit ID 562949957025792 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
CHECKDB e fumane liphoso tse 2 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysiscols' (ntho ea ID 55).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 13) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 58, index ID 1, karohano ID 281474980511744, unit unit ID 72057594037993472 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 84) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 58, index ID 2, karohano ID 562949957222400, unit unit ID 72057594038059008 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
CHECKDB e fumane liphoso tse 2 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysbinobjs' (ntho ea ID 58).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 129) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 60, index ID 1, karohano ID 281474980642816, unit unit ID 281474980642816 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1:45) le supiloe ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID ID 60, index ID 1, partition ID 281474980642816, unit unit ID 71776119065149440 (mofuta oa data ea LOB) , empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
CHECKDB e fumane liphoso tsa kabo tse 2 le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysobjvalues' (ntho ea ID 60).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 88) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 64, index ID 1, karohano ID 281474980904960, unit unit ID 281474980904960 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 243) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 64, index ID 2, karohano ID 562949957615616, unit unit ID 562949957615616 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
CHECKDB e fumane liphoso tse 2 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysclsobjs' (ntho ea ID 64).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 15) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 69, index ID 1, karohano ID 281474981232640, unit unit ID 72057594039697408 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 39) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 69, index ID 2, karohano ID 562949957943296, unit unit ID 72057594039762944 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 290) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 69, index ID 3, karohano ID 844424934653952, unit unit ID 72057594039828480 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
CHECKDB e fumane liphoso tse 3 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.ysysrts' (ntho ea ID 69).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 98) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 74, index ID 1, karohano ID 281474981560320, unit unit ID 281474981560320 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 100) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 74, index ID 2, karohano ID 562949958270976, unit unit ID 562949958270976 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
CHECKDB e fumane liphoso tse 2 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sysysslelejjrefs' (ntho ID 74).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 104) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 75, index ID 1, karohano ID 281474981625856, unit unit ID 281474981625856 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 106) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 75, index ID 2, karohano ID 562949958336512, unit unit ID 562949958336512 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
CHECKDB e fumane liphoso tse 2 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysmultiobjrefs' (ntho ID 75).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 33) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 90, index ID 1, karohano ID 281474982608896, unit unit ID 72057594038583296 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 81) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 90, index ID 2, karohano ID 562949959319552, unit unit ID 72057594038648832 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
CHECKDB e fumane liphoso tse 2 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysqnames' (ntho ID 90).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 49) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 91, index ID 1, karohano ID 281474982674432, unit unit ID 72057594038779904 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 35) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 91, index ID 2, karohano ID 562949959385088, unit unit ID 72057594038845440 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
CHECKDB e fumane liphoso tse 2 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysxmlcomponent' (ntho ID 91).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 83) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 92, index ID 1, karohano ID 281474982739968, unit unit ID 72057594038976512 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
CHECKDB e fumane liphoso tse 1 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysxmlfacet' (ntho ID 92).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 130) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 93, index ID 1, karohano ID 281474982805504, unit unit ID 72057594039107584 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 22) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 93, index ID 2, karohano ID 562949959516160, unit unit ID 72057594039173120 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
CHECKDB e fumane liphoso tse 2 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysxmlplacement' (ntho ID 93).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 114) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 97, index ID 1, karohano ID 281474983067648, unit unit ID 72057594038190080 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 134) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 97, index ID 2, karohano ID 562949959778304, unit unit ID 72057594038255616 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
CHECKDB e fumane liphoso tse 2 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysbinsubobjs' (ntho ID 97).
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Ha e khone ho lokisa phoso ena.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Ha e khone ho lokisa phoso ena.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Ha e khone ho lokisa phoso ena.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Ha e khone ho lokisa phoso ena.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Ha e khone ho lokisa phoso ena.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
Msg 8939, Level 16, State 98, Line 8
Phoso ea tafole: ID ea ntho 99, index ea ID 0, karohano ea ID 0, unit ea ID ea ID 6488064 (mofuta oa data ea kabo ea Sisteme), leqephe (57311: 268369920). Teko (IS_OFF (BUF_IOERR, pBUF-> bstat)) e hlolehile. Litekanyetso ke 2057 le -4.
CHECKDB e fumane liphoso tse 5 tsa kabo le liphoso tse 28 tse sa fetoheng tafoleng '(Object ID 99)' (object ID 99).
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 120) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 245575913, index ID 0, karohano ID 72057594040549376, unit unit ID 72057594045792256 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1:118) le supiloe ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID ID 245575913, index ID 0, partition ID 72057594040549376, unit unit ID 72057594045857792 (mofuta oa data ea LOB) , empa ha ea ka ea fumanoa ho scan.
Ha e khone ho lokisa phoso ena.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 126) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 245575913, index ID 2, karohano ID 72057594040614912, unit unit ID 72057594045923328 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Ho lokisa phoso ena ho hloka hore liphoso tse ling li lokisoe pele.
CHECKDB e fumane liphoso tse 3 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng ea 'TestTable' (ntho ea ID 245575913).
CHECKDB e fumane liphoso tsa kabo tse 58 le liphoso tse sa fetoheng tsa 28 ho database 'xxxx'.

moo 'xxxx' e leng lebitso la database e senyehileng ea MDF e lokisoang.

Ena ke phoso ea kabo kaha ho na le mathata ka maqephe a IAM, a tsamaellanang le Msg 2575 phoso.

Screenshot ea molaetsa oa phoso:

Tlhaloso e hlakileng:

Lintlha tse faeleng ea MDF li bolokiloe e le maqephe, leqephe ka leng ke 8KB. Leqephe la Index Allocation Map (IAM) le sebelisetsoa ho aba maqephe a MDF File, 'me a hokahantsoe joalo ka lenane.

Haeba taelo ea DBCC CHECKDB e fumana lethathamo le hokahaneng la maqephe a IAM a sa sebetse ebile e ke ke ea lokisa bothata, e tla tlaleha phoso ena.

U ka sebelisa sehlahisoa sa rona DataNumen SQL Recovery ho khutlisa data ho tsoa faeleng e senyehileng ea MDF le ho rarolla phoso ena.

Sampula Files:

Mohlala oa lifaele tsa MDF tse senyehileng tse tla baka faele ea Phoso ea Msg 2575:

SQL Server tlhahiso Faele ea MDF e senyehileng Faele ea MDF e hlophisitsoeng ke DataNumen SQL Recovery
SQL Server 2014 Phoso2.mdf Phoso2_fixed.mdf

 

References:

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