Dzorera Uori SQL Server MDF Database

kana iwe SQL Server MDF dhatabhesi ine huori, unogona kushandisa nzira dzinotevera kudzoreredza iyo data mairi, kuderedza kurasikirwa:

Ongorora: Usati waita chero data rekudzoreredza mashandiro, ndapota chengetedza mafaera ako ane huori MDF & NDF dhatabhesi kutanga.

Chokutanga pane zvose, unogona kuedza SQL Server kuraira-mukati DBCC CHECKDB kudzoreredza database yako. Tichifunga kuti iyo yakaora dhatabhesi faira ndeye 'MyDatabase.mdf', saka iwe unogona kuita zvinotevera kudzoreredza iyo data mukati maro:
1. Restart SQL Server.
2. Usaite chero maoparesheni.
3. In SQL Server Management Studio, ita zvinotevera SQL zvirevo:
```
shandisa master declare @databasename varchar(255) set @databasename='MyDatabase.mdf' exec sp_dboption @databasename, N'single', N'true' -- Seta dhatabhesi rekuenda kune mumwe-mushandisi modhi dbcc checkdb(@databasename,REPAIR_DOSE_ ) dbcc checkdb(@databasename,REPAIR_REBUILD) exec sp_dboption @databasename, N'single', N'false' -- Seta dhatabhesi rekuenda kumashure kune akawanda-mushandisi maitiro
```
  Chirevo
```
dbcc checkdb(@databasename,REPAIR_ALLOW_DATA_LOSS)
```
  zvinogona kukonzera kurasikirwa kweimwe data mudhatabhesi yako kana uchiita basa rekugadzirisa.
  
  Nepo chirevo
```
dbcc checkdb(@databasename,REPAIR_REBUILD)
```
  HAZVICHAZOkonzeresa kurasikirwa kwedata panguva yekugadzirisa, asi zvinotora nguva yakawanda.
  
  Saka kana usiri wekukurumidzira, unogona kutanga waedza kuita yechipiri dbcc checkdb statement chete, kana chirevo ichocho chisingakwanisi kubatsira kudzoreredza dhatabhesi, saka unogona kuita yekutanga neyechipiri dbcc checkdb mirairo.
  
  Mushure mekugadzirisa kushanda, unogona kudana
```
dbcc checkdb('MyDatabase.mdf')
```
  zvakare kuti uone kana dhatabhesi yakagadziriswa kana kwete.
  
  Rumwe ruzivo rwakadzama nezve dbcc checkdb command inogona kuwanikwa pa https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver15
Kana mushure mekushandisa nzira yekutanga, dbcc checkdb ichiri kushuma kukanganisa mune mamwe matafura, unogona kuedza SQL Server yakavakirwa-mukati yekuraira DBCC CHECKTABLE kudzoreredza aya matafura mudhatabhesi rako. Tichifunga kuti faira redhatabhesi rine huwori i'MyDatabase.mdf' uye tafura yaunoda kugadzirisa i'MyTable', wobva wagona kuita zvinotevera kuigadzirisa:
1. Restart SQL Server.
2. Usaite chero maoparesheni.
3. In SQL Server Management Studio, ita zvinotevera SQL zvirevo:
```
shandisa MyDatabase.mdf declare @dbname varchar(255) set @dbname='MyDatabase.mdf' exec sp_dboption @dbname,'single user','true' dbcc checktable('MyTable',REPAIR_ALLOW_DATA_LOSStable),'REPAIR_DATA_LOSS (ILDE_LOSS) ) exec sp_dboption @dbname,'single user','false'
```
  Chirevo
```
dbcc checktable('MyTable',REPAIR_ALLOW_DATA_LOSS)
```
  inogona kukonzera kurasikirwa kweimwe data mutafura yako kana uchiita basa rekugadzirisa.
  
  Nepo chirevo
```
dbcc checktable('MyTable',REPAIR_REBUILD)
```
  HAZVICHAZOkonzeresa kurasikirwa kwedata panguva yekugadzirisa, asi zvinotora nguva yakawanda.
  
  Saka kana usiri wekukurumidzira, unogona kutanga waedza kuita yechipiri dbcc cheki chirevo chete, kana chirevo ichocho chisingakwanisi kubatsira kudzoreredza dhatabhesi, saka unogona kuita yekutanga neyechipiri dbcc checktable mirairo.
  
  Mushure mekunge mapedza basa rekugadzirisa kune ese matafura ane huori, unogona kufona
```
dbcc checkdb('MyDatabase.mdf')
```
  zvakare kuti uone kana matafura ari mudhatabhesi akagadziriswa kana kwete.
Rumwe ruzivo rwakadzama nezve dbcc checktable command inogona kuwanikwa pa https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checktable-transact-sql?view=sql-server-ver15
Kana nzira 1 uye 2 ichiri kusakwanisa kugadzirisa dhatabhesi yakaora kana matafura, kana nzira idzi dzisingakwanisi kudzoreredza data raunoda, unogona kushandisa. DataNumen SQL Recovery kuti uwanezve data kubva kune yako MDF database.