Cov tsos mob:
Thaum siv DBCC CHECKDB nrog REPAIR_ALLOW_DATA_LOS parameter los kho qhov tsis ncaj .MDF database, zoo li no:
DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')
koj pom cov lus yuam kev li hauv qab no:
Msg 5125, Qib 24, 2 Xeev, Kab 2
Cov Ntaub Ntawv 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf 'zoo li tau raug txiav los ntawm lub operating system. Xav pom qhov loj me yog 5120 KB tab sis qhov loj me yog 5112 KB.
Msg 3414, Qib 21, 1 Xeev, Kab 2
Ib qho yuam kev tshwm sim thaum rov qab los, tiv thaiv cov ntaub ntawv 'Error1' (39: 0) ntawm restarting. Kuaj qhov rov ua yuam kev thiab kho lawv, lossis rov qab los ntawm cov thaub qab zoo. Yog tias qhov uas tsis raug kho tsis raug lossis xav kom ua tiav, hu rau Cov Neeg Pab Txhawb.
qhov twg 'Error1' yog lub npe ntawm tus tsis ncaj MDF database tau raug kho.
Wb 5125 kev ua yuam kev yog neigher kev faib yuam kev tsis yog ib tug yuam kev xwm txheej. Nws tshwm sim thaum ntu ib feem ntawm tus Tsov tus tw ntawm MDB cov ntaub ntawv tshem tawm, vim cov ntaub ntawv kev noj nyiaj txiag.
Screenshot ntawm cov lus yuam:
Nqe Lus Qhia Tshwj Xeeb:
Thaum ntu ntawm tus Tsov tus tw ntawm MDB cov ntaub ntawv tshem tawm, CHECKDB yuav qhia Wb 5125 yuam kev thiab sim kho nws. Yog tias cov ntawv pov thawj tsis tuaj yeem muab kho, ces nws yuav tsim tawm Wb 3414 yuam kev.
Qhov tseeb cov chaw khaws ntaub ntawv kuj tuaj yeem nrhiav tau, yog tias siv peb cov khoom DataNumen SQL Recovery kom ua hauj lwm.
Qauv Ntaub Ntawv:
| SQL Server version | Corrupt MDF cov ntaub ntawv | MDF ntawv tsau los ntawm DataNumen SQL Recovery |
| SQL Server 2014 | Yuam Kev 8.mdf ua | Yuam Kev 8_fixed.mdf ib |
References: