Chizindikiro:

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

SQL Server adazindikira cholakwika chotsatira I / O chokhazikika: tsamba loduka (siginecha yoyembekezeredwa: 0x ########; siginecha yeniyeni: 0x #########)). Izi zidachitika pakuwerengedwa kwa tsamba (#: #) mu ID ya # # yojambulira ### mu fayilo 'xxxx.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 '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. SQL Server imagwiritsa ntchito njira ziwiri kuti zitsimikizire kusinthasintha ndikuphatikizika kwa zomwe zili patsamba, ndiye kuti, checksum kapena tsamba long'ambika. Zonsezi ndizosankha.

If SQL Server imapeza masamba omwe adang'ambika pamasamba ena achabechabe, ndiye kuti ifotokoza zolakwika izi.

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 Zolakwa5_1.mdf Vuto5_1_fixed.mdf
SQL Server 2008 R2 Zolakwa5_2.mdf Vuto5_2_fixed.mdf
SQL Server 2012 Zolakwa5_3.mdf Vuto5_3_fixed.mdf
SQL Server 2014 Zolakwa5_4.mdf Vuto5_4_fixed.mdf