Chizindikiro:

Mukamagwiritsa ntchito Kufufuza ndi KONZANITSA_ALLOW_DATA_LOSS parameter kuti akonze database yachinyengo ya .MDF, monga chonchi:

DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')

mukuwona uthenga wolakwikawu:

Msg 5125, Mzere wa 24, State 2, Line 2
Wapamwamba 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf 'ikuwoneka kuti idadulidwa ndi kachitidwe kake. Kukula kwakukulu ndi 5120 KB koma kukula kwenikweni ndi 5112 KB.
Msg 3414, Mzere wa 21, State 1, Line 2
Vuto linachitika panthawi yochira, kuteteza nkhokwe ya 'Error1' (39: 0) kuchokera pa restarkulira. Dziwani zolakwika zomwe mwapeza ndikuzikonza, kapena bwezerani kuchokera kuzosunga zobwezeretsera zabwino. Ngati zolakwitsa sizikukonzedwa kapena kuyembekezeredwa, lemberani technical Support.

pomwe 'Error1' ndi dzina la database yachinyengo ya MDF yomwe ikukonzedwa.

Msg 5125 Cholakwika ndicholakwika pakugawana kapena kusasinthasintha. Zimachitika gawo la mchira wa fayilo ya MDB litachotsedwa, chifukwa cha ziphuphu za data.

Chithunzi chojambula cha uthenga wolakwika:

Kufotokozera Kwenikweni:

Gawo la mchira wa fayilo ya MDB litachotsedwa, CHECKDB idzanena Msg 5125 cholakwika ndikuyesera kukonza. Ngati nkhokweyo singakonzeke, ndiye kuti ipanga Msg 3414 Zolakwika.

Kwenikweni nkhokweyo itha kupezekanso, ngati mutagwiritsa ntchito mankhwala athu DataNumen SQL Recovery kuchita ntchitoyi.

Zitsanzo owona:

SQL Server Baibulo Ziphuphu MDF wapamwamba Fayilo ya MDF yokonzedwa ndi DataNumen SQL Recovery
SQL Server 2014 Zolakwika8.mdf Zolakwika8zodandaula.mdf

Zothandizira: