Cov tsos mob:

Thaum sim xa ib .MDF database hauv SQL Server, koj pom cov lus yuam kev hauv qab no:

Ua tsis tiav cov ntaub ntawv rau kev thov no. (Microsoft.SqlServer.Management.Sdk.Sfc)

Qhov kev zam tau tshwm sim thaum ua tiav Kev Hloov-SQL nqe lus lossis pob khoom. (Microsoft.SqlServer.ConnectionInfo)

xxx.mdf tsis yog lub chaw khaws ntaub ntawv tseem ceeb. (Microsoft SQL Server, Yuam kev: 5171)

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 khaws cia ua nplooj ntawv, txhua nplooj ntawv yog 8KB. Thawj nplooj ntawv hu ua nplooj ntawv ua cov nplooj ntawv, uas muaj cov most cov ntaub ntawv tseem ceeb txog tag nrho cov ntaub ntawv, xws li cov ntaub ntawv kos npe, cov ntaub ntawv loj, kev sib raug zoo, thiab lwm yam. Cov nplooj ntawv txuas ntxiv tseem muaj cov ntaub ntawv tseem ceeb, suav nrog cov nplooj ntawv faib cov ntaub ntawv nrog rau cov ntaub ntawv tiag tiag.

Yog tias MDF cov ntawv sau ua nplooj, lossis lwm cov nplooj ntawv tseem ceeb tswj hwm raug puas los yog tsis muaj peev xwm, thiab tsis tuaj yeem lees paub los ntawm Microsoft SQL Server, ces SQL Server yuav xav tias tag nrho cov ntaub ntawv tsis yog qhov siv tau los ntawm tus thawj cov ntaub ntawv thiab qhia qhov kev ua txhaum 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 Kev1_1.mdf Yuam Kev1_1_fixed.mdf
SQL Server 2008 R2 Yuam Kev1_2.mdf Yuam Kev1_2_fixed.mdf
SQL Server 2012 Yuam Kev1_3.mdf Yuam Kev1_3_fixed.mdf
SQL Server 2014 Yuam Kev1_4.mdf Yuam Kev1_4_fixed.mdf