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:
Msg 824, Qib 24, 2 Xeev, Kab 2
SQL Server kuaj pom qhov ua kom tsis raug raws li I / O yuam kev: tsis yog pageid (xav tias 1: 143; tiag tiag 0: 9). Nws tau tshwm sim thaum nyeem ntawm nplooj ntawv (1: 143) hauv database ID 39 ntawm kev suav 0x0000000011e000 hauv cov ntawv 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.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 3313, Qib 21, 1 Xeev, Kab 2
Thaum lub sij hawm rov ua qhov kev sib koom ua haujlwm hauv database 'Error1', muaj qhov yuam kev tshwm sim ntawm cov ntaub ntawv sau ID (135: 752: 2). Feem ntau, cov haujlwm tsis ua haujlwm yav dhau los yog qhov kev nkag uas yog qhov yuam kev hauv Windows Event Log service. Rov qab cov ntaub ntawv los ntawm cov thaub qab tag nrho, lossis kho cov ntaub ntawv.
Msg 3414, Qib 21, 1 Xeev, Kab 2
Ib qho yuam kev tshwm sim thaum rov qab los, tiv thaiv cov ntaub ntawv 'Error1' (39: 0) ntawm restarting. Kuaj qhov rov ua yuam kev thiab kho lawv, lossis rov qab los ntawm cov thaub qab zoo. Yog tias qhov uas tsis raug kho tsis raug lossis xav kom ua tiav, hu rau Cov Neeg Pab Txhawb.
Msg 824, Qib 24, 2 Xeev, Kab 2
SQL Server kuaj pom qhov ua kom tsis raug raws li I / O yuam kev: tsis yog pageid (xav tias 1: 160; tiag tiag 0:41). Nws tau tshwm sim thaum nyeem ntawm nplooj ntawv (1: 160) hauv database ID 39 ntawm kev suav 0x00000000140000 hauv cov ntaub ntawv 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.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, 2 Xeev, Kab 4
SQL Server kuaj pom qhov ua kom tsis raug raws li I / O yuam kev: tsis yog pageid (xav tias 1: 160; tiag tiag 0:41). Nws tau tshwm sim thaum nyeem ntawm nplooj ntawv (1: 160) hauv database ID 39 ntawm kev suav 0x00000000140000 hauv cov ntaub ntawv 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.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 'Error1' yog lub npe ntawm tus tsis ncaj MDF database tau raug kho.
Wb 3313 qhia tias lub cav tsis tuaj yeem ua tau.
Screenshot ntawm cov lus yuam:
Nqe Lus Qhia Tshwj Xeeb:
Thaum CHECKDB tsis tuaj yeem ua haujlwm hauv lub cev, nws yuav hais qhia cov lus yuam kev Wb 3313 thiab sim kho qhov tsis. Yog tias nws tsis tuaj yeem txhim kho qhov ua yuam kev, tom qab kev rov qab ua tsis tiav thiab yuav ua rau muaj qhov yuam kev ntau ntxiv, xws li Msg 3414 thiab Msg 824.
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 tus Wb 3313 kev ua yuam kev:
| SQL Server version | Corrupt MDF cov ntaub ntawv | MDF ntawv tsau los ntawm DataNumen SQL Recovery |
| SQL Server 2014 | Yuam Kev9.mdf | Yuam Kev9_fixed.mdf |