Chizindikiro:

Mukamapanga database ya .MDF mu SQL Server, mukuwona uthenga wolakwikawu:

SQL Server adazindikira cholakwika chokhazikika cha I / O: checksum yolakwika (yoyembekezeredwa: 0x2abc3894; zenizeni: 0x2ebe208e). Izi zidachitika pakuwerengedwa kwa tsamba (1: 1) mu database ID 12 yochotseka 0x00000000002000 mu fayilo 'xxx.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 SQL Server, Cholakwika: 824)

pomwe 'xxx.mdf' ndi dzina la fayilo ya MDF yomwe ikupezeka.

Nthawi zina inu .MDF database imatha kulumikizidwa bwino. Komabe, mukayesa kuchita mawu a SQL, monga

SANKHANI * KUCHOKERA [TestDB]. [Dbo]. [Test_table_1]

mupezanso uthenga wolakwika pamwambapa.

Chithunzi chojambula cha uthenga wolakwika:

Kufotokozera Kwenikweni:

Zomwe zili mu fayilo ya MDF zimasungidwa ngati masamba, tsamba lililonse ndi 8KB. Tsamba lirilonse liri ndi gawo losankha la checksum.

If SQL Server imapeza kuti ma checksum amawerengedwa m'masamba ena achidziwitso ndi osavomerezeka, kenako imanenanso za vutoli.

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 vutoli:

SQL Server Baibulo Ziphuphu MDF wapamwamba Fayilo ya MDF yokonzedwa ndi DataNumen SQL Recovery
SQL Server 2005 Zolakwa4_1.mdf Vuto4_1_fixed.mdf
SQL Server 2008 R2 Zolakwa4_2.mdf Vuto4_2_fixed.mdf
SQL Server 2012 Zolakwa4_3.mdf Vuto4_3_fixed.mdf
SQL Server 2014 Zolakwa4_4.mdf Vuto4_4_fixed.mdf