Cov tsos mob:
Thaum sim xa ib .MDF database hauv SQL Server, koj pom cov lus yuam kev hauv qab no:
Rhais cov ntaub ntawv tsis raug rau Server 'xxx'. (Microsoft.SqlServer.Smo)
Qhov kev zam tau tshwm sim thaum ua tiav Kev Hloov-SQL nqe lus lossis pob khoom. (Microsoft.SqlServer.ConnectionInfo)
Cov ntawv rau header rau 'xxx.mdf' tsis yog qhov chaw khaws ntaub ntawv header. Daim Ntawv TSWV ntawm cov ntaub ntawv tsis yog. Micosoft SQL Server, Yuam kev: 5172）
qhov twg 'xxx.mdf' yog lub npe MDF cov ntaub ntawv yuav tsum txuas nrog.
Screenshot ntawm cov lus yuam:
Nqe Lus Qhia Tshwj Xeeb:
Cov ntaub ntawv hauv MDF cov ntaub ntawv raug khaws cia ua nplooj ntawv, nrog rau txhua nplooj ntawv yog 8 KB loj. Thawj nplooj ntawv, hu ua cov ntaub ntawv header nplooj, muaj cov most cov ntaub ntawv tseem ceeb ntawm tag nrho cov ntaub ntawv, suav nrog cov ntaub ntawv kos npe, qhov loj me, kev sib raug zoo, thiab lwm yam ntsiab lus tseem ceeb.
Yog hais tias MDF cov ntawv sau ua nplooj yog puas los yog lub siab, thiab tsis tuaj yeem lees paub los ntawm Microsoft SQL Server, ces SQL Server yuav xav tias header tsis yog siv tau thiab tshaj tawm qhov kev ua yuam kev no.
Koj tuaj yeem siv peb cov khoom DataNumen SQL Recovery kom rov qab tau cov ntaub ntawv los ntawm cov ntawv tsis txaus siab MDF thiab daws cov kev ua yuam kev no.
Qauv Ntaub Ntawv:
Qauv piv txwv MDF cov ntaub ntawv uas yuav ua rau muaj qhov yuam kev:
| SQL Server version | Corrupt MDF cov ntaub ntawv | MDF ntawv tsau los ntawm DataNumen SQL Recovery |
| SQL Server 2005 | Yuam Kev2_1.mdf | Yuam Kev2_1_fixed.mdf |
| SQL Server 2008 R2 | Yuam Kev2_2.mdf | Yuam Kev2_2_fixed.mdf |
| SQL Server 2012 | Yuam Kev2_3.mdf | Yuam Kev2_3_fixed.mdf |
| SQL Server 2014 | Yuam Kev2_4.mdf | Yuam Kev2_4_fixed.mdf |