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 5028, Chikamu 16, State 4, Mutsara 4
Iyo sisitimu haina kukwanisa kuita yakakwana yedatabase kuti ivakezve irogi.
DBCC mhinduro dze 'xxxx'.
CHECKDB yakawana 0 zvikanganiso zvekugovera uye 0 zvikanganiso zvekuenderana mudhatabhesi 'xxxx'.
Msg 7909, Chikamu 20, State 1, Mutsara 4
Kugadzirisa kwechimbichimbi kwakundikana.Unofanirwa kudzoreredza kubva kune backup.

uko 'xxxx' izita rehuori MDF dhatabhesi iri kugadziriswa.

Msg 5028 kukanganisa hakusi kukanganisa kwekugovera kana kukanganisa kwekuenderana.

apo Msg 7909 iko kukanganisa kwakanyanya kunogona kuitika mumamiriro mazhinji chero nguva SQL Server funga dhatabhesi iri kupfuura kupora.

Screenshot yemhosho meseji:

Tsanangudzo Yakananga:

Iko kukanganisa meseji (Msg 5028) inoita kunge ine hukama neLOG file. Zvisinei, iyi inhema. Dambudziko chairo richiri kukonzerwa nehuwori hwe database ye MDF.

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 5028 mhosho:

SQL Server mhando Uori MDF faira MDF faira rakagadziriswa ne DataNumen SQL Recovery
SQL Server 2014 Error3.mdf Error3_fixed.mdf