Chiratidzo:

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

SQL Server yakaona zvine mutsindo kuenderana-kwakavakirwa I / O kukanganisa: isiriyo checksum (inotarisirwa: 0x2abc3894; chaiyo: 0x2ebe208e). Izvo zvakaitika panguva yekuverengwa kwepeji (1: 1) mune dhatabhesi ID 12 pakubvisa 0x00000000002000 mufaira 'xxx.mdf'. Mamwe mameseji mu SQL Server yekukanganisa danda kana system yechiitiko rogi inogona kupa rumwe ruzivo. Iyi ndiyo yakaipa mamiriro ekukanganisa anotyisidzira dhata rekuvimbika uye rinofanira kugadziriswa nekukasira. Pedzisa yakazara yakazara database kuenderana cheki (DBCC CHECKDB). Iko kukanganisa kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Mabhuku Online. (Microsoft SQL Server, Kukanganisa: 824)

iko 'xxx.mdf' izita reiyo MDF faira iri kuwanikwa.

Dzimwe nguva iwe iyo .MDF dhatabhesi inogona kubatanidzwa zvinobudirira. Nekudaro, iwe paunoyedza kuita chirevo cheSQL, senge

Sarudza * KUBVA [TestDB]. [Dbo]. [Test_table_1]

iwe zvakare uchawana iri pamusoro mhosho meseji.

Screenshot yekukanganisa meseji:

Tsananguro chaiyo:

Iyo data mune MDF faira yakachengetwa semapeji, peji rega rega i8KB. Peji rega rega rine yakasarudzika checksum munda.

If SQL Server inowana checksum kukosha mune mamwe emapeji e data asiri echokwadi, ipapo ichazotaurira kukanganisa uku.

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 Kukanganisa4_1.mdf Kukanganisa4_1_fixed.mdf
SQL Server 2008 R2 Kukanganisa4_2.mdf Kukanganisa4_2_fixed.mdf
SQL Server 2012 Kukanganisa4_3.mdf Kukanganisa4_3_fixed.mdf
SQL Server 2014 Kukanganisa4_4.mdf Kukanganisa4_4_fixed.mdf