Cikakken bayani game da Kuskuren CheckDB "Tsarin ba zai iya kunna isassun bayanan ba don sake ginin rajistar"

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 5028, Level 16, Jihar 4, Layin 4
Tsarin bai iya kunna isassun bayanai ba don sake sake ginin.
Sakamakon DBCC don 'xxxx'.
CHECKDB ya sami kurakurai kasafi 0 da kuskuren daidaito 0 a cikin bayanan 'xxxx'.
Msg 7909, Level 20, Jihar 1, Layin 4
Gyara yanayin-gaggawa ya kasa. Dole ne a dawo da shi daga madadin.

inda 'xxxx' sunan sunan MDF gurbatacce da ake gyarawa.

Farashin 5028 kuskure ba kuskuren kasafi bane ko kuskuren daidaito.

Duk da yake Farashin 7909 babban kuskure ne wanda zai iya faruwa a yanayi da yawa duk lokacin da SQL Server yi tunanin bayanan bayanan ya wuce farfadowa.

Hoton kuskuren hoto:

Daidaitaccen Bayani:

Sakon kuskure (Farashin 5028) da alama yana da alaƙa da fayil ɗin LOG. Koyaya, wannan mummunan rahoto ne. Ainihin matsalar har yanzu lalacewa ta hanyar bayanan MDF.

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

SQL Server version	Gurbataccen MDF fayil	Fayil MDF ta gyara DataNumen SQL Recovery
SQL Server 2014	Kuskure3.mdf	Kuskuren3_fixed.mdf