Uphawu:
Xa uzama ukuqhoboshela isiseko sedata se.MDF kwi SQL Server, ubona lo myalezo wemposiso ulandelayo:
Ayiphumelelanga ukufumana idata yesi sicelo. (Microsoft.SqlServer.Management.Sdk.Sfc)
Umkhethe kwenzekile ngelixa bekusenziwa ingxelo yeTransact-SQL okanye ibhetshi. (Microsoft.SqlServer.ConnectionInfo)
xxx.mdf asiyofayile yesiseko sesiseko. (uMicrosoft SQL Server, impazamo: 5171)
apho 'xxx.mdf ligama lefayile ye-MDF emayincanyathiselwe.
Umfanekiso weskrini wemposiso:
Ingcaciso echanekileyo:
Idatha kwifayile ye-MDF igcinwe njengamaphepha, iphepha ngalinye yi-8KB. Iphepha lokuqala libizwa ngokuba liphepha leheader yefayile, equlathe i most ulwazi olubalulekileyo malunga nefayile yonke, njengotyikityo lwefayile, ubungakanani befayile, ukuhambelana, njl njl.
Ukuba iphepha leheader yefayile yeMDF, okanye amanye amaphepha abalulekileyo olawulo wonakalisiwe okanye wonakalisiwe, kwaye akanakubonwa nguMicrosoft. SQL Server, ngoko SQL Server izakucinga ukuba yonke ifayile ayisiyiyo ifayile yesiseko esebenzayo kwaye uxele le mpazamo.
Ungasebenzisa imveliso yethu DataNumen SQL Recovery ukubuyisela idatha kwifayile ye-MDF eyonakele kwaye uyisombulule le mpazamo.
Iifayili zesampulu:
Isampulu yeefayile zeMDF ezonakeleyo eziza kubangela impazamo:
SQL Server Inguqulelo | Ifayile ye-MDF eyonakele | Ifayile ye-MDF ilungiswe ngu DataNumen SQL Recovery |
SQL Server 2005 | Imposiso1_1.mdf | Imposiso1_1_fixed.mdf |
SQL Server 2008 iR2 | Imposiso1_2.mdf | Imposiso1_2_fixed.mdf |
SQL Server 2012 | Imposiso1_3.mdf | Imposiso1_3_fixed.mdf |
SQL Server 2014 | Imposiso1_4.mdf | Imposiso1_4_fixed.mdf |