Uphawu:
Lapho uzama ukunamathisela i-database ye-.MDF ku- SQL Server, ubona umlayezo wephutha olandelayo:
Ukunamathisela i-database kwehlulekile ku-Server 'xxx'. (Microsoft.SqlServer.Smo)
Okuhlukile kwenzeke ngenkathi kwenziwa isitatimende seTransact-SQL noma iqoqo. (Microsoft.SqlServer.ConnectionInfo)
Unhlokweni wefayela 'xxx.mdf' awuyona unhlokweni wefayela ledatha ovumelekile. Isakhiwo se-FILE SIZE asilungile. (Micosoft SQL Server, Iphutha: 5172)
lapho 'xxx.mdf' igama lefayela le-MDF elizonanyathiselwa.
Isithombe-skrini somlayezo wephutha:
Incazelo eqondile:
Idatha kufayela le-MDF igcinwa njengamakhasi, ikhasi ngalinye linosayizi ongu-8KB. Ikhasi lokuqala, elibizwa ngokuthi ikhasi lesihloko sefayela, liqukethe i-most ulwazi olubalulekile mayelana nefayela lonke, okuhlanganisa isiginesha yefayela, usayizi, ukuhambisana, kanye eminye imininingwane ebalulekile.
Uma ikhasi leheda yefayela le-MDF lonakele noma lonakele, futhi alikwazi ukuqashelwa yiMicrosoft SQL Server, khona-ke SQL Server uzocabanga ukuthi unhlokweni akavumelekile 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 | Iphutha2_1.mdf | Iphutha2_1_fixed.mdf |
SQL Server 2008 R2 | Iphutha2_2.mdf | Iphutha2_2_fixed.mdf |
SQL Server 2012 | Iphutha2_3.mdf | Iphutha2_3_fixed.mdf |
SQL Server 2014 | Iphutha2_4.mdf | Iphutha2_4_fixed.mdf |