Kajeno ke tla u bolella ka likarolo tse peli tsa Commvault bakeng sa bekapo ea MS SQL tse hlokomolohuoang ka leeme: ho hlaphoheloa ha granular le plugin ea Commvault bakeng sa SQL Management Studio. Ha ke na ho nahana ka litlhophiso tsa mantlha. Poso e ka etsahala haholo bakeng sa ba seng ba ntse ba tseba ho kenya moemeli, ho hlophisa kemiso, maano, joalo-joalo. Ke buile ka hore na Commvault e sebetsa joang le hore na e ka etsa eng ho sena.
Pholiso ea granular
Khetho ho tsosolosa boemo ba tafole e hlahile ka thepa ea Subclient haufinyane tjena. E u lumella ho nolofalletsa bokhoni ba ho tsosolosa litafole ho tloha ho database ntle le ho tsosolosa database eohle ho tloha ho boloka. Sena se bonolo ha o tseba hore na phoso kapa tahlehelo ea data e hokae. Ka nako e ts'oanang, database ka boeona e kholo 'me ho e tsosolosa ho tla nka nako e ngata.
Khetho ena e na le meeli:
- Litafole li ke ke tsa khutlisetsoa sebakeng sa polokelo ea litaba tsa mantlha, ho tse ling feela.
- Litafole tsohle li khutlisetsoa ho dbo schema. Tafole e ke ke ea khutlisetsoa ho schema ea mosebelisi.
- Ke feela ak'haonte ea lehae ea SQL ea lehae e nang le litokelo tsa batsamaisi ba sistimi e tšehetsoang.
— Seva e shebiloeng moo re khutlisetsang tafole e tlameha ho sebetsa ho Windows OS.
- Ho seva se shebiloeng, ho phaella ho SQL Agent, Media Agent le Java Runtime Environment e tlameha ho kenngoa.
- Database e tlameha ho sebelisa mohlala oa Pholoso ka mokhoa o felletseng.
- Haeba khetho ea ho khutlisa database ea granular e nolofalitsoe, bokhoni ba ho etsa mesebetsi e fapaneng ea "backup" bo lahlehile.
Khetho ea ho khutlisa boemo ba tafole e koetsoe.
Khetho ea ho khutlisa boemo ba tafole e koetsoe.
Ts'ebetsong ea ka, ho bile le nyeoe ha moreki a ne a e-na le kemiso e latelang e lokiselitsoeng seva sa SQL: bekapo e le 'ngoe e felletseng hang ka beke le li-backups tse 6 tse fapaneng matsatsing a beke. O nolofalitse ts'ebetso ea ho khutlisa boemo ba tafole, 'me mesebetsi e fapaneng ea ho boloka e ile ea sebetsoa ka phoso.
A re boneng hore na tsosoloso ka boeona e tla shebahala joang.
1. Qala ho hlaphoheloa ho moemeli ea lakatsehang.
2. Fesetereng e hlahang, ea ho tab e tsoetseng pele Options. Khetha SQL Granular Browse - Sheba Litaba.
3. Lethathamong le bulang, khetha database eo re tla tsosolosa tafole ho eona ebe o tobetsa Khutlisa Granular.
4. Ka lebokoseng la puisano, lokisa sebaka sa polokelo ea polokelo ho tloha lifaeleng tsa ho boloka (ntho e kang Instant Recovery technology).
Re bontša:
- lebitso la database ea nakoana;
- nako e kae ho boloka ntlha ena ea ho hlaphoheloa ka matsatsi;
- seva moo re tla beha database. Ke li-server tse phethahatsang maemo ohle a hlokahalang a boletsoeng ka holimo feela tse tla fumaneha lethathamong: ka Windows OS, Media Agent le Java Runtime Environment e kentsoe, joalo-joalo.
Tobetsa OK.
5. Fesetereng e ncha, tobetsa Lintlha tsa ho Fumana Lintlha.
6. Ho tla buleha lethathamo la lintlha tse phahamisitsoeng tsa ho hlaphoheloa. Haeba database e le kholo, u tla tlameha ho ema. Ebe o tobetsa Browse. Ho tla hlaha fensetere ho sheba litafole ho tsoa ho database e khethiloeng.
Ha lenane le ntse le etsoa, puisano ea Lintlha tsa Phomolo hangata e koetsoe, ebe ha ba khone ho khutlela moo hape. Ho bonolo: tobetsa ka ho le letona ho mohlala oa seva sa SQL moo ts'ebetso ea ho phahamisa ntlha ea ho hlaphoheloa e qalileng. Eya ho Mesebetsi Tsohle ebe u khetha Lintlha tsa ho Fumana Lethathamo.
7. Haeba ho na le litafole tse ngata, ho ka nka nako ho li hlahisa. Mohlala, bakeng sa database ea 40 GB, lenane le nka metsotso e ka bang leshome ho theha. Khetha tafole eo u e batlang ebe u tobetsa Khutlisa Tsohle Tse Khethiloeng.
8. Fesetereng e ncha, khetha polokelo ea polokelo moo re tla tsosolosa (li) tafole. Tabeng ea rona, ena ke database ea GPI TEST.
9. Ka mor'a hore tsosoloso e phethe, litafole tse khethiloeng li tla hlaha sebakeng sa polokelo ea TEST ea GPI.
Ka mor'a hore u tsosolose tafole ho database ea nakoana, u ka e fetisetsa sebakeng sa pele sa polokelo ea litaba u sebelisa Management Studio.
Commvault plug-in bakeng sa SQL Management Studio
Batsamaisi ba polokelo ea boitsebiso ha se kamehla ba khonang ho fumana mokhoa oa ho boloka boitsebiso (BSS). Ka linako tse ling u hloka ho etsa ho hong ka potlako, empa mookameli oa IBS ha a fumanehe. Ka plugin ea Commvault bakeng sa SQL Management Studio, molaoli oa database a ka etsa backup ea data ea mantlha le ho hlaphoheloa.
QL Management Studio Version
taelo
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
Mefuta ea li-server tsa SQL tse tšehetsang Commvault plug-in le litaelo tse kenyang plug-in. Plugin e tšehetsoa feela ho 64-bit Windows OS.
1. Phetha taelo e tsamaellanang le mofuta oa rona oa seva sa SQL:
2. Likgetho tsa ho boloka le ho tsosolosa li se li fumaneha ho Management Studio. Ho etsa sena, tobetsa ka ho le letona ho database eo u e batlang.
Kahoo, mookameli o na le monyetla oa ho sebelisana ka ho toba le likopi tsa "backup" tsa database ena ntle le Commvault console le ho letsetsa mookameli oa SRK.
3. Ha o bula mesebetsi efe kapa efe e fumanehang ea menu ena, ho tla hlaha fensetere e batlang ho kena le password ea hau. Ho hokela ho CommServe, sebelisa SSO kapa ak'haonte efe kapa efe ho tsoa karolong ea Tšireletso ho Commserve (Commcell login).
4. Haeba litokomane li kentsoe ka nepo 'me ho na le litokelo tse lekaneng tsa phihlello, molaoli oa polokelo ea polokelo a ka:
- tsamaisa bekapo e sa tloaelehang (Backup);
- khutlisetsa database ho tsoa ho "backup" (Khutlisa);
- sheba nalane ea mesebetsi e phethiloeng (Sheba Nalane) le tsoelopele ea mesebetsi e ntseng e tsoela pele (Mosebetsi oa ho hlahloba).
Sena ke kamoo nalane ea mesebetsi e phethiloeng ea "backup" bakeng sa database e khethiloeng e shebahalang joang ho Management Studio.
Menu bakeng sa ho hlaphoheloa ha database. Ha e fapane le menu ea console.
Ke eona bakeng sa likarolo tsena tse peli tsa SQL Agent ho tloha Commvault. Ke tla eketsa hore bekapo e sebelisang Commvault e loketse haholoanyane bakeng sa ba nang le li-server tse ngata ts'ebeletso, ka maemo a 'maloa le li-database, sena sohle, mohlomong, libakeng tse fapaneng mme se hloka ho theha mananeo a fapaneng, botebo, joalo-joalo. li-server tse 'maloa, ebe bakeng sa lisebelisoa tsa Standard MS SQL li lekane bakeng sa bekapo.
Source:
Source: www.habr.com