Uphawu:

Xa uzama ukuncamathisela isiseko sedatha seMDF kwi SQL Server, ubona lo myalezo wemposiso ulandelayo:

Qhoboshela isiseko sedatha esilele kwiServer 'xxx'. (IMicrosoft.SqlServer.Smo)

Ngaphandle kwenzekile ngelixa kusenziwa ingxelo yeTransact-SQL okanye ibhetshi. (IMicrosoft.SqlServer.ConnectionInfo)

Intloko yefayile 'ye-xxx.mdf' ayisiyiyo ifayile yeedatha esemthethweni. Umhlaba wefayile we-FILE awulunganga. (Micosoft SQL ServerImpazamo: 5172)

apho 'xxx.mdf' ligama lefayile ye-MDF ekufuneka iqhotyoshelwe.

Isikrini somyalezo wemposiso:

Ingcaciso echanekileyo:

Idatha ekwifayile ye-MDF igcinwe njengamaphepha, iphepha ngalinye liyi-8KB. Iphepha lokuqala libizwa njengesihloko sephepha lefayile, esine-most Ulwazi olubalulekileyo malunga nayo yonke ifayile, njengokutyikitya kwefayile, ubungakanani befayile, ukuhambelana, njl

Ukuba iphepha lephepha lefayile le-MDF lonakele okanye lonakele, kwaye alinakuqondwa yiMicrosoft SQL Server, ngoko SQL Server izakucinga ukuba i-header ayisebenzi kwaye ichaze le mpazamo.

Ungayisebenzisa imveliso yethu DataNumen SQL Recovery ukubuyisa idatha kwifayile eyonakeleyo ye-MDF kunye nokusombulula le mpazamo.

Iifayile zeSampulu:

Isampulu iifayile ze-MDF ezonakeleyo eziza kubangela impazamo:

SQL Server Inguqulelo Ifayile ye-MDF eyonakeleyo Ifayile ye-MDF elungiswe DataNumen SQL Recovery
SQL Server 2005 Impazamo2_1.mdf Impazamo2_1_fixed.mdf
SQL Server 2008 iR2 Impazamo2_2.mdf Impazamo2_2_fixed.mdf
SQL Server 2012 Impazamo2_3.mdf Impazamo2_3_fixed.mdf
SQL Server 2014 Impazamo2_4.mdf Impazamo2_4_fixed.mdf