Whakaora i te Paru SQL Server MDF Database

A, no te koe SQL Server Kei te kino te putunga korero MDF, ka taea e koe te whakamahi i nga tikanga e whai ake nei hei whakahoki mai i nga raraunga o roto, hei whakaiti i te ngaro:

Panui: I mua i te whakahaere i nga mahi whakaora raraunga, me whakahoki e koe o konae MDF & NDF ki te kopae.

Ko te tuatahi, ka taea e koe te whakamatautau SQL Server whakahau hanga-i roto i DBCC CHECKDB ki te whakahoki mai i to papaarangi. Ki te whakaaro ko te konae paetukutuku kino he 'MyDatabase.mdf', ka taea ai e koe te whai ake hei whakaora i nga raraunga o roto:
1. Restart SQL Server.
2. Kaua e mahi i tetahi mahi.
3. In SQL Server Whakahaere Studio, mahia nga korero SQL e whai ake nei:
```
Whakamahia te korero a te rangatira @databasename varchar (255) set @ databasename = 'MyDatabase.mdf' exec sp_dboption @databasename, N'single ', N'true' - Whakatauhia te papaunga raraunga ki te aratau kaiwhakamahi-kotahi arowhai dbcc (@ databasename, REPAIR_ALLOW_DATA_LOSS ) dbcc checkdb (@ databasename, REPAIR_REBUILD) exec sp_dboption @databasename, N'single ', N'false' - Whakaritehia te papaapu korero ki te aratau kaiwhakamahi-maha
```
  Te korero
```
dbcc checkdb (@ databasename, REPAIR_ALLOW_DATA_LOSS)
```
  ka ngaro pea etahi o nga tuhinga i to papaarangi ka mahi koe i te mahi whakatika.
  
  Ahakoa te korero
```
dbcc checkdb (@ databasename, REPAIR_REBUILD)
```
  KAORE e ngaro tetahi raru i te wa e whakatika ana, engari he nui ake te waa.
  
  Na mena kaore koe i te akiaki, ka taea e koe te tarai i te korero tuarua dbcc checkdb noa iho, mena kaore e taea e taua korero te whakahoki mai i te putunga raraunga, ka taea ai e koe te mahi i nga whakahau tuatahi me te tuarua o te tohu arowhai.
  
  I muri i te mahi whakatika, ka taea e koe te waea
```
dbcc checkdb ('MyDatabase.mdf')
```
  ano kia kite mena kua pumau te putunga korero kaore ranei.
  
  Ko nga korero taipitopito mo te whakahau dbcc checkdb ka kitea i https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver15
Mena i muri i te whakamahinga i te tikanga 1, kei te ripoata tonu te dbcc checkdb i etahi teepu, ka taea e koe te whakamatautau SQL Server whakahau-i roto i te DBCC PANUI KAUPAPA ki te whakahoki mai i enei teepu i to papaanga. Ki te whakaaro ko te konae paetukutuku kino he 'MyDatabase.mdf' ana ko te teepu e hiahia ana koe ki te whakatika ko te 'MyTable', ka taea ai e koe te whai ake hei whakatika i a ia:
1. Restart SQL Server.
2. Kaua e mahi i tetahi mahi.
3. In SQL Server Whakahaere Studio, mahia nga korero SQL e whai ake nei:
```
whakamahia te MyDatabase.mdf whakapuaki @dbname varchar (255) set @ dbname = 'MyDatabase.mdf' exec sp_dboption @ dbname, 'kaiwhakamahi kotahi', 'pono' papaaho papaaho ('MyTable', REPAIR_ALLOW_DATA_LOSS) teepu taki dbcc ('MyTable'RERWAI ) exec sp_dboption @ dbname, 'kaiwhakamahi kotahi', 'teka'
```
  Te korero
```
teepu takiuru dbcc ('TakuTable', REPAIR_ALLOW_DATA_LOSS)
```
  ka ngaro pea etahi korero i to teepu ka mahia te mahi whakatika.
  
  Ahakoa te korero
```
teepu takiuru dbcc ('TakuTable', REPAIR_REBUILD)
```
  KAORE e ngaro tetahi raru i te wa e whakatika ana, engari he nui ake te waa.
  
  Na mena kaore koe i te akiaki, ka taea e koe te tarai i te tuatahi ki te whakahoki i te tauwehenga takirua dbcc anake, mena kaore e taea e taua korero te whakahoki mai i te papaarangi, ka taea ai e koe te mahi i nga otaota tuatahi me te tuarua o te otaota.
  
  Ka oti ana i a koe te mahi whakatika mo nga teepu kino katoa, ka taea e koe te waea
```
dbcc checkdb ('MyDatabase.mdf')
```
  ano kia kite mena kua mau nga teepu i roto i te putunga korero kaore ranei.
Ka kitea nga korero taipitopito mo te whakahau teepu dbcc i https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checktable-transact-sql?view=sql-server-ver15
Mena kaore e taea e te tikanga 1 me te 2 te whakatika i te papaarangi kino kino, i nga teepu ranei, mena kaore e taea e enei tikanga te whakahoki mai i nga raraunga e hiahia ana koe, ka taea te whakamahi DataNumen SQL Recovery ki te whakahoki mai i nga raraunga mai i to papaarangi MDF.