Chiratidzo:

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

Yatadza kutora dhata yeichi chikumbiro. (Microsoft.SqlServer.Management.Sdk.Sfc)

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

xxx.mdf harisi rekutanga dhatabhesi faira. (Microsoft SQL Server, Kukanganisa: 5171)

uko '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 pamusoro pefaira rese, senge siginecha faira, saizi yefaira, kuenderana, nezvimwewo. Mapeji asara anewo ruzivo rwakakosha, kusanganisira iwo ruzivo rwekugovera peji pamwe neicho chaicho data.

Kana iyo MDF faira musoro wepeji, kana mamwe akakosha manejimendi mapeji akakuvara kana kukanganiswa, uye haigone kuzivikanwa neMicrosoft SQL Server, ipapo SQL Server ndichafunga iro rese faira isiri yechokwadi dhatabhesi faira uye taura iyi kukanganisa.

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 Kukanganisa1_1.mdf Kukanganisa1_1_fixed.mdf
SQL Server 2008 R2 Kukanganisa1_2.mdf Kukanganisa1_2_fixed.mdf
SQL Server 2012 Kukanganisa1_3.mdf Kukanganisa1_3_fixed.mdf
SQL Server 2014 Kukanganisa1_4.mdf Kukanganisa1_4_fixed.mdf