Alamar:

Lokacin amfani Farashin DBCC tare da GYARA_ALLOW_DATA_LOSS siga don gyara m .MDF database, kamar wannan:

DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')

ka ga sakon kuskure mai zuwa:

Msg 8921, Level 16, Jihar 1, Layin 8
Duba kare. An gano gazawar yayin tattara gaskiya. Zai yiwu tempdb daga sararin samaniya ko teburin tsari bai dace ba. Duba kurakuran baya.
Msg 8998, Level 16, Jihar 2, Layin 8
Kuskuren shafi a kan shafukan GAM, SGAM, ko PFS suna hana ƙididdigar mutunci a cikin ID ID na 39 shafuka daga (1: 0) zuwa (1: 8087). Duba wasu kurakurai na dalilin.
CHECKDB ya sami kurakurai kasawa guda 1 da kuskuren daidaito 0 waɗanda ba a haɗa su da kowane abu guda ba.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 157) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 3, lambar ID 1, ID ɗin ɓoye 196608, rarraba ID ɗin 196608 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
CHECKDB ya sami kurakurai masu rarrabuwa 1 da kuskuren daidaito 0 a cikin teburin 'sys.sysrscols' (ID ID 3).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 131) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 5, lambar ID 1, ID ɗin ɓoye 327680, rarraba ID ɗin 327680 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
CHECKDB ya sami kurakurai kasawa guda 1 da kuskuren daidaito 0 a cikin teburin 'sys.sysrowsets' (ID ID 5).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 21) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 7, lambar ID 1, ID ɗin ɓoye 458752, rarraba ID ɗin 458752 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 18) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 7, lambar ID 2, ID ɗin ɓoye 562949953880064, rarraba ID ɗin 562949953880064 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
CHECKDB ya sami kurakurai kasafi 2 da kuskuren daidaito 0 a teburin 'sys.sysallocunits' (ID ID 7).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 12) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 8, lambar ID 0, ID ɗin ɓoye 524288, rarraba ID ɗin 524288 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
CHECKDB ya sami kurakurai kasawa guda 1 da kuskuren daidaito 0 a cikin tebur 'sys.sysfiles1' (abu ID 8).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 137) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 20, lambar ID 1, ID ɗin ɓoye 281474978021376, rarraba ID ɗin 281474978021376 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
CHECKDB ya sami kurakurai kasawa guda 1 da kuskuren daidaito 0 a cikin teburin 'sys.sysdbfiles '(abu ID 20).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 152) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 23, lambar ID 1, ID ɗin ɓoye 281474978217984, rarraba ID ɗin 281474978217984 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
CHECKDB ya sami kurakurai kasawa guda 1 da kuskuren daidaito 0 a cikin teburin 'sys.sysphfg' (ID ID 23).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 154) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 24, lambar ID 1, ID ɗin ɓoye 281474978283520, rarraba ID ɗin 281474978283520 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
CHECKDB ya sami kurakurai kasawa guda 1 da kuskuren daidaito 0 a teburin 'sys.sysprufiles' (ID ID 24).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 92) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 27, lambar ID 1, ID ɗin ɓoye 281474978480128, rarraba ID ɗin 281474978480128 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 288) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 27, lambar ID 2, ID ɗin ɓoye 562949955190784, rarraba ID ɗin 562949955190784 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 96) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 27, lambar ID 3, ID ɗin ɓoye 844424931901440, rarraba ID ɗin 844424931901440 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
CHECKDB ya sami kurakurai kasafi 3 da kuskuren daidaito 0 a teburin 'sys.sysowners' (ID ID 27).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 102) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 29, lambar ID 1, ID ɗin ɓoye 281474978611200, rarraba ID ɗin 281474978611200 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
CHECKDB ya sami kurakurai masu rarrabuwa 1 da kuskuren daidaito 0 a teburin 'sys.sysprivs' (abu ID 29).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 117) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 34, lambar ID 1, ID ɗin ɓoye 281474978938880, rarraba ID ɗin 281474978938880 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 295) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 34, lambar ID 2, ID ɗin ɓoye 562949955649536, rarraba ID ɗin 562949955649536 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 368) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 34, lambar ID 3, ID ɗin ɓoye 844424932360192, rarraba ID ɗin 844424932360192 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 123) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 34, lambar ID 4, ID ɗin ɓoye 1125899909070848, rarraba ID ɗin 1125899909070848 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
CHECKDB ya sami kurakurai kasafi 4 da kuskuren daidaito 0 a teburin 'sys.sysschobjs' (ID ID 34).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 108) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 41, lambar ID 1, ID ɗin ɓoye 281474979397632, rarraba ID ɗin 281474979397632 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 245) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 41, lambar ID 2, ID ɗin ɓoye 562949956108288, rarraba ID ɗin 562949956108288 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
CHECKDB ya sami kurakurai kasafi 2 da kuskuren daidaito 0 a teburin 'sys.syscolpars' (ID ID 41).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 10) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 44, lambar ID 1, ID ɗin ɓoye 281474979594240, rarraba ID ɗin 281474979594240 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 286) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 44, lambar ID 2, ID ɗin ɓoye 562949956304896, rarraba ID ɗin 562949956304896 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
CHECKDB ya sami kurakurai kasafi 2 da kuskuren daidaito 0 a teburin 'sys.sysnsobjs' (ID ID 44).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 76) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 50, lambar ID 1, ID ɗin ɓoye 281474979987456, rarraba ID ɗin 281474979987456 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 292) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 50, lambar ID 2, ID ɗin ɓoye 562949956698112, rarraba ID ɗin 562949956698112 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 294) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 50, lambar ID 3, ID ɗin ɓoye 844424933408768, rarraba ID ɗin 844424933408768 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
CHECKDB ya sami kurakurai kasafi 3 da kuskuren daidaito 0 a teburin 'sys.sysscalartypes' (ID ID 50).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 125) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 54, lambar ID 1, ID ɗin ɓoye 281474980249600, rarraba ID ɗin 281474980249600 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 284) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 54, lambar ID 2, ID ɗin ɓoye 562949956960256, rarraba ID ɗin 562949956960256 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
CHECKDB ya sami kurakurai kasafi 2 da kuskuren daidaito 0 a teburin 'sys.sysidxstats' (ID ID 54).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 141) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 55, lambar ID 1, ID ɗin ɓoye 281474980315136, rarraba ID ɗin 281474980315136 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 55) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 55, lambar ID 2, ID ɗin ɓoye 562949957025792, rarraba ID ɗin 562949957025792 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
CHECKDB ya sami kurakurai kasafi 2 da kuskuren daidaito 0 a cikin teburin 'sys.sysiscols' (ID ID 55).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 13) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 58, lambar ID 1, ID ɗin ɓoye 281474980511744, rarraba ID ɗin 72057594037993472 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 84) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 58, lambar ID 2, ID ɗin ɓoye 562949957222400, rarraba ID ɗin 72057594038059008 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
CHECKDB ya sami kurakurai kasafi 2 da kuskuren daidaito 0 a teburin 'sys.sysbinobjs' (ID ID 58).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 129) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 60, lambar ID 1, ID ɗin ɓoye 281474980642816, rarraba ID ɗin 281474980642816 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
Msg 2575, Level 16, Jihar 1, Layin 8
Shafin Kayyadadden Fihirisar (IAM) shafi na (1:45) ana nuna shi ta hanyar mai nuna shafin IAM na gaba (0: 0) a cikin ID ID 60, lambar ID 1, ID mai rarraba 281474980642816, ware ID na 71776119065149440 (rubuta bayanan LOB) , amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
CHECKDB ya sami kurakurai kasafi 2 da kuskuren daidaito 0 a teburin 'sys.sysobjvalues' (ID ID 60).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 88) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 64, lambar ID 1, ID ɗin ɓoye 281474980904960, rarraba ID ɗin 281474980904960 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 243) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 64, lambar ID 2, ID ɗin ɓoye 562949957615616, rarraba ID ɗin 562949957615616 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
CHECKDB ya sami kurakurai kasafi 2 da kuskuren daidaito 0 a teburin 'sys.sysclsobjs' (abu ID 64).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 15) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 69, lambar ID 1, ID ɗin ɓoye 281474981232640, rarraba ID ɗin 72057594039697408 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 39) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 69, lambar ID 2, ID ɗin ɓoye 562949957943296, rarraba ID ɗin 72057594039762944 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 290) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 69, lambar ID 3, ID ɗin ɓoye 844424934653952, rarraba ID ɗin 72057594039828480 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
CHECKDB ya sami kurakurai kasafi 3 da kuskuren daidaito 0 a cikin teburin 'sys.sysrts' (abu ID 69).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 98) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 74, lambar ID 1, ID ɗin ɓoye 281474981560320, rarraba ID ɗin 281474981560320 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 100) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 74, lambar ID 2, ID ɗin ɓoye 562949958270976, rarraba ID ɗin 562949958270976 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
CHECKDB ya sami kurakurai kasafi 2 da kuskuren daidaito 0 a teburin 'sys.syssingleobjrefs' (ID ID 74).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 104) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 75, lambar ID 1, ID ɗin ɓoye 281474981625856, rarraba ID ɗin 281474981625856 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 106) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 75, lambar ID 2, ID ɗin ɓoye 562949958336512, rarraba ID ɗin 562949958336512 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
CHECKDB ya sami kurakurai kasafi 2 da kuskuren daidaito 0 a teburin 'sys.sysmultiobjrefs' (ID ID 75).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 33) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 90, lambar ID 1, ID ɗin ɓoye 281474982608896, rarraba ID ɗin 72057594038583296 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 81) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 90, lambar ID 2, ID ɗin ɓoye 562949959319552, rarraba ID ɗin 72057594038648832 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
CHECKDB ya sami kurakurai kasafi 2 da kuskuren daidaito 0 a cikin teburin 'sys.sysqnames' (ID ID 90).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 49) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 91, lambar ID 1, ID ɗin ɓoye 281474982674432, rarraba ID ɗin 72057594038779904 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 35) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 91, lambar ID 2, ID ɗin ɓoye 562949959385088, rarraba ID ɗin 72057594038845440 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
CHECKDB ya sami kurakurai kasafi 2 da kuskuren daidaito 0 a tebur 'sys.sysxmlcomponent' (abu ID 91).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 83) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 92, lambar ID 1, ID ɗin ɓoye 281474982739968, rarraba ID ɗin 72057594038976512 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
CHECKDB ya sami kurakurai kasawa guda 1 da kuskuren daidaito 0 a cikin teburin 'sys.sysxmlfacet' (ID ID 92).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 130) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 93, lambar ID 1, ID ɗin ɓoye 281474982805504, rarraba ID ɗin 72057594039107584 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 22) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 93, lambar ID 2, ID ɗin ɓoye 562949959516160, rarraba ID ɗin 72057594039173120 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
CHECKDB ya sami kurakurai kasafi 2 da kuskuren daidaito 0 a teburin 'sys.sysxmlplacement' (abu ID 93).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 114) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 97, lambar ID 1, ID ɗin ɓoye 281474983067648, rarraba ID ɗin 72057594038190080 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 134) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 97, lambar ID 2, ID ɗin ɓoye 562949959778304, rarraba ID ɗin 72057594038255616 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
CHECKDB ya sami kurakurai kasafi 2 da kuskuren daidaito 0 a teburin 'sys.sysbinsubobjs' (abu ID 97).
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
An kasa gyara wannan kuskuren.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
An kasa gyara wannan kuskuren.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
An kasa gyara wannan kuskuren.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
An kasa gyara wannan kuskuren.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
An kasa gyara wannan kuskuren.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
Msg 8939, Level 16, Jihar 98, Layin 8
Kuskuren tebur: ID na ID na ID, ID na ID 99, lambar ID 0, rabe ID ID 0 (nau'in bayanan tsarin tsarin), shafi (6488064: 57311) Gwaji (IS_OFF (BUF_IOERR, pBUF-> bstat)) bai yi nasara ba. Areididdiga sune 268369920 da -2057.
CHECKDB ya sami kurakurai kasafi guda 5 da kuskuren daidaito 28 a cikin tebur '(Object ID 99)' (ID ID 99).
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 120) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 245575913, lambar ID 0, ID ɗin ɓoye 72057594040549376, rarraba ID ɗin 72057594045792256 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
Msg 2575, Level 16, Jihar 1, Layin 8
Shafin Kayyadadden Fihirisar (IAM) shafi na (1:118) ana nuna shi ta hanyar mai nuna shafin IAM na gaba (0: 0) a cikin ID ID 245575913, lambar ID 0, ID mai rarraba 72057594040549376, ware ID na 72057594045857792 (rubuta bayanan LOB) , amma ba a gano shi cikin sikanin ba.
An kasa gyara wannan kuskuren.
Msg 2575, Level 16, Jihar 1, Layin 8
Taswirar Rarraba Fihirisar (IAM) shafi na (1: 126) ana nuna shi ta gaba mai nuna shafin IAM (0: 0) a cikin ID ID na abu 245575913, lambar ID 2, ID ɗin ɓoye 72057594040614912, rarraba ID ɗin 72057594045923328 (rubuta In-jere data), amma ba a gano shi cikin sikanin ba.
Gyara wannan kuskuren yana buƙatar gyara wasu kuskuren da farko.
CHECKDB ya sami kurakurai kasafi 3 da kuskuren daidaito 0 a cikin teburin 'TestTable' (ID ID 245575913).
CHECKDB ya sami kurakurai kasafi 58 da kuskuren daidaito 28 a cikin bayanan 'xxxx'.

