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:
DBCC mhinduro dze 'xxxx'.
CHECKDB yakawana 0 zvikanganiso zvekugovera uye 0 zvikanganiso zvekuenderana mudhatabhesi 'xxxx'.
Msg 824, Chikamu 24, State 2, Mutsara 8
SQL Server yakaona inonzwisisika-yakavakirwa I / O kukanganisa: isiriyo checksum (inotarisirwa: 0xea8a9a2f; chaiyo: 0x37adbff8). Zvakaitika panguva yekuverengwa kwepeji (1:28) mudatabase ID 39 pa offset 0x00000000038000 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 'xxxx.mdf' izita reMDF faira rine huori riri kugadziriswa. Kunyangwe CHECKDB ichiti
CHECKDB yakawana 0 zvikanganiso zvekugovera uye 0 zvikanganiso zvekuenderana mudhatabhesi 'xxxx'.
Ichi chichiri kukanganisa kunoenderana (Msg 824) mu database.
Screenshot yemhosho meseji:
Kana huwori hwacho hwakanyanya, ipapo pachave neanoramba achikanganisa meseji(Msg 824), sezvinotevera:
Msg 824, Chikamu 24, State 6, Mutsara 2 SQL Server yakaona kukanganisa-kwakavakirwa I / O kukanganisa: cheki isiriyo (inotarisirwa: 0x3d17dfef; chaiyo: 0xd81748ef). Zvakaitika panguva yekuverenga peji (1: 0) mu database ID 39 pa offset 0000000000000000 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.
Msg 824, Chikamu 24, State 6, Mutsara 4 SQL Server yakaona kukanganisa-kwakavakirwa I / O kukanganisa: cheki isiriyo (inotarisirwa: 0x3d17dfef; chaiyo: 0xd81748ef). Zvakaitika panguva yekuverenga peji (1: 0) mu database ID 39 pa offset 0000000000000000 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 'xxxx.mdf' izita reMDF faira rine huori riri kugadziriswa.
Screenshot yemhosho meseji:
Kana huwori hwakanyanya, munogona kuona Msg 7909 inotevera Msg 824:
DBCC mhinduro dze 'xxxx'.
CHECKDB yakawana 0 zvikanganiso zvekugovera uye 0 zvikanganiso zvekuenderana mudhatabhesi 'xxxx'.
Msg 824, Chikamu 24, State 2, Mutsara 8
SQL Server yakaona kukanganisa-kwakavakirwa I / O kukanganisa: cheki isiriyo (inotarisirwa: 0xcfcd2118; chaiyo: 0x6fc599d6). Zvakaitika panguva yekuverenga peji (1: 1) mu database ID 39 pa offset 0x00000000002000 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.
Msg 7909, Chikamu 20, State 1, Mutsara 8
Kugadzirisa kwechimbichimbi kwakundikana.Unofanirwa kudzoreredza kubva kune backup.
apo 'xxxx' ndiro zita repa database uye 'xxxx.mdf' ndiro dhatabhesi rezita refaira rezita.
chitsamba Msg 7909 iko kukanganisa kwakanyanya kunogona kuitika mumamiriro mazhinji chero nguva SQL Server funga dhatabhesi iri kupfuura kupora.
Screenshot yemhosho meseji:
Tsanangudzo Yakananga:
Iyo data muMDF faira inochengetwa se8KB mapeji. Peji rega rega rine nzvimbo yekutarisa yesarudzo.
Kana DBCC CHECKDB murairo ukawana machecksum values mumusoro peji, PFS peji uye mamwe mapeji edata haashande uye haakwanise kugadzirisa dambudziko, zvino ichataura kukanganisa uku(Msg 824) Kana huwori hwakanyanya, panogona kuramba paine zvikanganiso (Msg 824) kana kuteverwa neimwe kukanganisa (Msg 7909).
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 kukanganisa (Imwe Msg 824 kukanganisa):
| SQL Server mhando | Uori MDF faira | MDF faira rakagadziriswa ne DataNumen SQL Recovery |
| SQL Server 2014 | Error1_3.mdf | Error1_3_fixed.mdf |
Sample huwori MDF mafaera anokonzeresa kukanganisa (Inoenderera Msg 824 kukanganisa):
| SQL Server mhando | Uori MDF faira | MDF faira rakagadziriswa ne DataNumen SQL Recovery |
| SQL Server 2014 | Error1_1.mdf | Error1_1_fixed.mdf |
Sample huwori MDF mafaera anokonzeresa kukanganisa (Msg 824 kukanganisa ichiteverwa neMsg 7909 kukanganisa):
| SQL Server mhando | Uori MDF faira | MDF faira rakagadziriswa ne DataNumen SQL Recovery |
| SQL Server 2014 | Error1_2.mdf | Error1_2_fixed.mdf |