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 824, Mzere wa 24, State 2, Line 2
SQL Server adazindikira cholakwika chotsatira I / O chokhazikika: tsamba lolakwika (zoyembekezeka 1: 143; zenizeni 0: 9). Izi zidachitika powerenga tsamba (1: 143) mu database ID 39 pa 0x0000000011e000 mu fayilo 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Mauthenga owonjezera mu SQL Server zolakwika kapena zolembera zamachitidwe zitha kupereka tsatanetsatane. Uku ndikulakwitsa kwakukulu komwe kumawopseza kukhulupirika pamasamba ndipo kuyenera kukonzedwa nthawi yomweyo. Lembani cheke chathunthu chokhazikika (DBCC CHECKDB). Vutoli limatha kuyambitsidwa ndi zinthu zambiri; kuti mumve zambiri, onani SQL Server Mabuku Paintaneti.
Msg 3313, Mzere wa 21, State 1, Line 2
Pakubwezeretsanso ntchito yosungidwa mu database 'Error1', zolakwika zidachitika pa ID ya mbiri (135: 752: 2). Nthawi zambiri, kulephera kumeneku kumalowetsedwa kale ngati cholakwika mu Windows Event Log service. Bweretsani nkhokweyo kuchokera pakusunga kwathunthu, kapena konzani database.
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.
Msg 824, Mzere wa 24, State 2, Line 2
SQL Server adazindikira cholakwika chokhazikika pa I / O: tsamba lolakwika (loyembekezeredwa 1: 160; zenizeni 0:41). Izi zidachitika powerenga tsamba (1: 160) mu database ID 39 pa 0x00000000140000 mu fayilo 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Mauthenga owonjezera mu SQL Server zolakwika kapena zolembera zamachitidwe zitha kupereka tsatanetsatane. Uku ndikulakwitsa kwakukulu komwe kumawopseza kukhulupirika pamasamba ndipo kuyenera kukonzedwa nthawi yomweyo. Lembani cheke chathunthu chokhazikika (DBCC CHECKDB). Vutoli limatha kuyambitsidwa ndi zinthu zambiri; kuti mumve zambiri, onani SQL Server Mabuku Paintaneti.
Msg 824, Mzere wa 24, State 2, Line 4
SQL Server adazindikira cholakwika chokhazikika pa I / O: tsamba lolakwika (loyembekezeredwa 1: 160; zenizeni 0:41). Izi zidachitika powerenga tsamba (1: 160) mu database ID 39 pa 0x00000000140000 mu fayilo 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Mauthenga owonjezera mu SQL Server zolakwika kapena zolembera zamachitidwe zitha kupereka tsatanetsatane. Uku ndikulakwitsa kwakukulu komwe kumawopseza kukhulupirika pamasamba ndipo kuyenera kukonzedwa nthawi yomweyo. Lembani cheke chathunthu chokhazikika (DBCC CHECKDB). Vutoli limatha kuyambitsidwa ndi zinthu zambiri; kuti mumve zambiri, onani SQL Server Mabuku Paintaneti.

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

Msg 3313 imasonyeza kuti chipika sichingachitike.

Chithunzi chojambula cha uthenga wolakwika:

Kufotokozera Kwenikweni:

CHECKDB ikalephera kugwira ntchito mosavomerezeka, idzalengeza zolakwikazo Msg 3313 ndipo yesani kukonza zolakwikazo. Ngati singathe kukonza cholakwikacho, kuchira kumalephera ndipo kumabweretsa zolakwika zina, monga Msg 3414 ndi Msg 824.

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 3313 cholakwa:

SQL Server Baibulo Ziphuphu MDF wapamwamba Fayilo ya MDF yokonzedwa ndi DataNumen SQL Recovery
SQL Server 2014 Zolakwika9.mdf Zolakwika9_fixed.mdf

Zothandizira: