Chiratidzo:
Pakuisa .MDF database in SQL Server, unoona inotevera mhosho meseji:
SQL Server yakaona kukanganisa kunoenderana-kwakavakirwa I / O kukanganisa: cheki isiriyo (inotarisirwa: 0x2abc3894; chaiyo: 0x2ebe208e). Zvakaitika panguva yekuverenga peji (1: 1) mudatabase ID 12 pakubvisa 0x00000000002000 mufaira 'xxx.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.(Microsoft SQL Server, Kukanganisa:824)
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. Peji rega rega rine nzvimbo yekutarisa yesarudzo.
If SQL Server inoona kuti checksum values mune mamwe mapeji edata haakodzeri, zvino ichataura 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 | Error4_1.mdf | Error4_1_fixed.mdf |
| SQL Server 2008 R2 | Error4_2.mdf | Error4_2_fixed.mdf |
| SQL Server 2012 | Error4_3.mdf | Error4_3_fixed.mdf |
| SQL Server 2014 | Error4_4.mdf | Error4_4_fixed.mdf |