Xa usebenzisa iMicrosoft SQL Server Ukuncamathisela okanye ukufikelela kwifayile yedatha yedatha eyonakeleyo ye-MDF, uya kubona imiyalezo yeempazamo eyahlukeneyo, enokudida yona. Ke ngoko, apha siza kuzama ukudwelisa zonke iimpazamo ezinokubakho, zilungiswe ngokwamaxesha aqhubekayo. Kwimpazamo nganye, siza kuchaza uphawu lwayo, sichaze isizathu sayo kwaye sinike iifayile zesampulu kunye nefayile emiselweyo DataNumen SQL Recovery, ukuze ube nokuziqonda ngcono. Apha ngezantsi siza kusebenzisa 'i-xxx.MDF' ukubonisa ukonakala kwakho SQL Server Igama lefayile ledatha ye-MDF.
Ngenxa ye SQL Server okanye imiyalezo yempazamo ye-CHECKDB, zintathu iintlobo zeempazamo eziza kubangela ukusilela:

    1. Iimpazamo zolwabiwo: Siyazi ukuba idatha kwiifayile ze-MDF kunye ne-NDF zabelwe njenge Maphepha. Kwaye kukho amanye amaphepha akhethekileyo asetyenziselwa ulawulo lolwabiwo, ngolu hlobo lulandelayo:
Uhlobo lwekhasi inkcazelo
Iphepha leGAM Gcina ulwazi lwemephu yolwabiwo lwehlabathi (GAM) info.
Ikhasi leSGAM Gcina ulwazi ekwabelwana ngalo ngemephu yolwabiwo lwehlabathi (SGAM).
Iphepha le-IAM Gcina isalathiso semephu yolwabiwo (IAM) ulwazi.
Iphepha lePFS Gcina ulwazi lolwabiwo lwe-PFS.

Ukuba amanye amaphepha olwabelo angentla aneempazamo, okanye idatha elawulwa ngala maphepha olwabelo ayingqinelani nolwazi lolwabiwo, SQL Server okanye i-CHECKDB iya kunika ingxelo iimpazamo zolwabiwo.

  • Iimpazamo zokungaguquguquki: kuba Maphepha ezisetyenziselwa ukugcina idatha, kubandakanya amaphepha edatha kunye namaphepha esalathiso, ukuba SQL Server okanye i-CHECKDB ifumana nakuphi na ukungangqinelani phakathi komxholo wephepha kunye ne-checksum, emva koko baya kunika ingxelo ukungqinelana kweempazamo.
  • Zonke ezinye iimpazamo: Kukho ezinye iimpazamo ezingangeni kula macandelo mabini angentla.

 

SQL Server inesixhobo esakhelwe-ngaphakathi esibizwa ngokuba I-DBCC, eye I-CHECKDB kwaye UKUJONGWA iinketho ezinokunceda ukulungisa isiseko sedatha seMDF. Nangona kunjalo, kwiifayile zedatha eyonakeleyo ye-MDB, I-DBCC CHECKDB kwaye UKUJONGWA ziya kusilela.

Iimpazamo zokungaguquguquki ezichazwe yi-CHECKDB:

Ulwabiwo lweempazamo ezichazwe yi-CHECKDB:

Zonke ezinye iimpazamo ezichazwe yi-CHECKDB: