Macluumaad Faahfaahsan oo ku saabsan "Faylka ayaa u muuqda in lagu jaray Nidaamka Howlgalka" Khalad

Astaamaha:

Markii la isticmaalayo DBCC CHECKDB la REPAIR_ALLOW_DATA_LOSS halbeegga si loo hagaajiyo kaydinta xogta .MDF, sida tan:

DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')

waxaad aragtaa farriinta khaladka soo socda:

Msg 5125, Heerka 24, State 2, Line 2
Faylka 'C: Faylasha BarnaamijkaMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf 'waxay umuuqataa inuu jaray nidaamka qalliinka. Cabirka la filayo waa 5120 KB laakiin cabirka dhabta ah waa 5112 KB.
Msg 3414, Heerka 21, State 1, Line 2
Khalad ayaa dhacay intii lagu jiray soo kabashada, taasoo ka hortageysay keydka 'Error1' (39: 0) restarxoqid Baadhitaan ku samee khaladaadka soo-kabashada oo hagaaji, ama ka soo celi kayd wanaagsan oo la yaqaan. Haddii khaladaadka aan la sixi ama la filayo, la xiriir Taageerada Farsamada.

meesha 'Error1' uu yahay magaca kaydinta xogta MDF ee musuqmaasuqa ah.

Tusmada 5125 khaladku waa mid u qalma qaladka qoondaynta ama qalad joogto ah. Waxay dhacdaa markii qaybta dabada ee faylka MDB laga saaro, musuqmaasuqa xogta awgeed.

Screenshot of message qalad:

Sharaxaad qeexan:

Marka qaybta dabada ee faylka MDB laga saaro, Hubinta soo sheegi doonaa Tusmada 5125 khalad oo isku day inaad hagaajiso. Haddii keydka macluumaadka aan la hagaajin karin, markaa way soo saari doontaa Tusmada 3414 qalad

Dhab ahaantii keydka macluumaadka ayaa sidoo kale la soo celin karaa, haddii la isticmaalayo wax soo saarkeena DataNumen SQL Recovery in la qabto hawsha.

Muunado Faylal:

SQL Server version	Faylka MDF musuqmaasuq	Faylka MDF waxaa hagaajiyay DataNumen SQL Recovery
SQL Server 2014	Khalad8.mdf	Khalad8_waxaa.mdf

Tixraacyo:

• https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-2512-database-engine-error?view=sql-server-ver15
• https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-3414-database-engine-error?view=sql-server-ver15