Uphawu:
Lapho usebenzisa I-DBCC CHECKDB nge LUNGISA_ALLOW_DATA_LOSS ipharamitha ukulungisa i-database eyonakele ye-MDD, enjengale:
I-DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')
ubona umlayezo wephutha olandelayo:
Imiphumela ye-DBCC ye- 'xxxx'.
I-CHECKDB ithole amaphutha wokwabiwa angama-0 namaphutha okungaguquguquki angama-0 ku-database 'xxxx'.
Msg 824, Izinga 24, State 2, Line 8
SQL Server ithole iphutha elinengqondo lokuvumelana ngokuhambisana ne-I / O: i-checksum engalungile (kulindeleke: 0xea8a9a2f; uqobo: 0x37adbff8). Kwenzeke ngesikhathi kufundwa ikhasi (1:28) ku-ID 39 egciniwe nge-offset 0x00000000038000 kufayela elithi 'xxxx.mdf'. Imilayezo eyengeziwe kufayela le- SQL Server irekhodi lephutha noma irekhodi lomcimbi wohlelo lingahlinzeka ngemininingwane eminingi. Lesi yisimo sephutha esibi esisongela ubuqotho besizinda semininingwane futhi kufanele silungiswe ngokushesha. Gcwalisa isheke eligcwele lokungaguquguquki kwe-database (DBCC CHECKDB). Leli phutha lingadalwa yizinto eziningi; ukuthola eminye imininingwane, bheka SQL Server Izincwadi eziku-inthanethi.
lapho 'i-xxxx.mdf' igama lefayela le-MDF elonakele elilungiswayo. Yize u-CHECKDB esho
I-CHECKDB ithole amaphutha wokwabiwa angama-0 namaphutha okungaguquguquki angama-0 ku-database 'xxxx'.
Leli kuseyiphutha lokuvumelana (Idatha ye-824) ku-database.
Isithombe-skrini somlayezo wephutha:
Uma inkohlakalo inzima, khona-ke kuzoba nemiyalezo yamaphutha eqhubekayo (Idatha ye-824), njengoba ngezansi:
Msg 824, Izinga 24, State 6, Line 2 SQL Server ithole iphutha elinengqondo lokuvumelana ngokuya kwe-I / O: i-checksum engalungile (kulindeleke: 0x3d17dfef; uqobo: 0xd81748ef). Kwenzeke ngesikhathi kufundwa ikhasi (1: 0) ku-ID 39 egciniwe nge-offset 0000000000000000 kufayela elithi 'xxxx.mdf'. Imilayezo eyengeziwe kufayela le- SQL Server irekhodi lephutha noma irekhodi lomcimbi wohlelo lingahlinzeka ngemininingwane eminingi. Lesi yisimo sephutha esibi esisongela ubuqotho besizinda semininingwane futhi kufanele silungiswe ngokushesha. Gcwalisa isheke eligcwele lokungaguquguquki kwe-database (DBCC CHECKDB). Leli phutha lingadalwa yizinto eziningi; ukuthola eminye imininingwane, bheka SQL Server Izincwadi eziku-inthanethi.
Msg 824, Izinga 24, State 6, Line 4 SQL Server ithole iphutha elinengqondo lokuvumelana ngokuya kwe-I / O: i-checksum engalungile (kulindeleke: 0x3d17dfef; uqobo: 0xd81748ef). Kwenzeke ngesikhathi kufundwa ikhasi (1: 0) ku-ID 39 egciniwe nge-offset 0000000000000000 kufayela elithi 'xxxx.mdf'. Imilayezo eyengeziwe kufayela le- SQL Server irekhodi lephutha noma irekhodi lomcimbi wohlelo lingahlinzeka ngemininingwane eminingi. Lesi yisimo sephutha esibi esisongela ubuqotho besizinda semininingwane futhi kufanele silungiswe ngokushesha. Gcwalisa isheke eligcwele lokungaguquguquki kwe-database (DBCC CHECKDB). Leli phutha lingadalwa yizinto eziningi; ukuthola eminye imininingwane, bheka SQL Server Izincwadi eziku-inthanethi.
lapho 'i-xxxx.mdf' igama lefayela le-MDF elonakele elilungiswayo.
Isithombe-skrini somlayezo wephutha:
Uma inkohlakalo inzima kakhulu, uzobona Idatha ye-7909 kulandela Idatha ye-824:
Imiphumela ye-DBCC ye- 'xxxx'.
I-CHECKDB ithole amaphutha wokwabiwa angama-0 namaphutha okungaguquguquki angama-0 ku-database 'xxxx'.
Msg 824, Izinga 24, State 2, Line 8
SQL Server ithole iphutha elinengqondo lokuvumelana ngokuya kwe-I / O: i-checksum engalungile (kulindeleke: 0xcfcd2118; uqobo: 0x6fc599d6). Kwenzeke ngesikhathi kufundwa ikhasi (1: 1) ku-ID 39 egciniwe nge-offset 0x00000000002000 kufayela elithi 'xxxx.mdf'. Imilayezo eyengeziwe kufayela le- SQL Server irekhodi lephutha noma irekhodi lomcimbi wohlelo lingahlinzeka ngemininingwane eminingi. Lesi yisimo sephutha esibi esisongela ubuqotho besizinda semininingwane futhi kufanele silungiswe ngokushesha. Gcwalisa isheke eligcwele lokungaguquguquki kwe-database (DBCC CHECKDB). Leli phutha lingadalwa yizinto eziningi; ukuthola eminye imininingwane, bheka SQL Server Izincwadi eziku-inthanethi.
Msg 7909, Izinga 20, State 1, Line 8
Ukulungiswa kwemodi yezimo eziphuthumayo kwehlulekile.Kufanele ubuyise kusuka kusipele.
lapho 'i-xxxx' igama ledatha futhi 'i-xxxx.mdf' igama lefayela ledatha elibonakalayo.
Note Idatha ye-7909 kuyiphutha elinzima elingavela ezimweni eziningi noma kunini SQL Server cabanga ukuthi i-database ayinakululama.
Isithombe-skrini somlayezo wephutha:
Incazelo eqondile:
Imininingwane efayeleni le-MDF igcinwa njenge-8KB amakhasi. Ikhasi ngalinye linenkambu ye-checksum yokuzikhethela.
Uma umyalo we-DBCC CHECKDB uthola amanani we-checksum ekhasini leheda, ikhasi le-PFS namanye amakhasi wedatha awavumelekile futhi ayikwazi ukulungisa inkinga, lapho-ke izobika leli phutha (Idatha ye-824). Uma i-corrupton inzima, kungahle kube nezinkinga eziqhubekayo (Idatha ye-824) noma ilandelwe elinye iphutha (Idatha ye-7909).
Ungasebenzisa umkhiqizo wethu DataNumen SQL Recovery ukubuyisa idatha kusuka kufayela le-MDF elonakele bese uxazulula leli phutha.
Amafayela Esampula:
Isampula amafayela we-MDF akhohlakele azodala iphutha (Iphutha elilodwa le-Msg 824):
SQL Server Version | Ifayela le-MDF elonakele | Ifayela le-MDF lilungiswe ngu DataNumen SQL Recovery |
SQL Server 2014 | Iphutha1_3.mdf | Iphutha1_3_fixed.mdf |
Isampula amafayela we-MDF akhohlakele azodala iphutha (Amaphutha we-Msg 824 aqhubekayo):
SQL Server Version | Ifayela le-MDF elonakele | Ifayela le-MDF lilungiswe ngu DataNumen SQL Recovery |
SQL Server 2014 | Iphutha1_1.mdf | Iphutha1_1_okulungiswa.mdf |
Isampula amafayela we-MDF akhohlakele azodala iphutha (Iphutha le-Msg 824 lilandelwa iphutha le-Msg 7909):
SQL Server Version | Ifayela le-MDF elonakele | Ifayela le-MDF lilungiswe ngu DataNumen SQL Recovery |
SQL Server 2014 | Iphutha1_2.mdf | Iphutha1_2_fixed.mdf |