Tohu:

A, no te whakamahi DBCC CHECKDB mā te REPAIR_ALLOW_DATA_LOSS tawhā hei whakapai ake i te papaanga raraunga .MDF pirau, penei:

DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')

ka kite koe i nga korero hapa e whai ake nei:

Msg 8921, Taumata 16, State 1, Raina 8
Kua whakamutua te tirotiro. I kitea i rahua te kohikohi korero pono. Akene ko te tempdb kei waho o te waahi, ko te teepu punaha ranei te mea rereke. Tirohia nga hapa o mua.
Msg 8998, Taumata 16, State 2, Raina 8
Ko nga hapa o te whaarangi kei runga i nga whaarangi GAM, SGAM, PFS ranei e aukati ana i te tohatoha tika i nga wharangi ID 39 whaarangi mai i te (1: 0) ki te (1: 8087). Tirohia etahi atu hapa mo te take.
I kitea e te CHECKDB nga hapa tohatoha me nga hapa 1 kaore i honoa ki tetahi mea kotahi.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 157) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 3, ID tohu 1, ID wahanga 196608, toha ID ID 196608 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
I kitea e te CHECKDB nga rahinga tohatoha 1 me nga hapa hapa i roto i te teepu 'sys.sysrscols' (ID ahanoa 0).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 131) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 5, ID tohu 1, ID wahanga 327680, toha ID ID 327680 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
I kitea e te CHECKDB nga rahinga tohatoha 1 me nga hapa hapa 0 i te teepu 'sys.sysrowsets' (ID ahanoa 5).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 21) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 7, ID tohu 1, ID wahanga 458752, toha ID ID 458752 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 18) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 7, ID tohu 2, ID wahanga 562949953880064, toha ID ID 562949953880064 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
I kitea e te CHECKDB nga hapa tohatoha e 2 me nga hapa hapa i roto i te teepu 'sys.sysallocunits' (ID ahanoa 0).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 12) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 8, ID tohu 0, ID wahanga 524288, toha ID ID 524288 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
I kitea e te CHECKDB nga rahinga tohatoha 1 me nga hapa hapa i roto i te teepu 'sys.sysfiles0' (ID ahanoa 1).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 137) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 20, ID tohu 1, ID wahanga 281474978021376, toha ID ID 281474978021376 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
I kitea e te CHECKDB nga rahinga tohatoha 1 me nga hapa hapa i roto i te teepu 'sys.sysdbfiles '(ID ahanoa 20).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 152) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 23, ID tohu 1, ID wahanga 281474978217984, toha ID ID 281474978217984 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
I kitea e te CHECKDB nga rahinga tohatoha 1 me nga hapa hapa 0 i te teepu 'sys.sysphfg' (ahanoa ID 23).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 154) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 24, ID tohu 1, ID wahanga 281474978283520, toha ID ID 281474978283520 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
I kitea e te CHECKDB nga rahinga tohatoha 1 me nga hapa hapa 0 i te teepu 'sys.sysprufiles' (ID ahanoa 24).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 92) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 27, ID tohu 1, ID wahanga 281474978480128, toha ID ID 281474978480128 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 288) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 27, ID tohu 2, ID wahanga 562949955190784, toha ID ID 562949955190784 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 96) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 27, ID tohu 3, ID wahanga 844424931901440, toha ID ID 844424931901440 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
I kitea e te CHECKDB nga rahinga tohatoha 3 me nga hapa hapa 0 i te teepu 'sys.sysowners' (ahanoa ID 27).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 102) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 29, ID tohu 1, ID wahanga 281474978611200, toha ID ID 281474978611200 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
I kitea e te CHECKDB nga rahinga tohatoha 1 me nga hapa hapa 0 i te teepu 'sys.sysprivs' (ID ahanoa 29).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 117) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 34, ID tohu 1, ID wahanga 281474978938880, toha ID ID 281474978938880 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 295) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 34, ID tohu 2, ID wahanga 562949955649536, toha ID ID 562949955649536 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 368) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 34, ID tohu 3, ID wahanga 844424932360192, toha ID ID 844424932360192 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 123) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 34, ID tohu 4, ID wahanga 1125899909070848, toha ID ID 1125899909070848 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
I kitea e te CHECKDB e 4 nga toha tohatoha me te 0 nga hapa hapa i te teepu 'sys.sysschobjs' (ID ahanoa 34).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 108) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 41, ID tohu 1, ID wahanga 281474979397632, toha ID ID 281474979397632 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 245) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 41, ID tohu 2, ID wahanga 562949956108288, toha ID ID 562949956108288 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
I kitea e te CHECKDB nga hapa tohatoha me nga hapa 2 e rite ana ki te teepu 'sys.syscolpars' (ID mea 0).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 10) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 44, ID tohu 1, ID wahanga 281474979594240, toha ID ID 281474979594240 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 286) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 44, ID tohu 2, ID wahanga 562949956304896, toha ID ID 562949956304896 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
I kitea e te CHECKDB nga hapa tohatoha e 2 me nga hapa hapa e 0 i te teepu 'sys.sysnsobjs' (ahanoa ID 44).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 76) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 50, ID tohu 1, ID wahanga 281474979987456, toha ID ID 281474979987456 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 292) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 50, ID tohu 2, ID wahanga 562949956698112, toha ID ID 562949956698112 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 294) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 50, ID tohu 3, ID wahanga 844424933408768, toha ID ID 844424933408768 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
I kitea e te CHECKDB nga hapa tohatoha e 3 me nga hapa hapa i roto i te teepu 'sys.sysscalartypes' (ahanoa ID 0).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 125) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 54, ID tohu 1, ID wahanga 281474980249600, toha ID ID 281474980249600 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 284) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 54, ID tohu 2, ID wahanga 562949956960256, toha ID ID 562949956960256 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
I kitea e te CHECKDB nga hapa tohatoha me nga hapa 2 e rite ana ki te teepu 'sys.sysidxstats' (ID ahanoa 0).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 141) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 55, ID tohu 1, ID wahanga 281474980315136, toha ID ID 281474980315136 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 55) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 55, ID tohu 2, ID wahanga 562949957025792, toha ID ID 562949957025792 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
I kitea e te CHECKDB nga hapa tohatoha e 2 me nga hapa hapa i te raarangi 'sys.sysiscols' (ID mea 0).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 13) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 58, ID tohu 1, ID wahanga 281474980511744, toha ID ID 72057594037993472 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 84) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 58, ID tohu 2, ID wahanga 562949957222400, toha ID ID 72057594038059008 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
I kitea e te CHECKDB nga hapa tohatoha e 2 me nga hapa hapa i roto i te teepu 'sys.sysbinobjs' (ahanoa ID 0).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 129) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 60, ID tohu 1, ID wahanga 281474980642816, toha ID ID 281474980642816 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1:45) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 60, ID tohu 1, ID wehewehe 281474980642816, toha ID ID 71776119065149440 (momo raraunga LOB) , engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
I kitea e te CHECKDB nga hapa tohatoha me nga hapa e 2 o te tepu 'sys.sysobjvalues' (ahanoa ID 0).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 88) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 64, ID tohu 1, ID wahanga 281474980904960, toha ID ID 281474980904960 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 243) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 64, ID tohu 2, ID wahanga 562949957615616, toha ID ID 562949957615616 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
I kitea e te CHECKDB nga hapa tohatoha e 2 me nga hapa hapa i roto i te teepu 'sys.sysclsobjs' (ahanoa ID 0).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 15) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 69, ID tohu 1, ID wahanga 281474981232640, toha ID ID 72057594039697408 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 39) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 69, ID tohu 2, ID wahanga 562949957943296, toha ID ID 72057594039762944 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 290) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 69, ID tohu 3, ID wahanga 844424934653952, toha ID ID 72057594039828480 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
I kitea e te CHECKDB nga hapa tohatoha e 3 me nga hapa hapa i roto i te teepu 'sys.sysrts' (ahanoa ID 0).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 98) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 74, ID tohu 1, ID wahanga 281474981560320, toha ID ID 281474981560320 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 100) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 74, ID tohu 2, ID wahanga 562949958270976, toha ID ID 562949958270976 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
I kitea e te CHECKDB nga hapa tohatoha e 2 me nga hapa hapa i roto i te teepu 'sys.syssingleobjrefs' (ahanoa ID 0).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 104) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 75, ID tohu 1, ID wahanga 281474981625856, toha ID ID 281474981625856 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 106) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 75, ID tohu 2, ID wahanga 562949958336512, toha ID ID 562949958336512 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
I kitea e te CHECKDB nga hapa tohatoha e 2 me nga hapa hapa i roto i te teepu 'sys.sysmultiobjrefs' (ahanoa ID 0).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 33) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 90, ID tohu 1, ID wahanga 281474982608896, toha ID ID 72057594038583296 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 81) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 90, ID tohu 2, ID wahanga 562949959319552, toha ID ID 72057594038648832 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
I kitea e te CHECKDB nga hapa tohatoha e 2 me nga hapa hapa i roto i te teepu 'sys.sysqnames' (ID ahanoa 0).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 49) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 91, ID tohu 1, ID wahanga 281474982674432, toha ID ID 72057594038779904 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 35) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 91, ID tohu 2, ID wahanga 562949959385088, toha ID ID 72057594038845440 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
I kitea e te CHECKDB nga hapa tohatoha e 2 me nga hapa hapa i roto i te teepu 'sys.sysxmlcomponent' (ahanoa ID 0).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 83) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 92, ID tohu 1, ID wahanga 281474982739968, toha ID ID 72057594038976512 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
I kitea e te CHECKDB nga rahinga tohatoha 1 me nga hapa hapa 0 i te teepu 'sys.sysxmlfacet' (ahanoa ID 92).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 130) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 93, ID tohu 1, ID wahanga 281474982805504, toha ID ID 72057594039107584 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 22) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 93, ID tohu 2, ID wahanga 562949959516160, toha ID ID 72057594039173120 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
I kitea e te CHECKDB nga hapa tohatoha e 2 me nga hapa hapa i roto i te teepu 'sys.sysxmlplaced' (ahanoa ID 0).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 114) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 97, ID tohu 1, ID wahanga 281474983067648, toha ID ID 72057594038190080 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 134) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 97, ID tohu 2, ID wahanga 562949959778304, toha ID ID 72057594038255616 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
I kitea e te CHECKDB nga hapa tohatoha e 2 me nga hapa hapa i roto i te teepu 'sys.sysbinsubobjs' (ahanoa ID 0).
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Kaore i taea te whakatika i tenei he.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Kaore i taea te whakatika i tenei he.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Kaore i taea te whakatika i tenei he.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Kaore i taea te whakatika i tenei he.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Kaore i taea te whakatika i tenei he.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
Msg 8939, Taumata 16, State 98, Raina 8
Hapa teepu: ID Ahanoa 99, ID taupū 0, ID wehewehe 0, tohatoha waeine ID 6488064 (momo punaha tohatoha punaha), whaarangi (57311: 268369920). Whakamatau (IS_OFF (BUF_IOERR, pBUF-> bstat)) i rahua. Ko nga uara 2057 me -4.
I kitea e te CHECKDB e 5 nga toha tohatoha me nga hapa hapa 28 i te teepu '(Ahanoa ID 99)' (Ahanoa ID 99).
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 120) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 245575913, ID tohu 0, ID wahanga 72057594040549376, toha ID ID 72057594045792256 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1:118) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 245575913, ID tohu 0, ID wehewehe 72057594040549376, toha ID ID 72057594045857792 (momo raraunga LOB) , engari kaore i kitea i te karapa.
Kaore i taea te whakatika i tenei he.
Msg 2575, Taumata 16, State 1, Raina 8
Ko te Mahere Toha Tohu (IAM) whaarangi (1: 126) kua tohua e te tohu muri o te whaarangi IAM (0: 0) i roto i te ID ahanoa 245575913, ID tohu 2, ID wahanga 72057594040614912, toha ID ID 72057594045923328 (momo In-haupae raraunga), engari kaore i kitea i te karapa.
Ko te whakatika i tenei hapa me whakatika etahi atu hapa i te tuatahi.
I kitea e te CHECKDB nga hapa tohatoha me nga hapa 3 i te teepu 'TestTable' (ID mea 0).
I kitea e CHECKDB 58 nga tohatoha hapa me te 28 nga hapa hapa i roto i te papaanga 'xxxx'.

kei reira te 'xxxx' te ingoa o te papaanga MDF kino e whakatikaia ana.

He hapa tohatoha tenei na te mea kei te raru nga wharangi IAM, e pa ana ki tenei Msg 2575 hapa.

Whakaahuamata o te hapa hapa:

Whakamarama Tino:

Ko nga raraunga kei te konae MDF ka penapenahia hei wharangi, ko ia wharangi ko te 8KB. Ko te Mahere Toha Tohu (IAM) e whakamahia ana hei tohatoha i nga whaarangi ki te MDF File, ana ka hono hei raarangi.

Mena ka kitea e te whakahau a DBCC CHECKDB te raarangi hono o nga whaarangi IAM e he ana kaore e taea te whakatika i te raru, ka ripoatahia tenei he.

Ka taea e koe te whakamahi i ta maatau hua DataNumen SQL Recovery ki te whakahoki mai i nga raraunga mai i te konae MDF kino ka whakatau i tenei he.

Kōnae Tauira:

Hei tauira, he kino nga konae MDF ka mate te Msg 2575 hapa:

SQL Server putanga Kōnae MDF pirau Ko te konae MDF na DataNumen SQL Recovery
SQL Server 2014 Hapa2.mdf Hapa2_fixed.mdf

 

Tohutoro:

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