Uyilungisa njani ifayile yeMDF kwi SQL Server: IsiKhokelo esipheleleyo (2025)

Iifayile ze-MDF ziziseko ze SQL ServerIndlela yogcino lwedatha. La macandelo abalulekileyo adinga ubhaqo olukhawulezayo kunye neendlela ezifanelekileyo zokubuyisela xa zonakele ukunciphisa ilahleko yedatha. Masifunde malunga neefayile ze-MDF kunye nendlela yokulungisa iifayile ze-MDF ezonakalisiweyo.

1.1 Yintoni ifayile ye-MDF eku SQL Server?

I-MDF (iFayile yeDatha yeDatha eyiNtloko) isebenza njengeyona fayile yedatha ephambili kwi SQL Server egcina yonke idatha yomsebenzisi efana neetafile, izalathisi, iinkqubo ezigciniweyo, iimbono, kunye nezinye izinto zesiseko sedatha. Le fayile ine-schema kunye nedatha eyiyo, eyenza ibe yi-most inxalenye ebalulekileyo nayiphi na SQL Server idatabase. Ulwandiso lwe-.mdf luchonga le fayile engundoqo esebenza kunye neefayile zelog (.ldf). Ezi fayile zelog zilandelela ulwazi lwentengiselwano olufunekayo kwimisebenzi yokubuyisela.

1.2 Izizathu eziqhelekileyo zoRhwaphilizo lweFayile ye-MDF

Iifayile zakho zeMDF zingonakala ngenxa yezizathu ezininzi:

Ukucima kombane okanye ngokungafanelekanga SQL Server ukuvalwa
Ukusilela kwehardware, ngakumbi iingxaki zesistim esezantsi yogcino
Amacandelo amabi kwi-drive yokugcina
I-Malware okanye uhlaselo lwentsholongwane kwiinkqubo ezingakhuselekanga
Iimpazamo zesixokelelwano sefayile ezichaphazela ugcino lwedatha
Iibugs zesoftware SQL Server ngokwayo

Ukuphazamiseka kwenkqubo ngexesha lemisebenzi yedatha esebenzayo kunokunyusa umngcipheko worhwaphilizo kakhulu kuba banokumisa imisebenzi ebalulekileyo yokubhala.

1.3 Iingcebiso eziluncedo zokuThintela uRhwaphilizo lweFayile ye-MDF

Nantsi indlela onokuthi uzikhusele ngayo iifayile zakho zeMDF kurhwaphilizo:

Yenza ii-backups eziqhelekileyo kwaye ujonge ingqibelelo yazo ngokuzenzekelayo
Sebenzisa i-CHECKSUM njengokhetho lwePhepha lokuQinisekisa kuzo zonke ii-database
Qhuba imiyalelo EPHELELEYO YEDATABASE nge-CHECKSUM
Fumana i-UPS ukunqanda ukuvalwa ngequbuliso
Jonga indawo yedisk rhoqo ukunqanda imiba yokugcina
Gqiba SQL Server kunye nenkqubo yokusebenza eneziphetshana zokhuseleko
Sebenzisa i-DBCC CHECKDB rhoqo kuzo zonke ii-database

1.4 Iimpawu eziqhelekileyo zeFayile ye-MDF eyonakele

Ukufunyaniswa ngokukhawuleza kwenkohlakalo yefayile ye-MDF kunokukugcina ixesha elininzi lokubuyisela. Ngezantsi ezinye zeempawu eziqhelekileyo zorhwaphilizo lwefayile ye-MDF:

Imiyalezo yemposiso xa uzama ukuncamathelisa okanye ukufikelela kuvimba weenkcukacha
Uvimba weenkcukacha uvela kwimo ye-SUSPECT okanye RECOVERY_PENDING
Iimpazamo ze-I/O kwi SQL Server logs, ngakumbi iimpazamo 823, 824, okanye 825
Iimpazamo zolwabiwo kumaphepha e-GAM/SGAM/IAM/PFS.
Iimpazamo zokuhambelana ngexesha lokusebenza kwedathabheyisi
Imiba yokusebenza ngesiquphe

