Chiratidzo:

Pakuisa .MDF database in SQL Server, unoona inotevera mhosho meseji:

SQL Server yakaona kukanganisa kunoenderana-kwakavakirwa I/O: peji rakabvaruka (siginicha inotarisirwa: 0x#########; siginicha chaiyo: 0x########). Zvakaitika panguva yekuverengwa kwepeji (#:#) mudatabase ID # painogumira ### mufaira 'xxxx.mdf'. Mamwe mameseji mu SQL Server kukanganisa log kana system chiitiko log inogona kupa rumwe ruzivo. Ichi chikanganiso chakakomba chinotyisidzira kuvimbika kwedatabase uye inofanirwa kugadziriswa nekukasira. Zadzisa yakazara dhatabhesi kuenderana cheki (DBCC CHECKDB). Kukanganisa uku kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Books Online.

apo 'xxx.mdf' izita reMDF faira riri kuwanikwa.

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

SARUDZA * KUBVA ku[TestDB].[dbo].[test_table_1]

iwe zvakare uchawana iri pamusoro mhosho meseji.

Screenshot yemhosho meseji:

Tsanangudzo Yakananga:

Iyo data muMDF faira inochengetwa semapeji, peji rega rega i8KB. SQL Server inoshandisa nzira mbiri kuti ive nechokwadi chekuenderana uye kubatanidzwa kwe data iri papeji, kureva, checksum kana peji rakabvaruka. Zvose ndezvekusarudza.

If SQL Server inowana mapeji abvarurwa emamwe mapeji edata haakodzeri, inobva yataura 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 Error5_1.mdf Error5_1_fixed.mdf
SQL Server 2008 R2 Error5_2.mdf Error5_2_fixed.mdf
SQL Server 2012 Error5_3.mdf Error5_3_fixed.mdf
SQL Server 2014 Error5_4.mdf Error5_4_fixed.mdf