Uphawu:
Lapho uzama ukunamathisela i-database ye-.MDF ku- SQL Server, ubona umlayezo wephutha olandelayo:
Yehlulekile ukubuyisa idatha yalesi sicelo. (IMicrosoft.SqlServer.Management.Sdk.Sfc)
Okuhlukile kwenzeke ngenkathi kwenziwa isitatimende seTransact-SQL noma iqoqo. (Microsoft.SqlServer.ConnectionInfo)
xxx.mdf ayilona ifayela eliyisisekelo ledatha. (IMicrosoft SQL Server, Iphutha: 5171)
lapho 'xxx.mdf igama lefayela le-MDF elizonanyathiselwa.
Isithombe-skrini somlayezo wephutha:
Incazelo eqondile:
Imininingwane esefayilini le-MDF igcinwa njengamakhasi, ikhasi ngalinye lingu-8KB. Ikhasi lokuqala libizwa ngokuthi ikhasi lekhanda lefayela, eliqukethe i-most imininingwane ebalulekile mayelana nalo lonke ifayili, njengesiginesha yefayela, usayizi wefayela, ukuhambisana, njll. Amakhasi asele aqukethe nemininingwane ebalulekile, kufaka phakathi imininingwane yokwabiwa kwamakhasi kanye nedatha yangempela.
Uma ikhasi lonhlokweni wefayela le-MDF, noma amanye amakhasi abalulekile okuphatha elimele noma onakalisiwe, futhi angabonwa yiMicrosoft SQL Server, khona-ke SQL Server uzocabanga ukuthi lonke ifayela akulona ifayela ledatha eliyinhloko elivumelekile bese ubika leli phutha.
Ungasebenzisa umkhiqizo wethu DataNumen SQL Recovery ukubuyisa idatha kusuka kufayela le-MDF elonakele bese uxazulula leli phutha.
Amafayela Esampula:
Sampula amafayela we-MDF akhohlakele azodala iphutha:
| SQL Server Version | Ifayela le-MDF elonakele | Ifayela le-MDF lilungiswe ngu DataNumen SQL Recovery |
| SQL Server 2005 | Iphutha1_1.mdf | Iphutha1_1_fixed.mdf |
| SQL Server 2008 R2 | Iphutha1_2.mdf | Iphutha1_2_fixed.mdf |
| SQL Server 2012 | Iphutha1_3.mdf | Iphutha1_3_fixed.mdf |
| SQL Server 2014 | Iphutha1_4.mdf | Iphutha1_4_fixed.mdf |