Namhlanje ndiza kukuxelela malunga neempawu ezimbini ze-Commvault ze-MS SQL ezigcinayo ezingahoywanga ngokungafanelekanga: ukubuyiswa kwegranular kunye neplagin yeCommvault ye-SQL Management Studio. Andiyi kuqwalasela izicwangciso ezisisiseko. Isithuba sinokwenzeka ngakumbi kwabo sele beyazi indlela yokufaka i-arhente, ukuqwalasela ishedyuli, imigaqo-nkqubo, njl. .
Ukuchacha kweGranular
Ukhetho inqanaba letafile ukubuyisela ivele kwiipropathi zoMthengi kutsha nje. Ikuvumela ukuba wenze amandla okubuyisela iitafile kwisiseko sedatha ngaphandle kokubuyisela yonke isiseko sedatha kwi-backup. Oku kuluncedo xa usazi apho kanye impazamo okanye ilahleko data. Ngexesha elifanayo, i-database ngokwayo inkulu kwaye ukuyibuyisela konke kuya kuthatha ixesha elininzi.
Olu khetho lunomda:
- Iitheyibhile azikwazi ukubuyiselwa kwisiseko sedatha sokuqala, kuphela kwenye eyahlukileyo.
β Zonke iitheyibhile zibuyiselwe kwi-dbo schema. Itheyibhile ayinakubuyiselwa kwischema somsebenzisi.
β Kuphela yiakhawunti yeseva yeSQL yasekhaya enamalungelo omlawuli wenkqubo exhaswayo.
β Iseva ekujoliswe kuyo apho sibuyisela itafile kufuneka isebenze kwiWindows OS.
- Kumncedisi ojoliswe kuyo, ngaphezu kwe-SQL Agent, i-Media Agent kunye ne-Java Runtime Environment kufuneka ifakwe.
β Ugcino lwedatha kufuneka lusebenzise imodeli yoBuyiselo kwimowudi epheleleyo.
- Ukuba i-database yegranular inketho yokubuyisela ivuliwe, ukukwazi ukuqhuba imisebenzi yokulondoloza eyahlukileyo kuyalahleka.
Umgangatho wetafile-ukubuyisela ukhetho luvaliwe.
Umgangatho wetafile-ukubuyisela ukhetho luvaliwe.
Kwinkqubo yam, kwakukho imeko xa umxhasi wayeneshedyuli elandelayo elungiselelwe iseva ye-SQL: enye i-backup epheleleyo kanye ngeveki kunye ne-6 i-backups eyahlukileyo ngeentsuku zeveki. Wenze umsebenzi wokubuyisela umgangatho wetafile, kunye nemisebenzi yokulondoloza eyahlukileyo yalungiswa ngempazamo.
Makhe sibone ukuba ukubuyisela ngokwako kuya kujongeka njani.
1. Qala ukubuyisela kwi-arhente efunwayo.
2. Kwifestile evelayo, yiya kwithebhu Iinketho Advanced. Khetha I-SQL Granular Browse - Jonga umxholo.
3. Kuluhlu oluvulayo, khetha i-database apho siya kubuyisela khona itafile kwaye nqakraza Buyisela iGranular.
4. Kwibhokisi yencoko yababini, qwalasela indawo yokunyuka yedatabase kwiifayile zogcino (into efana neteknoloji yoBuyiselo ngoko nangoko).
Sibonisa:
- igama lesiseko sedata sexeshana;
- ixesha elingakanani ukugcina le ndawo yokubuyisela ngeentsuku;
- umncedisi apho siya kunyusela idatabase. Kuphela ziiseva ezizalisekisa zonke iimeko eziyimfuneko ezikhankanywe ngasentla ziya kufumaneka kuluhlu: ngeWindows OS, i-Media Agent kunye neJava Runtime Environment efakiweyo, njl.
Cofa u-Kulungile.
5. Kwifestile entsha, cofa kuLuhlu lwamanqaku oBuyiselo.
6. Uluhlu lwamanqaku okubuyisela aphakanyisiweyo luya kuvula. Ukuba i-database inkulu, kuya kufuneka ulinde. Emva koko cofa Khangela incwadi. Ifestile iya kuvela ukujonga iitafile kwindawo ekhethiweyo yedatha.
Ngelixa uluhlu lusakhiwa, incoko yaManqaku oBuyiselo isoloko ivaliwe, kwaye ke ayinakubuyela apho kwakhona. Ilula: cofa ekunene kumzekelo weseva yeSQL apho inkqubo yokunyusela indawo yokubuyisela yaqalwa. Yiya kuyo yonke imisebenzi kwaye ukhethe amanqaku okuBuyisa uluhlu.
7. Ukuba zininzi iitafile, kungathatha ixesha ukuzibonisa. Ngokomzekelo, kwi-database ye-40 GB, uluhlu luthatha malunga nemizuzu elishumi ukwenza. Khetha itafile oyifunayo kwaye ucofe Buyisa Konke Okukhethiweyo.
8. Kwifestile entsha, khetha isiseko sedatha apho siya kubuyisela itafile (ii). Kwimeko yethu, le yi GPI TEST database.
9. Emva kokuba ukubuyisela kugqityiwe, iitheyibhile ezikhethiweyo ziya kuvela kwiziko ledatha ye-GPI TEST.
Emva kokuba ubuyisele itafile kwisiseko sedatha sexeshana, unokuyihambisa kwisiseko sedatha sokuqala usebenzisa iSitudiyo soLawulo.
Iplagi yeCommvault yeSitudiyo soLawulo lweSQL
Abalawuli bedatabase abasoloko benofikelelo kwinkqubo yogcino (BSS). Ngamanye amaxesha kufuneka wenze into ngokukhawuleza, kodwa umlawuli we-IBS akafumaneki. Nge-plugin ye-Commvault ye-SQL yoLawulo lweSitudiyo, umlawuli wedatha unokwenza ugcino lwedatha esisiseko kunye nokubuyisela.
Uguqulelo lweSitudiyo soLawulo lwe-QL
umyalelo
I-SQL 2008 R2
CvSQLAddInConfig.exe /i 10 /r
SQL 2012
CvSQLAddInConfig.exe /i 11 /r
SQL 2014
CvSQLAddInConfig.exe /i 12 /r
SQL 2016
CvSQLAddInConfig.exe /i 13 /r
SQL 2017
CvSQLAddInConfig.exe /i 14 /r
Iinguqulelo zeeseva zeSQL ezixhasa i-Commvault Plug-in kunye nemiyalelo eyenza iplagi isebenze. I-plugin ixhaswa kuphela kwi-64-bit Windows OS.
1. Phumeza umyalelo ohambelana noguqulelo lwethu lweseva yeSQL:
2. Iinketho zokugcina kunye nokubuyisela ngoku ziyafumaneka kwiSitudiyo soLawulo. Ukwenza oku, cofa ekunene kwisiseko sedatha esifunwayo.
Ngaloo ndlela, umlawuli unethuba lokusebenzisana ngokuthe ngqo kunye neekopi zokugcina zale database ngaphandle kwe-Commvault console kunye neefowuni kumlawuli we-SRK.
3. Xa uzisa nayiphi na imisebenzi ekhoyo kule menyu, iwindow iya kuvela ibuza ukungena kwakho kunye negama lokugqitha. Ukuqhagamshela kwi-CommServe, sebenzisa i-SSO okanye nayiphi na enye iakhawunti evela kwicandelo loKhuseleko kwiCommserve (Commcell login).
4. Ukuba iziqinisekiso zifakwe ngokuchanekileyo kwaye kukho amalungelo awoneleyo okufikelela, umlawuli weziko ledatha unako:
- sebenzisa i-backup engaqhelekanga (Eyogcino);
β buyisela i-database kwi-backup (Buyisela);
β Jonga imbali yemisebenzi egqityiweyo (Jonga iMbali) kunye nenkqubela phambili yemisebenzi eqhubekayo (iJob monitor).
Yile nto imbali yemisebenzi egciniweyo egqityiweyo yesiseko sedatha ekhethiweyo ijongeka njani kwiSitudiyo soLawulo.
Imenyu yokubuyisela isiseko sedatha. Akwahlukanga nakwimenyu yeconsole.
Yiyo kwezi zinto zimbini ze-SQL Agent evela kwiCommvault. Ndiza kongeza ukuba i-backup usebenzisa i-Commvault ifaneleke ngakumbi kwabo banamaseva amaninzi kwinkonzo, kunye neemeko ezininzi kunye nogcino-lwazi, konke oku, mhlawumbi, kwiindawo ezahlukeneyo kwaye kufuna ukuseta iishedyuli ezahlukeneyo, ubunzulu, njl. abancedisi ababini, ngoko kuMgangatho we-MS SQL izixhobo zanele kugcino.
umthombo:
umthombo: www.habr.com