Chiratidzo:

Paunenge uchiedza kubatanidza .MDF dhatabhesi mu SQL Server, iwe unoona inotevera yekukanganisa meseji:

Batanidza dhatabhesi yakundikana yeSeva 'xxx'. (Microsoft.SqlServer.Smo)

Kusarudzika kwakaitika paitora chirevo cheTransact-SQL kana batch. (Microsoft.SqlServer.ConnectionInfo)

Musoro wefaira 'xxx.mdf' haisi yechokwadi dhata faira musoro. Iyo FILE SIZE chivakwa haina kururama. (Micosoft SQL Server, Kukanganisa: 5172)

iko 'xxx.mdf' izita reiyo MDF faira rinofanira kuiswa.

Screenshot yekukanganisa meseji:

Tsananguro chaiyo:

Iyo data mune MDF faira yakachengetwa semapeji, peji rega rega i8KB. Peji rekutanga rinonzi iro faira musoro wefaira, iro rine most ruzivo rwakakosha nezve iyo faira rese, senge siginecha faira, saizi refaira, kuenderana, nezvimwe.

Kana iyo MDF faira musoro wepeji rakakuvadzwa kana kukanganiswa, uye risingakwanise kuzivikanwa neMicrosoft SQL Server, ipapo SQL Server uchafunga kuti musoro haushandi uye unotaura chikanganiso ichi.

Unogona kushandisa chigadzirwa chedu DataNumen SQL Recovery kudzoreredza iyo data kubva kune yakashata MDF faira uye kugadzirisa iyi kukanganisa.

Semuenzaniso Mafaira:

Semuenzaniso yakashata MDF mafaera ayo anokanganisa iko kukanganisa:

SQL Server mhando Yakashata MDF faira MDF faira rakagadziriswa ne DataNumen SQL Recovery
SQL Server 2005 Kukanganisa2_1.mdf Kukanganisa2_1_fixed.mdf
SQL Server 2008 R2 Kukanganisa2_2.mdf Kukanganisa2_2_fixed.mdf
SQL Server 2012 Kukanganisa2_3.mdf Kukanganisa2_3_fixed.mdf
SQL Server 2014 Kukanganisa2_4.mdf Kukanganisa2_4_fixed.mdf