Astaamaha:
Markii la isticmaalayo DBCC CHECKDB la REPAIR_ALLOW_DATA_LOSS halbeegga si loo hagaajiyo kaydinta xogta .MDF, sida tan:
DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')
waxaad aragtaa farriinta khaladka soo socda:
Natiijooyinka DBCC ee 'xxxx'.
CHECKDB waxay heshay 0 khaladaad qoondeyn ah iyo 0 qaladaad joogto ah oo kujira keydka 'xxxx'.
Msg 824, Heerka 24, State 2, Line 8
SQL Server ogaadey qalad I / O ah oo iswaafaqsan oo macquul ah: jeeg khaldan (lafilayo: 0xea8a9a2f; dhab ah: 0x37adbff8) Waxay dhacday inta lagu gudajiray akhrinta bogga (1: 28) ee keydka xogta ID 39 marka laga jajabayo 0x00000000038000 feyl 'xxxx.mdf'. Fariimo dheeri ah oo kujira SQL Server log log ama nidaamka dhacdo log ayaa laga yaabaa inay bixiso faahfaahin dheeraad ah. Tani waa xaalad qalad aad u daran oo khatar ku ah sharafta macluumaadka waana in si dhakhso leh loo saxaa. Dhameystir jeeg isugeynta keydka xogta oo dhameystiran (DBCC CHECKDB). Khaladkan waxaa sababi kara arrimo badan; wixii macluumaad dheeraad ah, eeg SQL Server Buugaagta khadka tooska ah.
halka 'xxxx.mdf' uu yahay magaca faylka MDF ee musuqmaasuqa ah ee la hagaajinayo. Inkastoo CHECKDB uu leeyahay
CHECKDB waxay heshay 0 khaladaad qoondeyn ah iyo 0 qaladaad joogto ah oo kujira keydka 'xxxx'.
Tani wali waa qalad joogto ah (Tusmada 824) keydka macluumaadka.
Screenshot of message qalad:
Haddii musuqmaasuqu aad u daran yahay, markaa waxaa jiri doona farriimo qalad joogto ah (Tusmada 824), sida hoos ku xusan:
Msg 824, Heerka 24, State 6, Line 2 SQL Server la ogaaday qaladka I / O ee ku saleysan macquulnimada: jeeg aan sax ahayn (la filayo: 0x3d17dfef; dhab ah: 0xd81748ef). Waxay dhacday intii lagu guda jiray akhrinta bogga (1: 0) ee keydka xogta ee ID 39 marka laga jajabayo 0000000000000000 ee faylka 'xxxx.mdf'. Fariimo dheeri ah oo kujira SQL Server log log ama nidaamka dhacdo log ayaa laga yaabaa inay bixiso faahfaahin dheeraad ah. Tani waa xaalad qalad aad u daran oo khatar ku ah sharafta macluumaadka waana in si dhakhso leh loo saxaa. Dhameystir jeeg isugeynta keydka xogta oo dhameystiran (DBCC CHECKDB). Khaladkan waxaa sababi kara arrimo badan; wixii macluumaad dheeraad ah, eeg SQL Server Buugaagta khadka tooska ah.
Msg 824, Heerka 24, State 6, Line 4 SQL Server la ogaaday qaladka I / O ee ku saleysan macquulnimada: jeeg aan sax ahayn (la filayo: 0x3d17dfef; dhab ah: 0xd81748ef). Waxay dhacday intii lagu guda jiray akhrinta bogga (1: 0) ee keydka xogta ee ID 39 marka laga jajabayo 0000000000000000 ee faylka 'xxxx.mdf'. Fariimo dheeri ah oo kujira SQL Server log log ama nidaamka dhacdo log ayaa laga yaabaa inay bixiso faahfaahin dheeraad ah. Tani waa xaalad qalad aad u daran oo khatar ku ah sharafta macluumaadka waana in si dhakhso leh loo saxaa. Dhameystir jeeg isugeynta keydka xogta oo dhameystiran (DBCC CHECKDB). Khaladkan waxaa sababi kara arrimo badan; wixii macluumaad dheeraad ah, eeg SQL Server Buugaagta khadka tooska ah.
halka 'xxxx.mdf' uu yahay magaca faylka MDF ee musuqmaasuqa ah ee la hagaajinayo.
Screenshot of message qalad:
Haddii musuqmaasuqu ka sii daran yahay, waad arki kartaa Tusmada 7909 raacaya Tusmada 824:
Natiijooyinka DBCC ee 'xxxx'.
CHECKDB waxay heshay 0 khaladaad qoondeyn ah iyo 0 qaladaad joogto ah oo kujira keydka 'xxxx'.
Msg 824, Heerka 24, State 2, Line 8
SQL Server la ogaaday qaladka I / O ee ku saleysan macquulnimada: jeeg aan sax ahayn (la filayo: 0xcfcd2118; dhab ah: 0x6fc599d6). Waxay dhacday intii lagu guda jiray akhrinta bogga (1: 1) ee keydka aqoonsiga ee 'ID 39' oo laga jaray 0x00000000002000 feyl 'xxxx.mdf'. Fariimo dheeri ah oo kujira SQL Server log log ama nidaamka dhacdo log ayaa laga yaabaa inay bixiso faahfaahin dheeraad ah. Tani waa xaalad qalad aad u daran oo khatar ku ah sharafta macluumaadka waana in si dhakhso leh loo saxaa. Dhameystir jeeg isugeynta keydka xogta oo dhameystiran (DBCC CHECKDB). Khaladkan waxaa sababi kara arrimo badan; wixii macluumaad dheeraad ah, eeg SQL Server Buugaagta khadka tooska ah.
Msg 7909, Heerka 20, State 1, Line 8
Dayactirka qaabka-deg-degga ah wuu fashilmay. Waa inaad ka soo kabsataa kaydinta.
halka 'xxxx' uu yahay magaca keydka xogta 'xxxx.mdf' waa magaca faylka faylka loo adeegsado.
note Tusmada 7909 waa qalad aad u daran oo dhici kara xaalado badan markasta SQL Server u maleynayaa in keydku uu ka baxsan yahay soo kabashada.
Screenshot of message qalad:
Sharaxaad qeexan:
Xogta ku jirta faylka MDF waxaa lagu kaydiyaa 8KB pages. Bog kasta wuxuu leeyahay goob jeeg ah oo ikhtiyaari ah.
Haddii amarka DBCC CHECKDB uu ka helo qiimeynta jeegagga bogga cinwaanka, bogga PFS iyo qaar ka mid ah bogagga xogtu ay yihiin kuwo aan ansax ahayn oo aan sixi karin dhibaatada, markaa waxay soo sheegi doontaa qaladkanTusmada 824). Haddii musuqmaasuqu aad u daran yahay, waxaa jiri kara khayaano joogto ah (Tusmada 824) ama uu ku xigo qalad kale (Tusmada 7909).
Waxaad isticmaali kartaa badeecadeena DataNumen SQL Recovery si looga soo kiciyo xogta faylka MDF musuqmaasuqa ah loona xalliyo qaladkan.
Muunado Faylal:
Muunad faylalka MDF musuqmaasuq ah oo sababi doona qaladka (Khaladka Msg 824):
| SQL Server version | Faylka MDF musuqmaasuq | Faylka MDF waxaa hagaajiyay DataNumen SQL Recovery |
| SQL Server 2014 | Khalad1_3.mdf | Khalad1_3_fixed.mdf |
Muunad faylalka MDF musuqmaasuq ah oo sababi doona qaladka (Khaladaadka joogtada ah ee Msg 824):
| SQL Server version | Faylka MDF musuqmaasuq | Faylka MDF waxaa hagaajiyay DataNumen SQL Recovery |
| SQL Server 2014 | Khalad1_1.mdf | Cilad1_1_waxaa.mdf |
Muunad faylalka MDF musuqmaasuq ah oo sababi doona qaladka (Msg 824 qalad waxaa ku xigay Msg 7909 qalad):
| SQL Server version | Faylka MDF musuqmaasuq | Faylka MDF waxaa hagaajiyay DataNumen SQL Recovery |
| SQL Server 2014 | Khalad1_2.mdf | Khalad1_2_fixed.mdf |