Chiratidzo:
Pakuedza kuisa .MDF database mukati SQL Server, unoona inotevera mhosho meseji:
Batanidza dhatabhesi yakundikana yeSevha 'xxx'. (Microsoft.SqlServer.Smo)
Kusarudzika kwakaitika uchiita chirevo cheTransact-SQL kana batch. (Microsoft.SqlServer.ConnectionInfo)
Musoro wefaira re'xxx.mdf' hausi musoro wefaira wedatabase unoshanda. Nzvimbo yeFILE SIZE haina kururama.(Micosoft SQL Server, Kukanganisa:5172)
apo 'xxx.mdf' izita reMDF faira rinofanira kunamirwa.
Screenshot yemhosho meseji:
Tsanangudzo Yakananga:
Iyo data iri muMDF faira inochengetwa semapeji, nepeji yega yega iri 8KB muhukuru. Peji rekutanga, rinonzi peji remusoro wefaira, rine most ruzivo rwakakosha nezve faira rese, kusanganisira siginecha yefaira, saizi, kuenderana, uye mamwe mashoko anokosha.
Kana iyo MDF faira yemusoro peji yakakuvadzwa kana kushatiswa, uye haigone kuzivikanwa neMicrosoft SQL Server, ipapo SQL Server achafunga kuti musoro hausi kushanda 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 | Error2_1.mdf | Error2_1_fixed.mdf |
| SQL Server 2008 R2 | Error2_2.mdf | Error2_2_fixed.mdf |
| SQL Server 2012 | Error2_3.mdf | Error2_3_fixed.mdf |
| SQL Server 2014 | Error2_4.mdf | Error2_4_fixed.mdf |