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 (Msg 824) ku-database.

Isithombe-skrini somlayezo wephutha:

Iphutha le-I / O elisuselwa ekuqondeni okunengqondo: i-checksum engalungile

Uma inkohlakalo inzima, khona-ke kuzoba nemiyalezo yamaphutha eqhubekayo (Msg 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 Msg 7909 kulandela Msg 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 Msg 7909 kuyiphutha elinzima elingavela ezimweni eziningi noma kunini SQL Server cabanga ukuthi i-database ayinakululama.

Isithombe-skrini somlayezo wephutha:

Kungenalutho

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 (Msg 824). Uma i-corrupton inzima, kungahle kube nezinkinga eziqhubekayo (Msg 824) noma ilandelwe elinye iphutha (Msg 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

 

References:

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