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:
Msg 824, Heerka 24, State 2, Line 2
SQL Server ogaadey qalad I / O ah oo iswaafaqsan oo macquul ah: bogag qaldan (filasho 1: 143; dhab 0: 9). Waxay dhacday intii lagu guda jiray akhrinta bogga (1: 143) ee keydka xogta ee ID 39 oo laga jaray 0x0000000011e000 feyl 'C: Barnaamijka FaylashaMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.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 3313, Heerka 21, State 1, Line 2
Intii lagu gudajiray dib udajinta hawlgal diiwaan gashan 'Error1', qalad ayaa kadhacay diiwaanka diiwaanka aqoonsiga (135: 752: 2). Caadi ahaan, guuldarada khaaska ah horey ayaa loogu diiwaangeliyey inay tahay qalad adeegga Windows Event Log. Ka soo celi keydka keydka keyd buuxa, ama dayactir xogta.
Msg 3414, Heerka 21, State 1, Line 2
Khalad ayaa dhacay intii lagu jiray soo kabashada, taasoo ka hortageysay keydka 'Error1' (39: 0) restarxoqid Baadhitaan ku samee khaladaadka soo-kabashada oo hagaaji, ama ka soo celi kayd wanaagsan oo la yaqaan. Haddii khaladaadka aan la sixi ama la filayo, la xiriir Taageerada Farsamada.
Msg 824, Heerka 24, State 2, Line 2
SQL Server ogaadey qalad I / O ah oo iswaafaqsan oo macquul ah: bogag qaldan (lafilayo 1: 160; dhabta 0: 41). Waxay dhacday intii lagu guda jiray akhrinta bogga (1: 160) ee keydka xogta ID 39 oo laga jaray 0x00000000140000 feyl 'C: Barnaamijka Faylasha SQL ServerMSSQL12.SQL2014MSSQLDATAError1.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 2, Line 4
SQL Server ogaadey qalad I / O ah oo iswaafaqsan oo macquul ah: bogag qaldan (lafilayo 1: 160; dhabta 0: 41). Waxay dhacday intii lagu guda jiray akhrinta bogga (1: 160) ee keydka xogta ID 39 oo laga jaray 0x00000000140000 feyl 'C: Barnaamijka Faylasha SQL ServerMSSQL12.SQL2014MSSQLDATAError1.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.
meesha 'Error1' uu yahay magaca kaydinta xogta MDF ee musuqmaasuqa ah.
Tusmada 3313 waxay muujineysaa in hawl gal aan la sameyn karin.
Screenshot of message qalad:
Sharaxaad qeexan:
Marka CHECKDB aysan fulin karin waxqabad, waxay soo sheegi doontaa farriinta qaladka Tusmada 3313 iskuna day inaad saxdo khaladaadka. Haddii aysan hagaajin karin qaladka, markaa dib u soo kabashada ayaa fashilantay waxayna u horseedi doontaa khaladaad badan, sida Msg 3414 iyo Msg 824.
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 Tusmada 3313 baadi:
| SQL Server version | Faylka MDF musuqmaasuq | Faylka MDF waxaa hagaajiyay DataNumen SQL Recovery |
| SQL Server 2014 | Khalad9.mdf | Khalad9_fixed.mdf |