Ngezantsi eminye yemiyalezo yemposiso eqhelekileyo xa ifayile ye MDF yonakele:

Ayiphumelelanga ukufumana idata yesi sicelo. (Microsoft.SqlServer.Management.Sdk.Sfc) xxx.mdf asiyofayile yesiseko sesiseko. (uMicrosoft SQL Server, impazamo: 5171)

Qhoboshela uvimba weenkcukacha woMncedisi 'xxx' akuphumelelanga. (Microsoft.SqlServer.Smo) Okubhalwe ngasentla kwefayile 'xxx.mdf' ayisosihloko sefayile yedata esebenzayo. Ipropathi ye-FILE SIZE ayichanekanga.(Micosoft SQL Server, impazamo: 5172

SQL Server ifumene impazamo ye-I/O esekwe kwingqiqo: i-checksum engachanekanga (ekulindeleke: 0x2abc3894; eyona: 0x2ebe208e). Yenzekile ngexesha lokufunda iphepha (1:1) kwiziko ledatha ID 12 kwi-offset 0x00000000002000 kwifayile 'xxx.mdf'. Imiyalezo eyongezelelweyo kwi SQL Server ushicilelo lwemposiso okanye inkqubo yoshicilelo lwesiganeko inokunika iinkcukacha ezininzi. Le yimeko yempazamo enkulu esongela ingqibelelo yedatha kwaye kufuneka ilungiswe ngokukhawuleza. Gqibezela ujongo olupheleleyo lwesiseko sedatha (DBCC CHECKDB). Le mpazamo inokubangelwa yimiba emininzi; ngolwazi olungakumbi, bona SQL Server Iincwadi kwi-Intanethi.(Microsoft SQL Server, impazamo:824)

SQL Server kuchonge impazamo ye-I/O esekwe kwingqiqo: iphepha elikrazukileyo (utyikityo olulindelekileyo: 0x########; utyikityo lokwenene: 0x#######).

2. Iindlela zasimahla zokuLungisa iFayile yeMDF

SQL ServerIindlela zomthonyama zibonelela ngeendlela ezisimahla zokulungisa ukonakala kwefayile ye MDF. Ezi ndlela zemanuwali zinokugcina ugcino lwedatha ongenako ukufikelela kulo, kodwa lufuna ukwenziwa ngononophelo.

2.1 Buyisela kwiBackup yakutsha nje

Most indlela yokubuyisela ethembekileyo starts kunye nokubuyisela kwi-backup yamva nje. Le ndlela yokusebenzela iyalugqitha urhwaphilizo ngokubuyela kwisimo esisempilweni. Ungasebenzisa i-RESTORE DATABASE umyalelo ngokufanelekileyo UKUSUKA kwi-disk parameters ukubuyisela ugcino lwedatha kwimeko yalo phambi korhwaphilizo. Ingqibelelo yakho yedatha ihlala yomelele ngaphandle kokubeka esichengeni ubudlelwane phakathi kwezinto zedatha.

2.2 Sebenzisa iDBCC CHECKDB eneendlela zokuLUNGISA

I-DBCC CHECKDB ikunika amandla okulungisa owakhelwe-ngaphakathi ukuba ukubuyisela kwakhona ayisiyiyo inketho:

DBCC CHECKDB (database_name, REPAIR_ALLOW_DATA_LOSS) 
WITH ALL_ERRORMSGS, NO_INFOMSGS;

Umyalelo unamanqanaba amathathu okulungisa:

REPAIR_FAST: Igcina i-syntax yokuhambelana nomva kuphela; ayilungisi
REPAIR_REBUILD: Iyalungisa ngaphandle ilahleko data
REPAIR_ALLOW_DATA_LOSS: Lungisa zonke iimpazamo ezixeliweyo, kodwa zingancama iinkcukacha ezithile

Sinakho Isikhokelo esibanzi kwi-DBCC CHECKDB equka zonke iinketho kunye neemeko (amaxwebhu asemthethweni kaMicrosoft ayafumaneka Apha).

2.3 Imingcipheko yokusebenzisa REPAIR_ALLOW_DATA_LOSS

Iinketho zokulungisa ziza nemingcipheko. REPAIR_ALLOW_DATA_LOSS inokususa amaphepha abonakele ngokupheleleyo, nto leyo ekhokelela kwilahleko yedatha esisigxina. Kananjalo ayihoyi imiqobo ephambili yangaphandle, enokuthi iphule imfezeko yobudlelwane phakathi kweetheyibhile. Ngoko,

Ngaphambi kokulungiswa, kuya kufuneka uyigcine ngesandla ifayile yakho ye-MDF eyonakeleyo.
Emva kokulungiswa, kuya kufuneka uqinisekise imiqobo usebenzisa i-DBCC CHECKCONSTRAINTS ukufumana iziphene zengqiqo yeshishini.

2.4 Sebenzisa I-DBCC CHECKTABLE

I-DBCC TSHECKTABLE ikunika a taryafumana indlela yorhwaphilizo kwiitheyibhile ezithile:

DBCC CHECKTABLE (table_name, REPAIR_ALLOW_DATA_LOSS);

Lo myalelo ujonge itafile enye endaweni yesiseko sedatha iyonke. Ibaleka ngokukhawuleza kwaye inemingcipheko embalwa xa usazi ukuba zeziphi iitafile ezineengxaki.

2.5 Misela uvimba weenkcukacha kwi-EMERGENCY kunye ne-SINGLE_USER indlela

Ugcino lwedatha olonakele kakhulu lusenokufuna imowudi EMERGENCY njengokhetho lokugqibela:

ALTER DATABASE [DatabaseName] SET EMERGENCY;
ALTER DATABASE [DatabaseName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DBCC CHECKDB ([DatabaseName], REPAIR_ALLOW_DATA_LOSS);

Abalawuli beDatabase bafumana ufikelelo lokufunda kuphela ngemo yoNgxamiseko ukuba ufikelelo oluqhelekileyo aluphumeleli. Inkqubo iyakha kwakhona ilog yentengiselwano, kodwa uphulukana nokungaguquguquki kwentengiselwano kwaye waphule ikhonkco RESTORE. Gcina iifayile zakho zesiseko sedatha ngaphambi kokuba uzame ukulungiswa okungxamisekileyo ukugcina ukhetho lwakho lokubuyisela luvulekile.

2.6 “Hack Qhoboshela” Indlela

Ukuba awukwazi ukufaka ifayile ye-MDF eyonakeleyo SQL Server, ungazama "i-hack attach" indlela:

Yenza i-database ye-dummy enegama elifanayo nedatha yakho eyonakeleyo
Thatha i-database ye-dummy ngaphandle kweintanethi
Cima iifayile zedatha ye-dummy
Khuphela ifayile yakho ye-MDF eyonakeleyo kwindawo yefayile ye-dummy
Yiza nedathabheyisi kwi-intanethi

Le ndlela ayiyi kulungisa urhwaphilizo kodwa iyanceda SQL Server Qaphela ifayile kwaye wenze imiyalelo yokulungisa.

2.7 Lungisa uVimba weeNkcukacha oNcitshiswayo

Urhwaphilizo lwesiseko sedatha oluyiNtloko lufuna la manyathelo:

Khuphela i-master.mdf eyonakele njengesiseko sedatha kwenye iseva.
Sebenzisa iindlela zezandla okanye DataNumen SQL Recovery buyisela izinto kuyo.
Rhweba ngaphandle izinto ezifunyenweyo kwiscript.
Yakha kwakhona isiseko sedatha kumncedisi woqobo.
Qalisa iskripthi esiveliswe kwinyathelo lesi-3 ukwenza kwakhona abasebenzisi kunye nezinto.

3. Sebenzisa DataNumen SQL Recovery Ukulungisa Ifayile ye-MDF ekhohlakeleyo

Ukuba ezi ndlela zezandla ezingentla ziyasilela, ungazama izixhobo zobuchwephesha, ezifana DataNumen SQL Recovery, ekunceda ukuba ulungise iifayile zeMDF ezonakalisiweyo SQL Server's izixhobo ezakhelwe ngaphakathi azinakuphatha. Isoftware isebenzisa ii-algorithms eziphambili ukufumana i-most idatha enokwenzeka kwiifayile ezonakeleyo kwaye ikunika iinketho ezininzi zokubuyisela.

Ukukhuphela mahala

3.1 Lungisa iFayile enye

Inkqubo yokulungisa ifayile enye iqondile kwaye kulula ukuyilandela:

Vala naziphi na iinkqubo ezinokutshintsha ifayile yeMDF.
Start DataNumen SQL Recovery.
Khetha ifayile yeMDF eyonakeleyo ngokuchwetheza igama layo okanye ucofe iqhosha lokukhangela.
Bandakanya naziphi na iifayile ezinxulumene ne-NDF ukuba uyazifuna.
Khetha ifomati yesiseko sesiseko okanye yeka inkqubo iyibhaqe:
Khetha apho ufuna ukugcina khona ifayile efunyenweyo.
Cofa indawo ethi “Start UBuyiselo” iqhosha, isoftware iya kuqhagamshela kweyakho SQL Server umzekelo ngegama lomncedisi wakho kunye neenkcukacha zokungena.
Emva koko isoftware iya kulungisa ifayile yakho kunye ne-algorithms yayo yokubuyisela.

Uza kubona ibar yenkqubela phambili ebonisa ukuba ulungiso luhamba njani. Emva kokuba yenziwe, ungajonga idatabase yakho efunyenweyo SQL Server Isitudiyo soLawulo.

3.2 Lungisa iBatshi yeeFayile

Iinkampani ezinedatha eninzi ezonakeleyo ziya konga ixesha ngokulungiswa kwebhetshi. Unokongeza zonke ezonakalisiweyo iifayile zakho zeMDF emgceni, seta imveliso ozikhethayo, kunye start ukuchacha. Eli nqaku lisebenza kakuhle kwiindawo zoshishino ezifuna ukulungisa iingxaki zenkqubo yedatha.

Amanyathelo aneenkcukacha:

Yiya kwi "Batch yoBuyiselo" ithebhu.
Cofa "Yongeza iifayile" ukongeza ezininzi SQL Server Iifayile ze-MDF eziza kulungiswa.
Unako kwakhona ukucofa "Khangela iiFayile" ukufumana iifayile ukuba zilungiswe kwikhompyutha yendawo.
Cofa indawo ethi “Start Buyisa” iqhosha
Zonke iifayile ze-PST kuluhlu ziya kulungiswa nganye nganye.

3.3 Buyisa kwakhona kwiHard Drive, kwiDiski yoMfanekiso okanye kwiiFayile eziKhuselweyo

DataNumen SQL Recovery yenza okungaphezulu kokuchacha okuqhelekileyo. Inokufumana idatha yeSQL ukusuka:

VMWare VMDK iifayile zedisk zomatshini wenyani
Iifayile zeVHD zePC ebonakalayo
Iifayile zomfanekiso we-ISO
Windows NTBackup iifayile (.bkf)
Iifayile zoMfanekiso Wenyani we-Acronis (.tib)
Norton Ghost iifayile (.gho, .v2i)

Olu bhetyebhetye yindlela entle yokubuyisela idatha yakho kwiimeko ezahlukeneyo, ezinje:

Ucima idatabase kwi SQL Server.
Ufomatha i-hard drive.
Ukusilela kwi-hard drive.
Idiski enenyani kwiVMWare okanye iPC ebonakalayo yonakele okanye yonakele kwaye ugcina idatabase kuyo.
Ifayile yogcino kwimidiya yokugcina yonakele okanye yonakele kwaye awukwazi ukubuyisela ifayile yedatha kuyo.
Ifayile yomfanekiso wedisk yonakele okanye yonakele kwaye awukwazi ukubuyisela ifayile yakho yeMDF kuyo.

Kwezi meko zingasentla, usenokukwazi ukuchacha SQL Server data evela hard drive, umfanekiso disk okanye iifayile backup ngqo.

Ukuba unomfanekiso wedisk okanye iifayile ezigcinwe ngesandla, ngoko unokwenza ngolu hlobo lulandelayo:

Cofa "..." iqhosha ukukhetha ifayile yemvelaphi.
Kwincoko ethi "Vula iFayile", khetha "Zonke iiFayile (*.*)" njengecebo lokucoca.
Khetha umfanekiso wedisk okanye ifayile elilalela njengefayile yemvelaphi eza kulungiswa.
Cwangcisa imveliso engaguqukiyo yefayile yegama lefayile, njenge E_Drive_fixed.mdf.

Ukuba ufuna ukubuyisela kwi-hard drive ngqo, ungasebenzisa DataNumen Disk Image ukwenza ifayile yomfanekiso wedisk yehard drive njengefayile yemvelaphi DataNumen SQL Recovery:

Khetha i-hard drive okanye idiski.
Cwangcisa igama lefayile yomfanekiso wemveliso.
Cofa u-“Start Cloning” iqhosha ukwenza ifayile yomfanekiso wedisk kwi-hard drive/disk.

3.4 Fumana kwakhona iiRekhodi neeThebhile ezicinyiweyo

Ukuba ucima ezinye iirekhodi kwitafile, okanye ucime ezinye iitafile kwisiseko sedatha ngempazamo, unokuzifumana kwakhona DataNumen SQL Recovery.

Kwiirekhodi ezingacinywanga, zisenokungabonakali ngendlela efanayo naleyo ngaphambi kokuba zicinywe, ngoko emva kokubuyiselwa, unokufuna ukusebenzisa izitatimende ze-SQL ukuze ufumane ezi rekhodi ezingacinywanga.

Kwiitafile ezingacinywanga, ukuba amagama abo akanakufunyanwa kwakhona, baya kuthiywa ngokutsha njenge “Recovered_Table1”, “Recovered_Table2”, njalo njalo ...

3.5 Fumana kwakhona kwiRansomware okanye iVirus

Iindlela eziqhelekileyo zidla ngokusilela ukulungisa i-database efihliweyo yi-malware. DataNumen SQL Recovery isebenzisa ii-algorithms ezikhethekileyo ukufumana idatha kwiifayile ze-MDF ezifihliweyo ze-ransomware ngaphandle kokuhlawula abahlaseli. Isoftware inokubuyisela iifayile nasemva kokuba uguqulelo oluntsonkothileyo lonakalise iintloko zabo okanye izakhiwo zangaphakathi.

3.6 Lungisa iFayile eFundiweyo

Ukuba iifayile zeMDF zifunyenwe nge DataNumen Data Recovery (okanye ezinye izixhobo zokubuyisela idatha) ayinakuqhotyoshelwa kuyo SQL Server, ezi fayile zisenokonakala okuthile. Kwimeko enjalo, sebenzisa DataNumen SQL Recovery ukuzilungisa kwakhona, ukuqinisekisa ukuba idatha yazo iyafikeleleka SQL Server.

3.7 Fumana kwakhona kwi tempdb.mdf

Nini SQL Server iyasebenza, iya kugcina yonke itemporary idatha, kuquka yonke temporary iitafile kunye neenkqubo zokugcina, zibe temporary idatabase ebizwa ngokuba yi tempdb.mdf. Xa intlekele yedatha isenzeka, ukuba awukwazi ukubuyisela idatha efunwayo kwi-mdf ekhoyo kunye neefayile ze-ndf ezinxulumene, usenokukwazi ukubuyisela idatha yakho kwi-temdb.mdf, ngokusebenzisa DataNumen SQL Recovery, ngoku Landelayo:

Yeka SQL Server Inkonzo yeNjini yedatha.
Usebenzisa umsebenzi wokukhangela weWindows ukukhangela ifayile ye tempdb.mdf kwikhompyuter apho i SQL Server umzekelo ufakiwe.
Emva kokuba ufumene i tempdb.mdf, ungayikhetha njengefayile yemvelaphi eza kufunyanwa kwakhona, kwaye usebenzise DataNumen SQL Recovery ukuyibuyisela.

3.8 Iifayile zeesampuli

SQL Server Inguqulelo	Ifayile ye-MDF eyonakele	Ifayile ye-MDF ilungiswe ngu DataNumen SQL Recovery
SQL Server 2014	Imposiso1_4.mdf	Imposiso1_4_fixed.mdf
SQL Server 2014	Imposiso2_4.mdf	Imposiso2_4_fixed.mdf
SQL Server 2014	Imposiso4_4.mdf	Imposiso4_4_fixed.mdf
SQL Server 2014	Imposiso5_4.mdf	Imposiso5_4_fixed.mdf

4. Iinkonzo zoBuyiselo kwi-Intanethi

Iinkonzo ze-Intanethi zikunika indlela eyahlukileyo yokulungisa oovimba beenkcukacha zeSQL xa ukhuphela kwaye ufaka isoftware yokubuyisela ayinakwenzeka okanye iluncedo. Ezi nkonzo ze-intanethi zinceda ukulungisa iifayile ze-MDF ezonakalisiweyo ngaphandle kokufuna ulwazi olunzulu lobugcisa.

4.1 Iinkqubo ezilula zokuBuyisa kwakhona

Iinkonzo zokubuyisela i-SQL kwi-Intanethi zilandela inkqubo ekulula ukuyisebenzisa:

Layisha ifayile eyonakeleyo -Ifayile yakho ye-MDF eyonakeleyo igqithiselwa ngokukhuselekileyo kwiseva yomnikezeli wenkonzo ngoqhagamshelwano oluntsonkothileyo
Ukucubungula kunye nohlalutyo -Inkonzo iskena ifayile yakho ngeealgorithms ezikhethekileyo kwaye ichonge idatha enokufunyanwa
Jonga kwangaphambili iziphumo zokubuyisela -Ungajonga izinto zedatha enokufunyanwa ngaphambi kokuba uzibophelele ekubuyiseni ngokupheleleyo
Khuphela ifayile elungisiweyo – Ifayile yedata elungisiweyo okanye izikripthi zeSQL ziyafumaneka emva kokucubungula

Ezi nkonzo zefu zisebenza kunye SQL Server iifayile zesiseko sedata njenge .mdf, .ndf, kunye .ldf. Ubungakanani befayile kunye nobungqongqo borhwaphilizo bumisela ixesha lokucubungula, ukusuka kwimizuzwana ukuya kwimizuzu.

Iinkonzo kunye neengozi

Izinto ezilungileyo zokubuyisela kwi-intanethi:

Awudingi kufakela isoftwe – igqibelele kwiindawo ezinemiqathango okanye abasebenzisi ngaphandle kwamalungelo olawulo
Isebenza kuyo nayiphi na inkqubo yokusebenza kubandakanya iMacOS kunye neLinux
Ukulungele ukusebenzisa ngaphandle kokukhuphela iipakethe ezinkulu zesoftware
Umsebenzisi-friendly interface ilungele abantu abanezakhono ezisisiseko zobugcisa
Ungabona idatha enokufunyanwa phambi kokuthenga

Imida onokucinga ngayo:

Ukufakela ulwazi lwedatha ebuthathaka kwiiseva zomntu wesithathu kuphakamisa iinkxalabo zabucala
Ubuninzi bobungakanani bedatabase bunezithintelo
Iinketho ezimbalwa zokuzenzela kunezixhobo ezingasebenziyo
Isantya sokubuyisela sixhomekeke ekusebenzeni komncedisi kunye nomthwalo
Iinguqulelo zedemo zibonisa kuphela idata efumanekayo de kuthengwe

Izixhobo zokubuyisela ngaphandle kwe-intanethi zikunika ulawulo olungakumbi kunye nobumfihlo kodwa zifuna ubuchule obungakumbi bobugcisa. Most Iinkonzo ze-intanethi zikuvumela ukuba uvavanye ukusebenza kwazo ngeedemo zasimahla. Ezi demo zibuyisela idatha yesampulu kwaye ziphawule ezinye izinto ezinokufunyanwa nezibambi-ndawo.

Olona khetho lulungileyo phakathi kwe-intanethi kunye nokubuyisela ngaphandle kwe-intanethi luza kwiimfuno zakho. Uxinzelelo lwexesha, izakhono zobugcisa, uvelwano lwedatha, kunye nohlobo lwenkohlakalo yefayile ye-MDF zonke zidlala indima ebalulekileyo kwesi sigqibo.

5. Izisombululo ezingakumbi

Ngelixa iindlela ezigutyungelwe kumacandelo angaphambili zibamba i-most Iimeko zorhwaphilizo zefayile ye-MDF, indawo yokubuyisela isiseko sedatha inika izisombululo ezongezelelweyo ezikhethekileyo. Sivavanye iindlela ezininzi kwaye saqulunqa olu luhlu lubanzi lwe most ezinye iindlela ezisebenzayo ezincedisana namacebo okulungisa angundoqo.

6. Emva kokulungiswa: Qinisekisa kwaye ukhusele iDatha yakho yedatha

Ukulungisa ifayile yakho ye-MDF eyonakeleyo kusombulula kuphela isiqingatha sengxaki. I-database yakho idinga ubungqina obuchanekileyo kunye nokukhusela emva kokubuyisela ngempumelelo ukugcina ingqibelelo yedatha kunye nokuyeka iingxaki ezizayo.

6.1 Qwalasela ukuBuyiswa kweMfezeko yeDatha

Itshekhi yokuqinisekisa eneenkcukacha iqinisekisa ukuba yonke idatha ihlala yomelele emva kokulungiswa. Umyalelo weDBCC CHECKDB one DATA_PURITY iskena samaxabiso angasebenziyo:

DBCC CHECKDB (database_name) WITH DATA_PURITY, NO_INFOMSGS;

Lo myalelo ubeka amaxabiso ekholamu enokuthi ingasebenzi okanye iphume-kuluhlu lweentlobo zabo zedatha. Gcina ukhumbula ukuba kufuneka ulungise naziphi na iimpazamo ezichongiweyo ngesandla kuba iindlela zokulungisa azikwazi kuzilungisa ngokuzenzekelayo.

I-DBCC CHECKCONSTRAINTS inceda ukungqinisisa ingqiqo yeshishini ihlala injalo kuba imisebenzi yokulungisa ayijongi okanye igcine imiqobo ephambili yangaphandle.

6.2 Yakha kwakhona izalathisi kunye nezithintelo

Ukuphucula ukusebenza kuba linyathelo elilandelayo emva kokuba ukuthembeka kwedatha kuhlolisisiwe. Imisebenzi yokulungisa ihlala ishiya izalathisi ziqhekekile, nto leyo efuna ingqalelo ekhawulezileyo:

ALTER INDEX ALL ON table_name REBUILD;

Iqela eliphambili kufuneka lakhe kwakhona izalathisi ezithile zokusetyenziswa okuphezulu kuqala ukubuyisela ukusebenza ngokukhawuleza kwiinkqubo ezibalulekileyo. Oku kudala entsha, ngokufanelekileyo hosted izalathisi ukuba boost amaxesha okuphendula imibuzo.

6.3 Gcina i-Database eLungisiweyo

Yenza ugcino olupheleleyo lwesiseko sakho sedatha esandula kulungiswa kwangoko:

BACKUP DATABASE database_name 
TO DISK = 'path\backup_file.bak' 
WITH CHECKSUM, FORMAT;

Ukhetho lwe-CHECKSUM lujonga ingqibelelo yogcino ngexesha lomsebenzi. Vavanya i-backup kwiseva yovavanyo emva koko ukuze uqinisekise ukuba isebenza ngokufanelekileyo ngaphambi kokuba uyisebenzisele ukubuyisela imveliso.

6.4 Misela ukuBeka iliso kunye nezilumkiso

Ukubeka iliso okusebenzayo kunceda ukubona imiba enokubakho ngaphambi kokuba yonakalise idatha. Cwangcisa izilumkiso zeemetriki eziphambili eziquka:

Ipesenti yeCPU (umda: 90%)
Isithuba sedatha esisetyenzisiweyo ipesenti (umqobo: 95%)
Ukusetyenziswa kwabasebenzi (umda: 60%)
I-Deadlocks (nasiphi na isiganeko)
Iimpazamo zenkqubo kwiinzame zoqhagamshelwano

Azure Monitor okanye SQL Server Isitudiyo soLawulo sinokuqwalasela ezi zilumkiso. Izaziso eziqinisekisiweyo zihlala ziqhutywa de zisonjululwe, ezithintela izaqhwithi zesaziso ngexesha lemiba eqhubekayo.

Ukuhlolwa kwemfezeko yeveki nganye kusetyenziswa i-DBCC CHECKDB kufuneka kuqhutywe koovimba beenkcukacha ezibalulekileyo ukubamba iingxaki kwangethuba.

7. Ii-FAQ

Urhwaphilizo lwesiseko sedatha ludala imibuzo emininzi kubasebenzisi. Makhe sijonge imibuzo eqhelekileyo malunga nokulungisa iifayile zeMDF kwi SQL Server.

7.1 Ndingayifumana kwakhona ifayile ye-MDF ngaphandle kwefayile ye-LDF?

Impendulo: Ewe, kunye nezixhobo zobungcali ezifana DataNumen SQL Recovery, ungaphinda ubuyise ifayile ye MDF ngaphandle kwefayile ye LDF.

7.2 Ngaba kufuneka ndisebenzise izixhobo zokulungisa zomntu wesithathu okanye iindlela ezakhelwe ngaphakathi?

Impendulo: Iindlela ezakhelwe ngaphakathi zifanele itrayi yokuqala kuba zinenkxaso esemthethweni. Nangona kunjalo, izixhobo zeqela lesithathu zinokuphinda zifumane iinkcukacha ezininzi kwiimeko zorhwaphilizo ezimandundu. Olona khetho lungcono luxhomekeke kwi:

Ukubaluleka kwedatha
Ukufumaneka kogcino
Ixesha elimiselweyo
Izithintelo kuhlahlo-lwabiwo mali
Ukunyamezela umngcipheko kwilahleko yedatha

8. Isiphelo

SQL Server urhwaphilizo lwesiseko sedatha lufuna ukufunyanwa ngokukhawuleza kunye neendlela ezifanelekileyo zokubuyisela ukunciphisa ilahleko yedatha. Iimpawu zorhwaphilizo zefayile ye-MDF zikunceda ukuba usebenze ngokukhawuleza xa kuvela iingxaki. Unokhetho oluninzi lokubuyisela, ukusuka kokwakhelwe ngaphakathi SQL Server izixhobo kwizisombululo ezikhethekileyo zomntu wesithathu njenge DataNumen SQL Recovery isixhobo. Ngezantsi sisishwankathelo seli nqaku:

Uthintelo lusebenza ngcono kunonyango. Ukugcinwa rhoqo kwedathabheyisi, iinkqubo ezifanelekileyo zokugcina, kunye nokubeka iliso kwidisk yezempilo kunciphisa kakhulu imingcipheko yorhwaphilizo. Le nkqubo ikwadinga ukubonakalisa ugcino-lwazi olufunyenweyo kanye ngokutshekisha imfezeko kunye nokwakha kwakhona izalathisi ukugcina idatha ithembekile emva kokulungiswa.