Cov tsos mob:

Thaum tso nrog .MDF database hauv SQL Server, koj pom cov lus yuam kev hauv qab no:

SQL Server kuaj pom qhov ua kom tsis raug raws li I / O yuam kev: tsis yog kev sau nqi (kev cia siab: 0x2abc3894; tseeb: 0x2ebe208e). Nws tshwm sim thaum nyeem ntawv ntawm nplooj ntawv (1: 1) hauv database ID 12 ntawm kev suav 0x00000000002000 hauv cov ntaub ntawv 'xxx.mdf'. Cov lus qhia ntxiv hauv SQL Server log cav yuam kev lossis cov txheej xwm kaw lus yuav qhia ntau yam. Qhov no yog qhov ua yuam kev loj heev uas cuam tshuam rau database kev ncaj ncees thiab yuav tsum raug kho tam sim. Ua kom tiav qhov kev txheeb xyuas tag nrho cov ntaub ntawv (DBCC CHECKDB). Qhov kev ua yuam kev no tuaj yeem tshwm sim los ntawm ntau yam; rau cov lus qhia ntxiv, saib SQL Server Phau Ntawv Online (Microsoft SQL Server, Yuam Kev: 824)

qhov twg 'xxx.mdf' yog lub npe MDF cov ntaub ntawv nkag mus.

Qee zaum koj .MDF cov ntaub ntawv khaws cia yuav txuas nrog zoo. Txawm li cas los xij, thaum koj sim ua ib nqe lus SQL, xws li

XAIV * LOS [TestDB]. [Dbo]. [Test_table_1]

koj tseem yuav tau txais cov lus sau yuam kev saum toj saud.

Screenshot ntawm cov lus yuam:

Nqe Lus Qhia Tshwj Xeeb:

Cov ntaub ntawv hauv MDF cov ntaub ntawv khaws cia ua nplooj ntawv, txhua nplooj ntawv yog 8KB. Ib nplooj ntawv twg muaj nyob ntawm yeem sau hais txog tas.

If SQL Server pom cov checksum qhov tseem ceeb hauv qee cov nplooj ntawv cov ntsiab lus tsis raug, ces nws yuav qhia qhov kev ua yuam kev no.

Koj tuaj yeem siv peb cov khoom DataNumen SQL Recovery kom rov qab tau cov ntaub ntawv los ntawm cov ntawv tsis txaus siab MDF thiab daws cov kev ua yuam kev no.

Qauv Ntaub Ntawv:

Qauv piv txwv MDF cov ntaub ntawv uas yuav ua rau muaj qhov yuam kev:

SQL Server version Corrupt MDF cov ntaub ntawv MDF ntawv tsau los ntawm DataNumen SQL Recovery
SQL Server 2005 Yuam Kev4_1.mdf Yuam Kev4_1_fixed.mdf
SQL Server 2008 R2 Yuam Kev4_2.mdf Yuam Kev4_2_fixed.mdf
SQL Server 2012 Yuam Kev4_3.mdf Yuam Kev4_3_fixed.mdf
SQL Server 2014 Yuam Kev4_4.mdf Yuam Kev4_4_fixed.mdf