Alamar:

Lokacin amfani DBCC CHECKDB tare da GYARA_ALLOW_DATA_LOSS siga don gyara m .MDF database, kamar wannan:

DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')

ka ga sakon kuskure mai zuwa:

Msg 5125, Level 24, Jihar 2, Layin 2
Fayil 'C: Fayilolin ShirinMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf 'ya bayyana cewa tsarin aiki ya yanke shi. Girman da ake tsammani shine 5120 KB amma ainihin girman shine 5112 KB.
Msg 3414, Level 21, Jihar 1, Layin 2
Kuskure ya faru yayin dawowa, yana hana maɓallin 'Error1' (39: 0) daga ci gabatartsinkaya Binciko kurakuran dawowa kuma gyara su, ko dawo da su daga sananniyar wariyar ajiya. Idan ba a gyara ko sa ran kurakurai ba, tuntuɓi Tallafin Fasaha.

inda 'Error1' shine sunan ɓataccen bayanan MDF da ake gyarawa.

Msg 5125 kuskure ne mafi kusantar kuskuren kasafi ko kuskuren daidaito. Hakan na faruwa ne yayin da aka cire bangaren wutsiyar fayil din MDB, saboda lalacewar bayanai.

Hoton kuskuren hoto:

Daidaitaccen Bayani:

Lokacin da aka cire ɓangaren wutsiyar fayil din MDB, Bincika zai bayar da rahoto Msg 5125 kuskure da kokarin gyara shi. Idan ba za'a iya gyara bayanan ba, to zai samar Msg 3414 kuskure.

A zahiri za a iya dawo da bayanan, idan ana amfani da kayanmu DataNumen SQL Recovery ayi aikin.

Samfurin fayiloli:

SQL Server version Gurbataccen MDF fayil Fayil MDF ta gyara DataNumen SQL Recovery
SQL Server 2014 Kuskure8.mdf Kuskure8_ka gyara.mdf

References: