Aisan:

Nigba lilo DBCC Ṣayẹwo pẹlu REPAIR_ALLOW_DATA_LOSS paramita lati tunṣe ibi ipamọ data .MDF bajẹ, bii eleyi:

DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')

o wo ifiranṣẹ aṣiṣe wọnyi:

Msg 8921, Ipele 16, Ipinle 1, Laini 8
Ṣayẹwo fopin. A ṣe awari ikuna lakoko gbigba awọn otitọ. O ṣee ṣe ki tempdb jade kuro ni aaye tabi tabili eto ko ni ibamu. Ṣayẹwo awọn aṣiṣe iṣaaju.
Msg 8998, Ipele 16, Ipinle 2, Laini 8
Awọn aṣiṣe oju-iwe lori awọn oju-iwe GAM, SGAM, tabi PFS ṣe idiwọ awọn iṣayẹwo iyege ipin ninu awọn oju-iwe data ID 39 oju-iwe data lati (1: 0) si (1: 8087). Wo awọn aṣiṣe miiran fun idi.
CHECKDB wa awọn aṣiṣe ipin 1 ati awọn aṣiṣe aitasera 0 ti ko ni nkan ṣe pẹlu eyikeyi ohunkan.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 157) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 3, ID atọka 1, ID ipin 196608, ipin ipin ID 196608 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
CHECKDB wa awọn aṣiṣe ipin 1 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysrscols' (ohun ID 3).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 131) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 5, ID atọka 1, ID ipin 327680, ipin ipin ID 327680 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
CHECKDB wa awọn aṣiṣe ipin 1 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysrowsets' tabili (ID ohun 5).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 21) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 7, ID atọka 1, ID ipin 458752, ipin ipin ID 458752 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 18) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 7, ID atọka 2, ID ipin 562949953880064, ipin ipin ID 562949953880064 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
CHECKDB wa awọn aṣiṣe ipin 2 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysallocunits' (ID ohun 7).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 12) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 8, ID atọka 0, ID ipin 524288, ipin ipin ID 524288 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
CHECKDB wa awọn aṣiṣe ipin 1 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysfiles1' (ID ohun 8).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 137) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 20, ID atọka 1, ID ipin 281474978021376, ipin ipin ID 281474978021376 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
CHECKDB wa awọn aṣiṣe ipin 1 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysdbfiles '(ID ohun 20).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 152) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 23, ID atọka 1, ID ipin 281474978217984, ipin ipin ID 281474978217984 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
CHECKDB wa awọn aṣiṣe ipin 1 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysphfg' (ohun ID 23).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 154) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 24, ID atọka 1, ID ipin 281474978283520, ipin ipin ID 281474978283520 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
CHECKDB wa awọn aṣiṣe ipin 1 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysprufiles' (ohun ID 24).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 92) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 27, ID atọka 1, ID ipin 281474978480128, ipin ipin ID 281474978480128 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 288) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 27, ID atọka 2, ID ipin 562949955190784, ipin ipin ID 562949955190784 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 96) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 27, ID atọka 3, ID ipin 844424931901440, ipin ipin ID 844424931901440 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
CHECKDB wa awọn aṣiṣe ipin 3 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysowners' (ohun ID 27).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 102) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 29, ID atọka 1, ID ipin 281474978611200, ipin ipin ID 281474978611200 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
CHECKDB wa awọn aṣiṣe ipin 1 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysprivs' (ohun ID 29).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 117) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 34, ID atọka 1, ID ipin 281474978938880, ipin ipin ID 281474978938880 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 295) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 34, ID atọka 2, ID ipin 562949955649536, ipin ipin ID 562949955649536 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 368) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 34, ID atọka 3, ID ipin 844424932360192, ipin ipin ID 844424932360192 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 123) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 34, ID atọka 4, ID ipin 1125899909070848, ipin ipin ID 1125899909070848 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
CHECKDB wa awọn aṣiṣe ipin 4 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysschobjs' (ohun ID 34).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 108) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 41, ID atọka 1, ID ipin 281474979397632, ipin ipin ID 281474979397632 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 245) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 41, ID atọka 2, ID ipin 562949956108288, ipin ipin ID 562949956108288 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
CHECKDB wa awọn aṣiṣe ipin 2 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.syscolpars' (ID ohun 41).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 10) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 44, ID atọka 1, ID ipin 281474979594240, ipin ipin ID 281474979594240 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 286) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 44, ID atọka 2, ID ipin 562949956304896, ipin ipin ID 562949956304896 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
CHECKDB wa awọn aṣiṣe ipin 2 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysnsobjs' (ohun ID 44).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 76) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 50, ID atọka 1, ID ipin 281474979987456, ipin ipin ID 281474979987456 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 292) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 50, ID atọka 2, ID ipin 562949956698112, ipin ipin ID 562949956698112 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 294) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 50, ID atọka 3, ID ipin 844424933408768, ipin ipin ID 844424933408768 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
CHECKDB wa awọn aṣiṣe ipin 3 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysscalartypes' (ohun ID 50).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 125) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 54, ID atọka 1, ID ipin 281474980249600, ipin ipin ID 281474980249600 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 284) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 54, ID atọka 2, ID ipin 562949956960256, ipin ipin ID 562949956960256 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
CHECKDB wa awọn aṣiṣe ipin 2 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysidxstats' (ohun ID 54).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 141) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 55, ID atọka 1, ID ipin 281474980315136, ipin ipin ID 281474980315136 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 55) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 55, ID atọka 2, ID ipin 562949957025792, ipin ipin ID 562949957025792 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
CHECKDB wa awọn aṣiṣe ipin 2 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysiscols' (ohun ID 55).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 13) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 58, ID atọka 1, ID ipin 281474980511744, ipin ipin ID 72057594037993472 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 84) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 58, ID atọka 2, ID ipin 562949957222400, ipin ipin ID 72057594038059008 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
CHECKDB wa awọn aṣiṣe ipin 2 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysbinobjs' (ID ohun 58).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 129) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 60, ID atọka 1, ID ipin 281474980642816, ipin ipin ID 281474980642816 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Atọka (IAM) (1:45) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ohun ID 60, ID atọka atọka, ID ipin 1, pin ipin 281474980642816 71776119065149440 kuro (tẹ data LOB) , ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
CHECKDB wa awọn aṣiṣe ipin 2 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysobjvalues' (ID ohun 60).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 88) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 64, ID atọka 1, ID ipin 281474980904960, ipin ipin ID 281474980904960 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 243) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 64, ID atọka 2, ID ipin 562949957615616, ipin ipin ID 562949957615616 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
CHECKDB wa awọn aṣiṣe ipin 2 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysclsobjs' (ohun ID 64).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 15) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 69, ID atọka 1, ID ipin 281474981232640, ipin ipin ID 72057594039697408 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 39) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 69, ID atọka 2, ID ipin 562949957943296, ipin ipin ID 72057594039762944 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 290) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 69, ID atọka 3, ID ipin 844424934653952, ipin ipin ID 72057594039828480 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
CHECKDB wa awọn aṣiṣe ipin 3 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysrts' (ohun ID 69).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 98) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 74, ID atọka 1, ID ipin 281474981560320, ipin ipin ID 281474981560320 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 100) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 74, ID atọka 2, ID ipin 562949958270976, ipin ipin ID 562949958270976 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
CHECKDB wa awọn aṣiṣe ipin 2 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.syssingleobjrefs' (ID ohun 74).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 104) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 75, ID atọka 1, ID ipin 281474981625856, ipin ipin ID 281474981625856 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 106) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 75, ID atọka 2, ID ipin 562949958336512, ipin ipin ID 562949958336512 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
CHECKDB wa awọn aṣiṣe ipin 2 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysmultiobjrefs' (ID ohun 75).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 33) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 90, ID atọka 1, ID ipin 281474982608896, ipin ipin ID 72057594038583296 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 81) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 90, ID atọka 2, ID ipin 562949959319552, ipin ipin ID 72057594038648832 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
CHECKDB wa awọn aṣiṣe ipin 2 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysqnames' (ohun ID 90).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 49) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 91, ID atọka 1, ID ipin 281474982674432, ipin ipin ID 72057594038779904 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 35) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 91, ID atọka 2, ID ipin 562949959385088, ipin ipin ID 72057594038845440 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
CHECKDB wa awọn aṣiṣe ipin 2 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysxmlcomponent' (ID ohun 91).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 83) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 92, ID atọka 1, ID ipin 281474982739968, ipin ipin ID 72057594038976512 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
CHECKDB wa awọn aṣiṣe ipin 1 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysxmlfacet' (ID ohun 92).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 130) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 93, ID atọka 1, ID ipin 281474982805504, ipin ipin ID 72057594039107584 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 22) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 93, ID atọka 2, ID ipin 562949959516160, ipin ipin ID 72057594039173120 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
CHECKDB wa awọn aṣiṣe ipin 2 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysxmlplacement' (ID ohun 93).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 114) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 97, ID atọka 1, ID ipin 281474983067648, ipin ipin ID 72057594038190080 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 134) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 97, ID atọka 2, ID ipin 562949959778304, ipin ipin ID 72057594038255616 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
CHECKDB wa awọn aṣiṣe ipin 2 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysbinsubobjs' (ohun ID 97).
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
Msg 8939, Ipele 16, Ipinle 98, Laini 8
Aṣiṣe tabili: ID ohun 99, ID atọka 0, ID ipin 0, ipin ipin ID 6488064 (iru data ipin eto), oju-iwe (57311: 268369920). Idanwo (IS_OFF (BUF_IOERR, pBUF-> bstat)) kuna. Awọn iye jẹ 2057 ati -4.
CHECKDB wa awọn aṣiṣe ipin 5 ati awọn aṣiṣe aitasera 28 ninu tabili '(ID ohun 99)' (ID ohun 99).
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 120) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 245575913, ID atọka 0, ID ipin 72057594040549376, ipin ipin ID 72057594045792256 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Atọka (IAM) (1:118) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ohun ID 245575913, ID atọka atọka, ID ipin 0, pin ipin 72057594040549376 72057594045857792 kuro (tẹ data LOB) , ṣugbọn a ko rii ni ọlọjẹ naa.
Ko le tunṣe aṣiṣe yii ṣe.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 126) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 245575913, ID atọka 2, ID ipin 72057594040614912, ipin ipin ID 72057594045923328 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Titunṣe aṣiṣe yii nilo awọn aṣiṣe miiran lati tunṣe akọkọ.
CHECKDB wa awọn aṣiṣe ipin 3 ati awọn aṣiṣe aitasera 0 ninu tabili 'TestTable' (ID ohun 245575913).
CHECKDB wa awọn aṣiṣe ipin 58 ati awọn aṣiṣe aitasera 28 ninu ibi ipamọ data 'xxxx'.

