Cov tsos mob:
Thaum siv DBCC CHECKDB nrog REPAIR_ALLOW_DATA_LOS parameter los kho qhov tsis ncaj .MDF database, zoo li no:
DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')
koj pom cov lus yuam kev li hauv qab no:
DBCC cov txiaj ntsig rau 'xxxx'.
CHECKDB pom 0 faib teeb meem yuam kev thiab 0 muaj tseeb tsis suav hauv database 'xxxx'.
Msg 824, Qib 24, 2 Xeev, Kab 8
SQL Server kuaj pom tias muaj tseeb li tsis raug I / O yuam kev: tsis yog kev sau nqi (kev cia siab: 0xea8a9a2f; tseeb: 0x37adbff8). Nws tshwm sim thaum nyeem ntawv ntawm nplooj ntawv (1:28) hauv database ID 39 ntawm kev suav 0x00000000038000 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 'xxxx.mdf' yog lub npe ntawm cov tsis ncaj MDF cov ntaub ntawv raug kho. Txawm hais tias CHECKDB hais
CHECKDB pom 0 faib teeb meem yuam kev thiab 0 muaj tseeb tsis suav hauv database 'xxxx'.
Qhov no tseem tseem zoo sib xws yuam kev (Wb 824) hauv cov ntaub ntawv.
Screenshot ntawm cov lus yuam:
Yog tias kev noj nyiaj txiag yog loj, ces yuav muaj cov lus qhia tsis tu ncua (Wb 824), raws li hauv qab no:
Msg 824, Qib 24, 6 Xeev, Kab 2 SQL Server kuaj pom qhov ua kom tsis raug raws li I / O yuam kev: tsis yog kev sau nqi (kev cia siab: 0x3d17dfef; tseeb: 0xd81748ef). Nws tau tshwm sim thaum nyeem ntawm nplooj ntawv (1: 0) hauv database ID 39 ntawm kev them nyiaj 0000000000000000 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.
Msg 824, Qib 24, 6 Xeev, Kab 4 SQL Server kuaj pom qhov ua kom tsis raug raws li I / O yuam kev: tsis yog kev sau nqi (kev cia siab: 0x3d17dfef; tseeb: 0xd81748ef). Nws tau tshwm sim thaum nyeem ntawm nplooj ntawv (1: 0) hauv database ID 39 ntawm kev them nyiaj 0000000000000000 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 'xxxx.mdf' yog lub npe ntawm cov tsis ncaj MDF cov ntaub ntawv raug kho.
Screenshot ntawm cov lus yuam:
Yog hais tias kev noj nyiaj txiag yuav ua ntau dua, koj yuav pom Wb 7909 raws li nram no Wb 824:
DBCC cov txiaj ntsig rau 'xxxx'.
CHECKDB pom 0 faib teeb meem yuam kev thiab 0 muaj tseeb tsis suav hauv database 'xxxx'.
Msg 824, Qib 24, 2 Xeev, Kab 8
SQL Server kuaj pom qhov ua kom tsis raug raws li I / O yuam kev: tsis yog kev sau nqi (kev cia siab: 0xcfcd2118; tseeb: 0x6fc599d6). Nws tshwm sim thaum nyeem ntawm nplooj ntawv (1: 1) hauv database ID 39 ntawm kev suav 0x00000000002000 hauv cov 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.
Msg 7909, Qib 20, 1 Xeev, Kab 8
Txoj kev kho thaum muaj xwm ceev-ua tsis tiav.Koj yuav tsum rov qab los ntawm thaub qab.
qhov twg 'xxxx' yog lub npe database thiab 'xxxx.mdf' yog cov database lub npe cov ntaub ntawv npe.
Ceeb toom Wb 7909 yog qhov yuam kev loj heev uas yuav tshwm sim rau ntau lub sijhawm thaum twg SQL Server xav tias qhov database dhau dhau txoj kev rov qab.
Screenshot ntawm cov lus yuam:
Nqe Lus Qhia Tshwj Xeeb:
Cov ntaub ntawv nyob rau hauv MDF cov ntaub ntawv raug khaws cia ua 8KB nplooj ntawvCov. Ib nplooj ntawv twg muaj nyob ntawm yeem sau hais txog tas.
Yog hais tias DBCC CHECKDB cov lus txib pom cov checksum qhov tseem ceeb hauv cov nplooj ntawv header, PFS nplooj ntawv thiab qee cov nplooj ntawv cov ntaub ntawv tsis raug thiab nws tsis tuaj yeem kho qhov teeb meem, ces nws yuav qhia qhov kev ua yuam kev no (Wb 824)). Yog hais tias lub siab tsis ncaj ncees hnyav, tej zaum yuav muaj tas mus li erros (Wb 824) lossis ua raws lwm tus yuam kev (Wb 7909).
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:
Cov qauv ua tsis zoo MDF cov ntaub ntawv uas yuav ua rau muaj qhov yuam kev (Tib Msg 824 yuam kev):
| SQL Server version | Corrupt MDF cov ntaub ntawv | MDF ntawv tsau los ntawm DataNumen SQL Recovery |
| SQL Server 2014 | Yuam Kev1_3.mdf | Yuam Kev1_3_fixed.mdf |
Cov qauv ua tsis zoo MDF cov ntaub ntawv uas yuav ua rau muaj qhov yuam kev (Nruam Msg 824 yuam kev):
| SQL Server version | Corrupt MDF cov ntaub ntawv | MDF ntawv tsau los ntawm DataNumen SQL Recovery |
| SQL Server 2014 | Yuam Kev1_1.mdf | Yuam Kev1_1_fixed.mdf ib |
Cov qauv ua tsis zoo MDF cov ntaub ntawv uas yuav ua rau muaj qhov yuam kev (Msg 824 yuam kev ua raws Msg 7909 yuam kev):
| SQL Server version | Corrupt MDF cov ntaub ntawv | MDF ntawv tsau los ntawm DataNumen SQL Recovery |
| SQL Server 2014 | Yuam Kev1_2.mdf | Yuam Kev1_2_fixed.mdf |