Namuhla ngizokutshela ngezici ezimbili ze-Commvault zesipele se-MS SQL ezinganakwa ngokungafanele: ukutholwa kwe-granular kanye ne-plugin ye-Commvault ye-SQL Management Studio. Ngeke ngicabangele izilungiselelo eziyisisekelo. Okuthunyelwe kungenzeka kakhulu kulabo asebekwazi kakade ukufaka i-ejenti, ukulungisa ishejuli, izinqubomgomo, njll. Ngikhulume ngokuthi i-Commvault isebenza kanjani nokuthi yini engayenza kulokhu.
Ukubuyiselwa kwe-Granular
Inketho ukubuyisela izinga lethebula kuvele kuzakhiwo ze-Subclient muva nje. Ikuvumela ukuthi unike amandla amandla okubuyisela amatafula kusizindalwazi ngaphandle kokubuyisela yonke i-database kusuka kusipele. Lokhu kulula uma wazi ukuthi iphutha noma ukulahleka kwedatha kukuphi. Ngesikhathi esifanayo, i-database ngokwayo inkulu futhi ukuyibuyisela konke kuzothatha isikhathi esiningi.
Le nketho inemikhawulo:
- Amathebula awakwazi ukubuyiselwa kusizindalwazi sokuqala, kuphela kwehlukile.
- Wonke amathebula abuyiselwe ku-schema ye-dbo. Ithebula alikwazi ukubuyiselwa ku-schema somsebenzisi.
- I-akhawunti yeseva yendawo ye-SQL kuphela enamalungelo omlawuli wesistimu esekelwayo.
β Iseva eqondiwe lapho sibuyisela khona ithebula kufanele isebenze ku-Windows OS.
- Kuseva eqondiwe, ngaphezu kwe-SQL Agent, I-Media Agent kanye ne-Java Runtime Environment kufanele kufakwe.
β Isizindalwazi kufanele sisebenzise imodeli Yokubuyisela kumodi egcwele.
- Uma inketho yokutholwa kwesizindalwazi esiyimbudumbudu ivuliwe, ikhono lokuqhuba imisebenzi eyisipele ehlukile liyalahleka.
Inketho yokubuyisela izinga lethebula ivaliwe.
Inketho yokubuyisela izinga lethebula ivaliwe.
Ekusebenzeni kwami, kube necala lapho iklayenti lineshejuli elandelayo elungiselelwe iseva ye-SQL: ikhophi eyodwa ephelele kanye ngesonto kanye nezipele ezihlukene ezi-6 phakathi nesonto. Unike amandla umsebenzi wokubuyisela izinga lethebula, futhi imisebenzi eyisipele ehlukile yacutshungulwa ngephutha.
Ake sibone ukuthi ukubuyisela ngokwako kuzobukeka kanjani.
1. Qala ukululama ku-ejenti oyifunayo.
2. Efasiteleni elivelayo, yiya kuthebhu Izinketho Advanced. Khetha I-SQL Granular Phequlula - Buka Okuqukethwe.
3. Ohlwini oluvulayo, khetha i-database lapho sizobuyisela khona itafula bese uchofoza Buyisela i-Granular.
4. Ebhokisini lengxoxo, lungiselela indawo yokukhweza egciniwe kusuka kumafayela ayisipele (into efana nobuchwepheshe bokubuyisela Okusheshayo).
Sibonisa:
- igama lesizindalwazi sesikhashana;
- isikhathi esingakanani ukugcina leli phuzu lokutakula ngezinsuku;
- iseva lapho sizokhweza khona isizindalwazi. Amaseva kuphela agcwalisa zonke izimo ezidingekayo ezishiwo ngenhla azotholakala ohlwini: ngeWindows OS, Media Agent kanye ne-Java Runtime Environment efakiwe, njll.
Chofoza okuthi KULUNGILE.
5. Ewindini elisha, chofoza Amaphuzu Okubuyisela Uhlu.
6. Uhlu lwamaphoyinti okubuyisela afakiwe luzovuleka. Uma i-database inkulu, kuzodingeka ulinde. Bese uchofoza Dlulisa amehlo. Kuzovela iwindi lokubuka amathebula kusizindalwazi esikhethiwe.
Ngenkathi uhlu lusakhiwa, ingxoxo Yamaphuzu Okubuyisela ivamise ukuvalwa, bese awakwazi ukubuyela lapho futhi. Kulula: chofoza kwesokudla kusibonelo seseva ye-SQL lapho inqubo yokukhweza indawo yokutakula yaqalwa. Iya kokuthi Yonke Imisebenzi bese ukhetha Amaphuzu Okubuyisela Uhlu.
7. Uma kunamathebula amaningi, kungase kuthathe isikhathi ukuwaveza. Isibonelo, kusizindalwazi esingu-40 GB, uhlu luthatha cishe imizuzu eyishumi ukubunjwa. Khetha ithebula oyifunayo bese uchofoza Buyisa Konke Okukhethiwe.
8. Efasiteleni elisha, khetha isizindalwazi lapho sizobuyisela khona amathebula. Esimweni sethu, lena isizindalwazi se-GPI TEST.
9. Ngemva kokuthi ukubuyisela sekuqediwe, amathebula akhethiwe azovela kusizindalwazi se-GPI TEST.
Ngemva kokubuyisela itafula kusizindalwazi sesikhashana, ungakwazi ukulihambisa kusizindalwazi sokuqala usebenzisa i-Management Studio.
I-Commvault plug-in ye-SQL Management Studio
Abaphathi besizindalwazi abahlale bekwazi ukufinyelela kusistimu yokusekelayo (BSS). Kwesinye isikhathi udinga ukwenza okuthile ngokuphuthumayo, kodwa umlawuli we-IBS akatholakali. Nge-plugin ye-Commvault ye-SQL Management Studio, umlawuli wesizindalwazi angenza isipele sedatha eyisisekelo futhi alulame.
Inguqulo ye-QL Management Studio
Umyalo
I-SQL 2008 R2
CvSQLAddInConfig.exe/i 10/r
I-SQL 2012
CvSQLAddInConfig.exe/i 11/r
I-SQL 2014
CvSQLAddInConfig.exe/i 12/r
I-SQL 2016
CvSQLAddInConfig.exe/i 13/r
I-SQL 2017
CvSQLAddInConfig.exe/i 14/r
Izinguqulo zamaseva e-SQL asekela i-Commvault Plug kanye nemiyalo eyenza i-plug-in isebenze. I-plugin isekelwa kuphela ku-64-bit Windows OS.
1. Yenza umyalo ohambelana nenguqulo yethu yeseva ye-SQL:
2. Izinketho zokwenza ikhophi yasenqolobaneni nokubuyisela seziyatholakala ku-Management Studio. Ukuze wenze lokhu, chofoza kwesokudla ku-database oyifunayo.
Ngakho-ke, umlawuli unethuba lokuxhumana ngokuqondile namakhophi ayisipele alesi sizindalwazi ngaphandle kwekhonsoli ye-Commvault futhi ashayele umlawuli we-SRK.
3. Uma uvula noma yimiphi imisebenzi etholakalayo yale menyu, kuzovela iwindi elicela ukungena kwakho kanye nephasiwedi. Ukuze uxhume ku-CommServe, sebenzisa i-SSO nanoma iyiphi enye i-akhawunti evela esigabeni Sezokuphepha ku-Commserve (Ukungena ngemvume kwe-Commcell).
4. Uma imininingwane ifakwe ngendlela efanele futhi kunamalungelo okufinyelela anele, umlawuli wesizindalwazi angakwazi:
- sebenzisa isipele esingajwayelekile (Isipele);
β buyisela i-database kusuka kusipele (Buyisela);
β buka umlando wemisebenzi eqediwe (Buka Umlando) kanye nokuqhubeka kwemisebenzi eqhubekayo (Qaphela umsebenzi).
Yilokhu umlando wemisebenzi eyisipele eqediwe yesizindalwazi esikhethiwe ubukeka kanjani ku-Management Studio.
Imenyu yokuthola kabusha isizindalwazi. Akuhlukile ngisho kumenyu ye-console.
Lokho kungenxa yalezi zici ezimbili ze-SQL Agent ezivela ku-Commvault. Ngizokwengeza ukuthi ukwenza ikhophi yasenqolobaneni kusetshenziswa i-Commvault kulungele kakhulu labo abanamaseva amaningi asenkonzweni, ngezimo ezimbalwa kanye nesizindalwazi, konke lokhu, mhlawumbe, kumasayithi ahlukene futhi kudinga ukusetha amashejuli ahlukene, ukujula, njll. Uma une amaseva ambalwa, bese kuthi ku-Standard MS SQL amathuluzi anele ukwenza isipele.
Source:
Source: www.habr.com