ibiti 'xxxx' jẹ orukọ ti data MDF ibajẹ ti n ṣe atunṣe.

Eyi jẹ aṣiṣe ipin kan nitori awọn iṣoro wa pẹlu awọn oju-iwe IAM, ti o baamu Arabinrin 2575 aṣiṣe.

Iboju ti ifiranṣẹ aṣiṣe:

Kongẹ Apejuwe:

Awọn data inu faili MDF ti wa ni fipamọ bi awọn oju-iwe, oju-iwe kọọkan jẹ 8KB. Oju-iwe Atọka Iyatọ Atọka (IAM) ni a lo lati pin awọn oju-iwe ni Oluṣakoso MDF, wọn si sopọ mọ bi atokọ kan.

Ti aṣẹ DBCC CHECKDB ba wa akojọ ti o ni asopọ ti awọn oju-iwe IAM ko wulo ati pe ko le ṣe atunṣe iṣoro naa, lẹhinna yoo ṣe ijabọ aṣiṣe yii.

O le lo ọja wa DataNumen SQL Recovery lati gba data pada lati faili MDF ibajẹ ati yanju aṣiṣe yii.

Awọn faili Ayẹwo:

Ayẹwo ba awọn faili MDF ti yoo fa awọn Aṣiṣe Msg 2575:

SQL Server version Ibaje MDF faili MDF faili ti o wa titi nipasẹ DataNumen SQL Recovery
SQL Server 2014 Aṣiṣe2.mdf Aṣiṣe2_fixed.mdf

 

To jo:

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