Xa usebenzisa iMicrosoft SQL Server ukuncamathela okanye ukufikelela kwifayile yesiseko sedata eyonakeleyo ye MDF, ungadibana nemiyalezo yemposiso eyahlukeneyo enokubhideka. Ngezantsi, siza kudwelisa zonke iimpazamo, zihlelwe ngokuphindaphindiweyo. Ngempazamo nganye, siya kuchaza iimpawu zayo, sichaze eyona sizathu, kwaye sinikezele ngeefayile zesampulu kunye neefayile ezilungisiweyo. DataNumen SQL Recovery. Oku kuya kukunceda uziqonde ngcono ezi mpazamo. Qaphela 'xxx.MDF' iya kumela igama lorhwaphilizo lwakho SQL Server Ifayile yedatha yeMDF.
Ngenxa ye SQL Server okanye CHECKDB imiyalezo yemposiso, kukho iintlobo ezintathu zeempazamo:
-
- Iimpazamo zolwabiwo: Siyazi ukuba idatha kwiifayile ze-MDF kunye ne-NDF zabiwe njenge Maphepha. Kwaye kukho amaphepha akhethekileyo asetyenziselwa ulawulo lolwabiwo, ngolu hlobo lulandelayo:
Uhlobo Lwephepha | inkcazelo |
Iphepha le-GAM | Gcina imephu yelizwe jikelele yolwabiwo(GAM) ulwazi. |
Iphepha le-SGAM | Gcina ulwazi lwemephu yolwabiwo lwehlabathi (SGAM) |
Iphepha le-IM | Gcina isalathiso semephu yolwabiwo(IAM) ulwazi. |
Iphepha lePFS | Gcina ulwazi lolwabiwo lwePFS. |
Ukuba nawaphi na kula maphepha angentla aneempazamo, okanye idatha elawulwa ngala maphepha olwabiwo ayihambelani nolwazi lolwabiwo, ngoko ke SQL Server okanye i-CHECKDB iya kuxela iimpazamo zolwabiwo.
- Iimpazamo zokungqinelana: kuba Maphepha ezisetyenziswa ukugcina idatha, kuquka amaphepha edatha kunye namaphepha esalathiso, ukuba SQL Server okanye i-CHECKDB ifumana nakuphi na ukungangqinelani phakathi kwemixholo yephepha kunye netshekhisum, emva koko baya kuxela iimpazamo zokuhambelana.
- Zonke ezinye iimpazamo: Kusenokubakho ezinye iimpazamo ezingaweliyo kwezi ndidi zimbini zingasentla.
- xxxx.mdf asiyofayile yesiseko sesiseko. (uMicrosoft SQL Server, impazamo: 5171)
- Umbhalo ongasentla kwekhasi wefayile 'xxxx.mdf' ayingomxholo wefayile yedata esebenzayo. Ifayile yeSIZE yeFILE ayichanekanga.(Microsoft SQL Server, impazamo: 5172
- SQL Server kuchongwe impazamo ye-I/O esekwe ngokwengqiqo: itshekhim engalunganga
- SQL Server kuchonge impazamo ye-I/O esekwe kwingqiqo: iphepha elikrazukileyo
- Ucima ezinye iirekhodi okanye ezinye iitafile kwisiseko sedatha ngempazamo.
SQL Server inesixhobo esakhelwe ngaphakathi esibizwa I-DBCC, eye I-CHECKDB kwaye I-CHECKTABLE iinketho ezinokunceda ukulungisa i-database ye-MDF eyonakele. Nangona kunjalo, kwiifayile zedatha ye-MDB ezonakalisiweyo, DBCC CHECKDB kwaye I-CHECKTABLE nayo iya kusilela.
Iimpazamo zokungqinelana okuxelwe yi-CHECKDB:
- SQL Server kuchongwe impazamo ye-I/O esekwe ngokwengqiqo: itshekhim engalunganga
- Umqolo okwi-sys.xxx awunamqolo othelekisekayo kwi-sys.xxx.
- Impazamo yetheyibhile: I-ID yento ##, i-ID yesalathiso ## iza kuphinda yakhiwe.
- Le index yetafile ayinakwenziwa kwakhona.
- Object ID ##, index ID ##, partition ID ##, alloc unit ID ## (uhlobo olungaziwa), i-ID yephepha (##:560) iqulethe i-ID yephepha engachanekanga kwiphepha layo elingasentla.
Iimpazamo zolwabiwo ezixelwe yi-CHECKDB:
- IMaphu yoLwabiwo lweSalathiso (IAM) Iphepha lalathelwe kwiSalathi esilandelayo sePhepha le-IAM
- Ubungakanani (##:##) kwi-database ye-ID ## iphawulwe yabelwe i-GAM, kodwa akukho SGAM okanye i-IAM eyabileyo.
Zonke ezinye iimpazamo ezixelwe yi-CHECKDB:
- Akuphumelelanga:(-#######) Ukwenza umbuzo “DBCC CHECKDB(xxxx) NGE NO_INFOMSGS” akuphumelelanga ngale mpazamo ilandelayo: “xxxx”.
- I/O imposiso (i-ID yephepha elibi) ichongiwe ngexesha lokufunda kwi-offset 0x####### kwifayile 'xxxx.mdf'.
- Inkqubo Ayikwazanga Ukuvula okwaneleyo kwiDatabase ukuze yakhiwe kwakhona iLog
- Ilahleko yeDatha xa Ulungiswa nge-CHECKDB
- Ifayile ibonakala inqunyulwe yinkqubo yokusebenza.
- Ngexesha lokuphinda kwenziwe umsebenzi ofakiweyo kuvimba weenkcukacha 'xxxx', kwenzeke impazamo kwirekhodi ye-ID.