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 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 ntawv, xws li cov ntawv kos npe, cov ntawv loj me, kev siv tau, thiab lwm yam.

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