inda 'xxxx' sunan sunan MDF gurbatacce da ake gyarawa.

Wannan kuskuren kasafi ne tunda akwai matsaloli tare da shafukan IAM, daidai da Farashin 2575 kuskure.

Hoton kuskuren hoto:

Daidaitaccen Bayani:

Ana adana bayanai a cikin fayil na MDF azaman shafuka, kowane shafi yana 8KB. Ana amfani da Taswirar Rarraba Fihirisar (IAM) don kasafta shafuka a cikin MDF Fayil, kuma an haɗa su azaman jerin.

Idan umurnin DBCC CHECKDB ya sami jerin alamomin shafukan IAM ba su da inganci kuma ba zai iya gyara matsalar ba, to zai kai rahoton wannan kuskuren.

Zaka iya amfani da samfurinmu DataNumen SQL Recovery don dawo da bayanan daga fayil ɗin MDF mai lalata kuma warware wannan kuskuren.

Samfurin fayiloli:

Samfurin gurbatattun fayilolin MDF wanda zai haifar da Kuskuren Msg 2575:

SQL Server version Gurbataccen MDF fayil Fayil MDF ta gyara DataNumen SQL Recovery
SQL Server 2014 Kuskure2.mdf Kuskuren2_fixed.mdf

 

References:

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