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:

Msg 824, Izinga 24, State 2, Line 2
SQL Server ithole iphutha elinengqondo lokuvumelana ngokuya kwe-I / O: i-pageid engalungile (kulindeleke 1: 143; uqobo lwama-0: 9). Kwenzeke ngesikhathi kufundwa ikhasi (1: 143) kwi-database ID 39 kusethi 0x0000000011e000 kufayela 'C: Program FilesMicrosoft SQL ServerI-MSSQL12.SQL2014MSSQLDATAError1.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 3313, Izinga 21, State 1, Line 2
Ngesikhathi kwenziwa kabusha umsebenzi ongene ngemvume ku-database 'Error1', kwenzeke iphutha ku-ID irekhodi le-log (135: 752: 2). Imvamisa, ukwehluleka okuthile kufakwe ngemvume njengephutha kusevisi ye-Windows Event Log. Buyisela i-database kusuka kusipele esigcwele, noma lungisa i-database.
Msg 3414, Izinga 21, State 1, Line 2
Kuvele iphutha ngesikhathi sokululama, ukuvimbela i-database ethi 'Error1' (39: 0) kusuka ku-restarting. Thola amaphutha wokutakula bese uwalungisa, noma ubuyise kusuka kusipele esihle esaziwayo. Uma amaphutha engalungiswa noma engalindelekile, thintana nabakwa-technical Support.
Msg 824, Izinga 24, State 2, Line 2
SQL Server ithole iphutha elinengqondo lokuvumelana ngokuya kwe-I / O: i-pageid engalungile (kulindeleke u-1: 160; uqobo ongu-0: 41). Kwenzeke ngesikhathi kufundwa ikhasi (1: 160) kwi-database ID 39 kusethi 0x00000000140000 kufayela 'C: Program FilesMicrosoft SQL ServerI-MSSQL12.SQL2014MSSQLDATAError1.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 2, Line 4
SQL Server ithole iphutha elinengqondo lokuvumelana ngokuya kwe-I / O: i-pageid engalungile (kulindeleke u-1: 160; uqobo ongu-0: 41). Kwenzeke ngesikhathi kufundwa ikhasi (1: 160) kwi-database ID 39 kusethi 0x00000000140000 kufayela 'C: Program FilesMicrosoft SQL ServerI-MSSQL12.SQL2014MSSQLDATAError1.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-'Error1 'igama le-database ekhohlakele ye-MDF elungiswa.

Msg 3313 kukhombisa ukusebenza kwelogi okungenziwa.

Isithombe-skrini somlayezo wephutha:

Incazelo eqondile:

Lapho i-CHECKDB ingakwazi ukusebenza ngokungena ngemvume, izobika umyalezo wephutha Msg 3313 bese uzama ukulungisa amaphutha. Uma ingakwazi ukulungisa iphutha, khona-ke ukutakula kwehluleka futhi kuzoholela emaphutheni amaningi, njenge UMsg 3414 noMsg 824.

Ungasebenzisa umkhiqizo wethu DataNumen SQL Recovery ukubuyisa idatha kusuka kufayela le-MDF elonakele bese uxazulula leli phutha.

Amafayela Esampula:

Sampula amafayela we-MDF akhohlakele azobangela Msg 3313 iphutha:

SQL Server Version Ifayela le-MDF elonakele Ifayela le-MDF lilungiswe ngu DataNumen SQL Recovery
SQL Server 2014 Iphutha9.mdf Iphutha9_fixed.mdf

References: