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 5125, Izinga 24, State 2, Line 2
Ifayela 'C: Amafayela OhleloMicrosoft SQL ServerI-MSSQL12.SQL2014MSSQLDATAError1.mdf 'kubonakala sengathi inqunywe uhlelo lokusebenza. Usayizi olindelwe ngu-5120 KB kepha usayizi wangempela ngu-5112 KB.
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.
lapho i-'Error1 'igama le-database ekhohlakele ye-MDF elungiswa.
Idatha ye-5125 iphutha liseduze nephutha lokwabiwa noma iphutha lokuvumelana. Kwenzeka lapho ingxenye yomsila wefayela le-MDB isuswa, ngenxa yenkohlakalo yedatha.
Isithombe-skrini somlayezo wephutha:
Incazelo eqondile:
Lapho ingxenye yomsila wefayela le-MDB isuswa, I-CHECKDB izobika Idatha ye-5125 iphutha bese uzama ukukulungisa. Uma i-database ingenakulungiswa, khona-ke izokhiqiza Idatha ye-3414 iphutha.
Empeleni i-database nayo ingatholwa, uma usebenzisa umkhiqizo wethu DataNumen SQL Recovery ukwenza lo msebenzi.
Amafayela Esampula:
SQL Server Version | Ifayela le-MDF elonakele | Ifayela le-MDF lilungiswe ngu DataNumen SQL Recovery |
SQL Server 2014 | Iphutha8.mdf | Iphutha8_okulungiswa.mdf |
References: