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.
Idatha ye-5028 iphutha akulona iphutha lokwabiwa noma iphutha lokuvumelana.
Ngenkathi Idatha ye-7909 kuyiphutha elinzima elingavela ezimweni eziningi noma kunini SQL Server cabanga ukuthi i-database ayinakululama.
Isithombe-skrini somlayezo wephutha:
Incazelo eqondile:
Umlayezo wephutha (Idatha ye-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 Idatha ye-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 |