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 5028, Izinga 16, State 4, Line 4
Isistimu yehlulekile ukusebenzisa i-database eyanele ukwakha kabusha i-log.
Imiphumela ye-DBCC ye- 'xxxx'.
I-CHECKDB ithole amaphutha wokwabiwa angama-0 namaphutha okungaguquguquki angama-0 ku-database 'xxxx'.
Msg 7909, Izinga 20, State 1, Line 4
Ukulungiswa kwemodi yezimo eziphuthumayo kwehlulekile.Kufanele ubuyise kusuka kusipele.

lapho 'i-xxxx' igama ledatha ekhohlakele ye-MDF elungiswa.

Msg 5028 iphutha akulona iphutha lokwabiwa noma iphutha lokuvumelana.

Nakuba Msg 7909 kuyiphutha elinzima elingavela ezimweni eziningi noma kunini SQL Server cabanga ukuthi i-database ayinakululama.

Isithombe-skrini somlayezo wephutha:

Incazelo eqondile:

Umlayezo wephutha (Msg 5028) kubonakala sengathi ihlobene nefayela le-LOG. Kodwa-ke, lokhu ukubikwa okungalungile. Inkinga yangempela isabangelwa ukonakala kwe-database ye-MDF.

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 5028 iphutha:

SQL Server Version Ifayela le-MDF elonakele Ifayela le-MDF lilungiswe ngu DataNumen SQL Recovery
SQL Server 2014 Iphutha3.mdf Iphutha3_fixed.mdf