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 5125, Chikamu 24, State 2, Mutsara 2
Faira 'C: Chirongwa MafairaMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf 'inoita kunge yakaderedzwa neanoshanda system. Saizi inotarisirwa i5120 KB asi saizi chaiyo i5112 KB.
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.

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

Msg 5125 kukanganisa kwakanangana nekukanganisa kwekugovera kana kukanganisa kuenderana. Izvo zvinoitika kana chikamu chemuswe we MDB faira chabviswa, nekuda kwehuori hwe data.

Screenshot yekukanganisa meseji:

Tsananguro chaiyo:

Kana chikamu chemuswe we MDB faira chabviswa, CHECKDB achataura Msg 5125 kukanganisa uye edza kuigadzirisa. Kana dhatabhesi risingakwanise kugadziriswa, ipapo rinogadzira Msg 3414 kukanganisa.

Chaizvoizvo dhatabhesi rinogona zvakare kudzoreredzwa, kana uchishandisa chigadzirwa chedu DataNumen SQL Recovery kuita basa.

Semuenzaniso Mafaira:

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

References: