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 5125, Chikamu 24, State 2, Mutsara 2
Faira 'C:Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf' inoita kunge yakadimburwa neiyo operating system. Saizi inotarisirwa i5120 KB asi saizi chaiyo i5112 KB.
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.

uko 'Error1' izita rehuori MDF dhatabhesi iri kugadziriswa.

Msg 5125 kukanganisa ndiko kuwedzera kukanganisa kwekugovera kana kukanganisa kwekusagadzikana. Izvo zvinoitika kana chikamu chemuswe weMDB faira chabviswa, nekuda kwehuori hwe data.

Screenshot yemhosho meseji:

Tsanangudzo Yakananga:

Kana chikamu chemuswe weMDB faira chabviswa, CHECKDB achataura Msg 5125 kukanganisa uye edza kuigadzirisa. Kana iyo dhatabhesi isingakwanisi kugadziriswa, zvino ichagadzira Msg 3414 kukanganisa.

Chaizvoizvo iyo dhatabhesi inogona zvakare kudzoserwa, kana uchishandisa chigadzirwa chedu DataNumen SQL Recovery kuita basa racho.

Sample Files:

SQL Server mhando Uori MDF faira MDF faira rakagadziriswa ne DataNumen SQL Recovery
SQL Server 2014 Kukanganisa8.mdf Kukanganisa8_fixed.mdf

References: