Chiratidzo:

Paunenge uchishandisa DBCC CHECKDB ne REPAIR_ALLOW_DATA_LOSS paramende kugadzirisa yakashata .MDF dhatabhesi, seizvi:

DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')

iwe unoona inotevera yekukanganisa meseji:

Msg 824, Chikamu 24, State 2, Mutsara 2
SQL Server yaona kukanganisa kunoenderana-kwakavakirwa I / O kukanganisa: isiriyo pejiid (inotarisirwa 1: 143; chaiyo 0:9). Izvo zvakaitika panguva yekuverengwa kwepeji (1: 143) mune dhatabhesi ID 39 pane 0x0000000011e000 mufaira 'C: Chirongwa Mafaira SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Mamwe mameseji mu SQL Server yekukanganisa danda kana system yechiitiko rogi inogona kupa rumwe ruzivo. Iyi ndiyo yakaipa mamiriro ekukanganisa anotyisidzira dhata rekuvimbika uye rinofanira kugadziriswa nekukasira. Pedzisa yakazara yakazara database kuenderana cheki (DBCC CHECKDB). Iko kukanganisa kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Mabhuku Online.
Msg 3313, Chikamu 21, State 1, Mutsara 2
Munguva yekuitisa patsva kweakashanda mashandiro mudhatabhesi 'Error1', kukanganisa kwakaitika paRekhodhi ID (135: 752: 2) Kazhinji, kutadza chaiko kwakambotemerwa sekukanganisa muWindows Chiitiko Log sevhisi. Dzosera iyo dhatabhesi kubva kuzere backup, kana gadzirisa dhatabhesi.
Msg 3414, Chikamu 21, State 1, Mutsara 2
Iko kukanganisa kwakaitika panguva yekudzoreredza, kudzivirira iyo dhatabhesi 'Error1' (39: 0) kubva ku restarting. Wongorora zvikanganiso zvekudzoreredza wozvigadzirisa, kana kudzosera kubva kune inozivikanwa inozivikanwa backup Kana zvikanganiso zvisina kugadziriswa kana kutarisirwa, bata technical Support.
Msg 824, Chikamu 24, State 2, Mutsara 2
SQL Server yakaona inonzwisisika-inoenderana-yakavakirwa I / O kukanganisa: isiriyo pejiid (inotarisirwa 1: 160; chaiyo 0:41). Izvo zvakaitika panguva yekuverengwa peji (1: 160) mune dhatabhesi ID 39 pane 0x00000000140000 mufaira 'C: Chirongwa Mafaira SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Mamwe mameseji mu SQL Server yekukanganisa danda kana system yechiitiko rogi inogona kupa rumwe ruzivo. Iyi ndiyo yakaipa mamiriro ekukanganisa anotyisidzira dhata rekuvimbika uye rinofanira kugadziriswa nekukasira. Pedzisa yakazara yakazara database kuenderana cheki (DBCC CHECKDB). Iko kukanganisa kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Mabhuku Online.
Msg 824, Chikamu 24, State 2, Mutsara 4
SQL Server yakaona inonzwisisika-inoenderana-yakavakirwa I / O kukanganisa: isiriyo pejiid (inotarisirwa 1: 160; chaiyo 0:41). Izvo zvakaitika panguva yekuverengwa peji (1: 160) mune dhatabhesi ID 39 pane 0x00000000140000 mufaira 'C: Chirongwa Mafaira SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Mamwe mameseji mu SQL Server yekukanganisa danda kana system yechiitiko rogi inogona kupa rumwe ruzivo. Iyi ndiyo yakaipa mamiriro ekukanganisa anotyisidzira dhata rekuvimbika uye rinofanira kugadziriswa nekukasira. Pedzisa yakazara yakazara database kuenderana cheki (DBCC CHECKDB). Iko kukanganisa kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Mabhuku Online.

iko 'Error1' izita re database ye MDF yakashata iri kugadziriswa.

Msg 3313 inoratidza mashandiro erogi haigone kuitwa.

Screenshot yekukanganisa meseji:

Tsananguro chaiyo:

Kana CHECKDB isingakwanise kuita mashandiro ekushandisa, inozivisa meseji yekukanganisa Msg 3313 uye edza kugadzirisa zvikanganiso. Kana isingakwanise kugadzirisa iko kukanganisa, ikozve kupora kunotadza uye kunotungamira kune mamwe mhosho, senge Msg 3414 uye Msg 824.

Unogona kushandisa chigadzirwa chedu DataNumen SQL Recovery kudzoreredza iyo data kubva kune yakashata MDF faira uye kugadzirisa iyi kukanganisa.

Semuenzaniso Mafaira:

Semuenzaniso yakashata MDF mafaera ayo anokonzeresa iyo Msg 3313 mhosho:

SQL Server mhando Yakashata MDF faira MDF faira rakagadziriswa ne DataNumen SQL Recovery
SQL Server 2014 Kukanganisa9.mdf Kukanganisa9_fixed.mdf

References: