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.

Msg 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 Msg 5125 iphutha bese uzama ukukulungisa. Uma i-database ingenakulungiswa, khona-ke izokhiqiza Msg 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: