Chiratidzo:
Pakuedza kuisa .MDF database mukati SQL Server, unoona inotevera mhosho meseji:
Tatadza kuburitsa data yechikumbiro ichi. (Microsoft.SqlServer.Management.Sdk.Sfc)
Kusarudzika kwakaitika uchiita chirevo cheTransact-SQL kana batch. (Microsoft.SqlServer.ConnectionInfo)
xxx.mdf harisi rekutanga dhatabhesi faira. (Microsoft SQL Server, Kukanganisa: 5171)
apo 'xxx.mdf izita reMDF faira rinofanira kunamirwa.
Screenshot yemhosho meseji:
Tsanangudzo Yakananga:
Iyo data muMDF faira inochengetwa semapeji, peji rega rega i8KB. Peji yekutanga inonzi peji remusoro wefaira, iro rine most ruzivo rwakakosha pamusoro pefaira rose, sechisiginecha chefaira, saizi yefaira, kuenderana, nezvimwe. Mapeji akasara anewo ruzivo rwakakosha, kusanganisira ruzivo rwekugovera peji pamwe neiyo data chaiyo.
Kana iyo MDF faira remusoro peji, kana mamwe mapeji akakosha ekutarisira akakuvadzwa kana kushatiswa, uye asingakwanisi kuzivikanwa neMicrosoft. SQL Server, ipapo SQL Server achafunga kuti faira rose harisi rekutanga re database faira uye taura kukanganisa uku.
Unogona kushandisa chigadzirwa chedu DataNumen SQL Recovery kuti uwanezve data kubva kune yakaora MDF faira uye kugadzirisa kukanganisa uku.
Sample Files:
Sample yakaora MDF mafaera anokonzeresa kukanganisa:
| SQL Server mhando | Uori MDF faira | MDF faira rakagadziriswa ne DataNumen SQL Recovery |
| SQL Server 2005 | Error1_1.mdf | Error1_1_fixed.mdf |
| SQL Server 2008 R2 | Error1_2.mdf | Error1_2_fixed.mdf |
| SQL Server 2012 | Error1_3.mdf | Error1_3_fixed.mdf |
| SQL Server 2014 | Error1_4.mdf | Error1_4_fixed.mdf |