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:

Imininingwane esefayilini le-MDF igcinwa njengamakhasi, ikhasi ngalinye lingu-8KB. Ikhasi lokuqala libizwa ngokuthi ikhasi lekhanda lefayela, eliqukethe i-most imininingwane ebalulekile ngefayela lonke, njengesiginesha yefayela, usayizi wefayela, ukuhambisana, njll.

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