Uphawu:

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

Ayiphumelelanga ukufumana kwakhona idatha yesi sicelo. (IMicrosoft.SqlServer.Management.Sdk.Sfc)

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

xxx.mdf ayisiyo fayile yedatha ephambili. (IMicrosoft SQL ServerImpazamo: 5171)

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, njengokutyikitywa kwefayile, ubungakanani befayile, ukuhambelana, njl.njl. Amaphepha ashiyekileyo aqulathe ulwazi olubalulekileyo, kubandakanya ulwazi lokwabiwa kwephepha kunye nedatha eyiyo.

Ukuba iphepha lephepha lefayile le-MDF, okanye amanye amaphepha olawulo abalulekileyo onakele okanye onakalisiwe, kwaye awunakuqatshelwa yiMicrosoft SQL Server, ngoko SQL Server uyakucinga ukuba yonke ifayile ayisiyo fayile yedatha eyisiseko esebenzayo kwaye anike ingxelo ngalempazamo.

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 Impazamo1_1.mdf Impazamo1_1_fixed.mdf
SQL Server 2008 iR2 Impazamo1_2.mdf Impazamo1_2_fixed.mdf
SQL Server 2012 Impazamo1_3.mdf Impazamo1_3_fixed.mdf
SQL Server 2014 Impazamo1_4.mdf Impazamo1_4_fixed.mdf