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