Alamar:

Lokacin amfani Farashin DBCC 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 824, Level 24, Jihar 2, Layin 2
SQL Server gano kuskuren I / O mai daidaito mai ma'ana: shafi mara kyau (ana tsammanin 1: 143; ainihin 0:9). Hakan ya faru ne yayin karanta shafi (1: 143) a cikin ID ID na bayanan 39 a biya diyya 0x0000000011e000 a cikin fayil 'C: Fayilolin Shirye-shiryeMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Messagesarin saƙonni a cikin SQL Server kuskuren kuskure ko tsarin taron tsarin na iya samar da cikakken bayani. Wannan mummunan kuskure ne yanayin da ke barazanar mutuncin bayanan bayanai kuma dole ne a gyara shi nan da nan. Kammala cikakken tsarin daidaito na bayanai (DBCC CHECKDB). Wannan kuskuren na iya haifar da dalilai da yawa; don ƙarin bayani, duba SQL Server Littattafai akan layi.
Msg 3313, Level 21, Jihar 1, Layin 2
Yayin sake aiwatar da wani aiki a cikin rumbun adana bayanan 'Error1', kuskure ya faru a ID rikodin rajista (135: 752: 2). Yawanci, takamaiman gazawar da aka riga an shiga azaman kuskure a cikin sabis ɗin Rajistar Windows. Sake dawo da rumbun adana bayanan daga cikakkun bayanai, ko gyara rumbun adana bayanan.
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.
Msg 824, Level 24, Jihar 2, Layin 2
SQL Server gano kuskuren I / O mai daidaito mai ma'ana: shafi mara kyau (ana tsammanin 1: 160; ainihin 0:41). Hakan ya faru ne yayin karanta shafi (1: 160) a cikin ID na bayanan ID 39 a biya diyya 0x00000000140000 a cikin fayil 'C: Fayilolin ShirinMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Messagesarin saƙonni a cikin SQL Server kuskuren kuskure ko tsarin taron tsarin na iya samar da cikakken bayani. Wannan mummunan kuskure ne yanayin da ke barazanar mutuncin bayanan bayanai kuma dole ne a gyara shi nan da nan. Kammala cikakken tsarin daidaito na bayanai (DBCC CHECKDB). Wannan kuskuren na iya haifar da dalilai da yawa; don ƙarin bayani, duba SQL Server Littattafai akan layi.
Msg 824, Level 24, Jihar 2, Layin 4
SQL Server gano kuskuren I / O mai daidaito mai ma'ana: shafi mara kyau (ana tsammanin 1: 160; ainihin 0:41). Hakan ya faru ne yayin karanta shafi (1: 160) a cikin ID na bayanan ID 39 a biya diyya 0x00000000140000 a cikin fayil 'C: Fayilolin ShirinMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Messagesarin saƙonni a cikin SQL Server kuskuren kuskure ko tsarin taron tsarin na iya samar da cikakken bayani. Wannan mummunan kuskure ne yanayin da ke barazanar mutuncin bayanan bayanai kuma dole ne a gyara shi nan da nan. Kammala cikakken tsarin daidaito na bayanai (DBCC CHECKDB). Wannan kuskuren na iya haifar da dalilai da yawa; don ƙarin bayani, duba SQL Server Littattafai akan layi.

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

Farashin 3313 yana nuna ba a iya yin aikin log.

Hoton kuskuren hoto:

Daidaitaccen Bayani:

Lokacin da CHECKDB ba zai iya aiwatar da aiki ba, zai ba da rahoton saƙon kuskuren Farashin 3313 da kuma kokarin gyara kurakurai. Idan ba zai iya gyara kuskuren ba, to murmurewa ya kasa kuma zai haifar da ƙarin kurakurai, kamar su Msg 3414 da Msg 824.

Zaka iya amfani da samfurinmu DataNumen SQL Recovery don dawo da bayanan daga fayil ɗin MDF mai lalata kuma warware wannan kuskuren.

Samfurin fayiloli:

Samfurin gurbatattun fayilolin MDF wanda zai haifar da Farashin 3313 kuskure:

SQL Server version Gurbataccen MDF fayil Fayil MDF ta gyara DataNumen SQL Recovery
SQL Server 2014 Kuskure9.mdf Kuskuren9_fixed.mdf

References: