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 |