Uphawu:
Xa uzama ukuqhoboshela isiseko sedata se.MDF kwi SQL Server, ubona lo myalezo wemposiso ulandelayo:
Qhoboshela uvimba weenkcukacha woMncedisi 'xxx' akuphumelelanga. (Microsoft.SqlServer.Smo)
Umkhethe kwenzekile ngelixa bekusenziwa ingxelo yeTransact-SQL okanye ibhetshi. (Microsoft.SqlServer.ConnectionInfo)
Umbhalo ongasentla kwekhasi wefayile 'xxx.mdf' ayingomxholo wefayile yedata esebenzayo. Ipropathi ye-FILE SIZE ayichanekanga.(Micosoft SQL Server, impazamo: 5172
apho 'xxx.mdf' ligama lefayile ye-MDF emayincanyathiselwe.
Umfanekiso weskrini wemposiso:
Ingcaciso echanekileyo:
Idatha kwifayile ye-MDF igcinwa njengamaphepha, kunye nephepha ngalinye libe ngu-8KB ngobukhulu. Iphepha lokuqala, elibizwa ngokuba liphepha leheader yefayile, liqulathe i most ulwazi olubalulekileyo malunga nefayile yonke, kubandakanywa utyikityo lwefayile, ubungakanani, ukuhambelana, kunye ezinye iinkcukacha ezibalulekileyo.
Ukuba iphepha leheader yefayile yeMDF yonakele okanye yonakele, kwaye ayinakubonwa nguMicrosoft SQL Server, ngoko SQL Server izakucinga ukuba iheader ayisebenzi kwaye ichaze lemposiso.
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 | Imposiso2_1.mdf | Imposiso2_1_fixed.mdf |
| SQL Server 2008 iR2 | Imposiso2_2.mdf | Imposiso2_2_fixed.mdf |
| SQL Server 2012 | Imposiso2_3.mdf | Imposiso2_3_fixed.mdf |
| SQL Server 2014 | Imposiso2_4.mdf | Imposiso2_4_fixed.mdf |