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 pov thawj raws li I / O yuam kev: nplooj ntawv nraus (xav kom kos npe: 0x ########; kos npe tiag tiag: 0x #######) Nws tshwm sim thaum nyeem ntawv ntawm nplooj ntawv (#: #) hauv database ID # ntawm kev txiav txim ### hauv cov ntaub ntawv 'xxxx.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.

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. SQL Server siv ob qho txheej txheem los ua kom paub tseeb tias kev sib xyaw thiab kev koom ua ke ntawm cov ntaub ntawv hauv nplooj ntawv, uas yog, nplooj saus los sis nplooj ntawv nraus. Ob leeg puav leej xaiv tau.

If SQL Server pom cov nplooj ntawv torn rau qee cov nplooj ntawv cov ntaub ntawv tsis raug, tom qab ntawv nws yuav hais 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 Kev5_1.mdf Yuam Kev5_1_fixed.mdf
SQL Server 2008 R2 Yuam Kev5_2.mdf Yuam Kev5_2_fixed.mdf
SQL Server 2012 Yuam Kev5_3.mdf Yuam Kev5_3_fixed.mdf
SQL Server 2014 Yuam Kev5_4.mdf Yuam Kev5_4_fixed.mdf