Rov qab C corrupt SQL Server MDF Cov Ntaub Ntawv

thaum koj SQL Server MDF lub hauv paus ua tsis ncaj, koj tuaj yeem siv cov hauv qab no los khaws cov ntaub ntawv hauv nws, kom txo qhov poob:

Nco tseg: Ua ntej ua cov ntaub ntawv rov qab ua haujlwm, thov koj kho koj cov MDF & NDF cov ntaub ntawv khaws tseg ua ntej.

Ua ntej tshaj plaws, koj tuaj yeem sim SQL Server built-in hais kom ua DBCC CHECKDB kom rov qab koj cov ntaub ntawv. Piv txwv tias yog cov ntaub ntawv tsis raug ntawm cov ntawv pov thawj yog 'MyDatabase.mdf', tom qab ntawd koj tuaj yeem ua raws li hauv qab no los rov qab cov ntaub ntawv hauv nws:
1. Restart SQL Server.
2. Tsis txhob ua ib yam haujlwm.
3. In SQL Server Tswj Studio, ua cov nqe lus SQL nram qab no:
```
siv tus tswv tshaj tawm @databasename varchar (255) teev @ databasename = 'MyDatabase.mdf' exec sp_dboption @databasename, N'single ', N'true' - Teem chaw rau cov chaw khaws ntaub ntawv rau ib leeg siv hom dbcc checkdb (@ databasename, REPAIR_ALLOW_DATA_LOSS ) dbcc checkdb (@ databasename, REPAIR_REBUILD) exec sp_dboption @databasename, N'single ', N'false' - Teem chaw rau cov chaw khaws ntaub ntawv rov qab mus rau ntau hom neeg siv hom
```
  Lub ntsiab lus
```
dbcc checkdb (@ databasename, REPAIR_ALLOW_DATA_LOSS)
```
  tej zaum yuav ua rau qee qhov poob ntawm koj cov ntaub ntawv thaum ua lub sijhawm kho.
  
  Thaum lub ntsiab lus
```
dbcc checkdb (@ databasename, REPAIR_REBUILD)
```
  yuav TSIS ua rau cov ntaub ntawv poob thaum lub sijhawm kho, tab sis nws siv sijhawm ntau.
  
  Yog li yog tias koj tsis maj, koj tuaj yeem sim ua thawj daim dbcc checkdb thib ob nkaus xwb, yog tias nqe lus no tsis tuaj yeem pab ua kom rov qab khaws cov ntaub ntawv, ces koj tuaj yeem ua thawj thiab thib dbcc checkdb lus txib.
  
  Tom qab kho cov haujlwm tiav, koj tuaj yeem hu xov tooj
```
dbcc checkdb ('MyDatabase.mdf')
```
  rov mus saib seb lub hauv paus hloov kho lossis tsis.
  
  Cov ncauj lus kom ntxaws ntxiv txog dbcc checkdb cov lus txib tuaj yeem pom ntawm https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver15
Yog tias tom qab siv txoj kev 1, dbcc checkdb tseem qhia txog qhov yuam kev hauv qee cov ntxhuav, koj tuaj yeem sim SQL Server built-in hais kom ua DBCC CHECKTABLE kom rov zoo cov ntxhuav hauv koj lub chaw khaws ntaub ntawv. Piv txwv tias yog cov ntaub ntawv tsis raug ntawm cov ntaub ntawv yog 'MyDatabase.mdf' thiab lub rooj koj xav kho yog 'MyTable', tom qab ntawd koj tuaj yeem ua raws li hauv qab los kho nws:
1. Restart SQL Server.
2. Tsis txhob ua ib yam haujlwm.
3. In SQL Server Tswj Studio, ua cov nqe lus SQL nram qab no:
```
siv MyDatabase.mdf tshaj tawm @dbname varchar (255) teeb @ dbname = 'MyDatabase.mdf' exec sp_dboption @ dbname, 'ib tus neeg siv', 'tseeb' dbcc checktable ('MyTable', REPAIR_ALLOW_DATA_LOSS) dbcc checktable ('MyTable', REPAIR_REBUIL ) exec sp_dboption @ dbname, 'ib tus neeg siv', 'cuav'
```
  Lub ntsiab lus
```
dbcc checktable ('MyTable', REPAIR_ALLOW_DATA_LOSS)
```
  tej zaum yuav ua rau poob qee cov ntaub ntawv hauv koj lub rooj thaum ua cov haujlwm kho.
  
  Thaum lub ntsiab lus
```
dbcc checktable ('MyTable', KHO-LEEJ TWG)
```
  yuav TSIS ua rau cov ntaub ntawv poob thaum lub sijhawm kho, tab sis nws siv sijhawm ntau.
  
  Yog li yog tias koj tsis maj, koj tuaj yeem sim ua thawj daim dbcc checktable thib ob nkaus xwb, yog tias nqe lus no tsis tuaj yeem pab ua kom rov qab khaws cov ntaub ntawv, tom qab ntawd koj tuaj yeem ua thawj thiab thib dbcc checktable lus.
  
  Tom qab koj ua tiav kev tsim kho kom tiav rau tag nrho cov ntxhuav tsis huv, koj tuaj yeem hu xov tooj
```
dbcc checkdb ('MyDatabase.mdf')
```
  rov mus saib seb lub rooj nyob hauv cov chaw khaws ntaub ntawv puas muab hloov pauv.
Cov lus qhia ntxaws ntxiv txog dbcc checktable cov lus qhia tuaj yeem pom ntawm https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checktable-transact-sql?view=sql-server-ver15
Yog tias txoj kev 1 thiab 2 tseem tsis tuaj yeem kho qhov chaw tsis muaj npe lossis cov ntxhuav, lossis yog tias cov hauv kev no tsis tuaj yeem rov qab tau cov ntaub ntawv koj xav tau, ces koj tuaj yeem siv DataNumen SQL Recovery kom rov qab cov ntaub ntawv los ntawm koj cov MDF database.