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 5028, Mzere wa 16, State 4, Line 4
Makinawa samatha kuyika nkhokwe yokwanira kuti amangenso chipika.
Zotsatira za DBCC za 'xxxx'.
CHECKDB idapeza zolakwika za kugawa 0 ndi zolakwika 0 zosasinthika mu database 'xxxx'.
Msg 7909, Mzere wa 20, State 1, Line 4
Kukonza mwadzidzidzi-mode kwalephera. Muyenera kubwezeretsa kuchokera kubwerera.

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

Msg 5028 cholakwika si cholakwika chogawa kapena cholakwika chokhazikika.

pamene Msg 7909 ndi cholakwika chachikulu chomwe chitha kupezeka m'malo ambiri nthawi iliyonse SQL Server ndikuganiza kuti nkhokweyo singachiritsike.

Chithunzi chojambula cha uthenga wolakwika:

Kufotokozera Kwenikweni:

Uthenga wolakwika (Msg 5028) ikuwoneka kuti ikugwirizana ndi fayilo ya LOG. Komabe, uku ndi kunena molakwika. Vuto lenileni lidayambikabe chifukwa cha ziphuphu za database ya MDF.

Mutha kugwiritsa ntchito mankhwala athu DataNumen SQL Recovery kuti mubwezeretse zomwe zili mu fayilo yoyipa ya MDF ndikuthana ndi vutoli.

Zitsanzo owona:

Zitsanzo za mafayilo achinyengo a MDF omwe angayambitse fayilo ya Msg 5028 cholakwa:

SQL Server Baibulo Ziphuphu MDF wapamwamba Fayilo ya MDF yokonzedwa ndi DataNumen SQL Recovery
SQL Server 2014 Cholakwika3.mdf Zolakwika3_fixed.mdf