Chiratidzo:
Paunenge uchishandisa DBCC CHECKDB ne REPAIR_ALLOW_DATA_LOSS parameter kugadzirisa yakaora .MDF dhatabhesi, seizvi:
DBCC CHECKDB(xxxx, 'REPAIR_ALLOW_DATA_LOSS')
iwe unoona inotevera meseji yekukanganisa:
Msg 824, Chikamu 24, State 2, Mutsara 2
SQL Server yakaona kukanganisa-kwakavakirwa I/O kukanganisa: pejiid isiriyo (inotarisirwa 1:143; chaiyo 0:9). Zvakaitika panguva yekuverengwa kwepeji (1:143) mu database ID 39 pa offset 0x0000000011e000 mufaira 'C:Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.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.
Msg 3313, Chikamu 21, State 1, Mutsara 2
Panguva yekudzokorodza kushanda kwakanyorwa mudhatabhesi 'Error1', kukanganisa kwakaitika palog rekodhi ID (135:752:2). Kazhinji, kutadza chaiko kwakambodhindwa sechikanganiso muWindows Event Log service. Dzosera dhatabhesi kubva kune yakazara backup, kana gadzirisa dhatabhesi.
Msg 3414, Chikamu 21, State 1, Mutsara 2
Chikanganiso chakaitika panguva yekudzoreredza, kudzivirira dhatabhesi 'Error1' (39:0) kubva kune restarting. Ongorora zvikanganiso zvekudzoreredza wozvigadzirisa, kana kudzoreredza kubva kune inozivikanwa yakanaka backup. Kana zvikanganiso zvisina kugadziriswa kana kutarisirwa, bata Technical Support.
Msg 824, Chikamu 24, State 2, Mutsara 2
SQL Server yakaona kukanganisa-kwakavakirwa I/O kukanganisa: pejiid isiriyo (inotarisirwa 1:160; chaiyo 0:41). Zvakaitika panguva yekuverenga peji (1:160) mudatabase ID 39 pakubvisa 0x00000000140000 mufaira 'C: Chirongwa MafairaMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.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.
Msg 824, Chikamu 24, State 2, Mutsara 4
SQL Server yakaona kukanganisa-kwakavakirwa I/O kukanganisa: pejiid isiriyo (inotarisirwa 1:160; chaiyo 0:41). Zvakaitika panguva yekuverenga peji (1:160) mudatabase ID 39 pakubvisa 0x00000000140000 mufaira 'C: Chirongwa MafairaMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.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.
uko 'Error1' izita rehuori MDF dhatabhesi iri kugadziriswa.
Msg 3313 inoratidza kuti log operation haigone kuitwa.
Screenshot yemhosho meseji:
Tsanangudzo Yakananga:
Kana CHECKDB isingakwanise kuita basa rakadhindwa, inoshuma meseji yekukanganisa Msg 3313 uye edza kugadzirisa zvikanganiso. Kana iyo isingakwanisi kugadzirisa kukanganisa, ipapo kupora kunokundikana uye kunotungamirira kune zvikanganiso zvakawanda, zvakadai Msg 3414 uye Msg 824.
Unogona kushandisa chigadzirwa chedu DataNumen SQL Recovery kuti uwanezve data kubva kune yakaora MDF faira uye kugadzirisa kukanganisa uku.
Sample Files:
Sample huwori MDF mafaera anokonzeresa iyo Msg 3313 mhosho:
| SQL Server mhando | Uori MDF faira | MDF faira rakagadziriswa ne DataNumen SQL Recovery |
| SQL Server 2014 | Error9.mdf | Error9_fixed.mdf |