Nhasi ndichakuudza nezve maviri eCommvault maficha eMS SQL backup ayo asina kufuratirwa zvisizvo: granular kupora uye Commvault plugin yeSQL Management Studio. Ini handisi kuzofunga nezvekutanga marongero. Iyo posvo inowanzoitika kune avo vanotoziva kuisa mumiriri, kugadzirisa hurongwa, marongero, nezvimwe. Ndakataura nezve mashandiro anoita Commvault uye zvaangaita mune izvi. .
Granular kupora
Sarudzo tafura level kudzorera yakaonekwa mu Subclient properties munguva pfupi yapfuura. Iyo inokutendera iwe kugonesa kugona kudzoreredza matafura kubva kune dhatabhesi pasina kudzoreredza dhatabhesi rese kubva kune backup. Izvi zviri nyore kana iwe uchiziva kuti iko kukanganisa kana kurasikirwa kwedata kuri kupi. Panguva imwecheteyo, dhatabhesi pachayo yakakura uye kudzorera iyo yese kunotora nguva yakawanda.
Iyi sarudzo ine painogumira:
- Matafura haagone kudzoserwa kune yekutanga dhatabhesi, kune imwe chete yakasiyana.
- Matafura ese anodzoserwa kune dbo schema. Iyo tafura haigone kudzoserwa kune mushandisi schema.
- Iyo chete yemunharaunda SQL server account ine kodzero yekutonga system inotsigirwa.
-Sevha inotarirwa patiri kudzoreredza tafura inofanirwa kumhanya paWindows OS.
-Pasevha inotarirwa, kuwedzera kune SQL Agent, Media Agent uye Java Runtime Environment inofanira kuiswa.
- Iyo dhatabhesi inofanirwa kushandisa iyo yekudzoreredza modhi mune Yakazara modhi.
-Kana iyo granular dhatabhesi yekudzoreredza sarudzo yakagoneswa, kugona kumhanyisa mutsauko mabasa ekuchengetedza kwakarasika.
The table-level-restore option yadzimwa.
The table-level-restore option yadzimwa.
Mukuita kwangu, pane imwe nyaya apo mutengi aive nehurongwa hunotevera hwakarongedzerwa sevha yeSQL: imwe yakazara backup kamwe pasvondo uye 6 mutsauko backups pavhiki. Akagonesa tafura-level-kudzorera basa, uye mutsauko wekuchengetedza mabasa akagadziriswa nekanganiso.
Ngationei kuti kudzoreredza pachakwo kucharatidzika sei.
1. Tanga kupora pane aidiwa mumiririri.
2. Muhwindo rinoonekwa, enda kune tab Advanced Options. Sarudza SQL Granular Bhurawuza - Ona Zvemukati.
3. Mutsamba inovhura, sarudza dhatabhesi kubva kwatichadzorera tafura uye tinya Dzorera Granular.
4. Mubhokisi rebhokisi, gadzirisa nzvimbo yekusimudza dhatabhesi kubva kune mafaira ekuchengetedza (chimwe chinhu chakafanana neInstant Recovery teknolojia).
Tinoratidza:
- zita re database yenguva pfupi;
- inguva yakareba sei kuchengetedza iyi poindi yekupora mumazuva;
- server apo isu tichaisa database. Masevha chete anozadzisa ese anodiwa mamiriro ataurwa pamusoro ndiwo achawanikwa mune rondedzero: neWindows OS, Media Agent uye Java Runtime Environment yakaiswa, nezvimwe.
Dzvanya OK.
5. Mufafitera idzva, tinya pakanzi Recovery Points.
6. Rondedzero yemapoinzi akaiswa ekudzoreredza anozaruka. Kana iyo database yakakura, iwe uchafanirwa kumirira. Wobva wadzvanya Browse. Hwindo richaonekwa kuti rione matafura kubva pane yakasarudzwa database.
Ipo runyoro rwuri kuumbwa, iyo Recovery Points dialog inowanzovharwa, uyezve havagone kudzoka ikoko zvakare. Zviri nyore: tinya-kurudyi pane SQL server muenzaniso uko maitiro ekukwirisa nzvimbo yekudzoreredza akatanga. Enda kune Zvese Mabasa uye sarudza Rondedzero Yekudzoreredza Mapoinzi.
7. Kana paine matafura akawanda, zvinogona kutora nguva kuti aaratidze. Semuenzaniso, kune 40 GB dhatabhesi, iyo rondedzero inotora anenge maminetsi gumi kuumba. Sarudza tafura yaunoda uye tinya Dzorera Zvose Zvakasarudzwa.
8. Muhwindo idzva, sarudza dhatabhesi apo tichadzorera tafura (s). Kwatiri, iyi ndiyo GPI TEST dhatabhesi.
9. Mushure mokunge kudzorerwa kwapera, matafura akasarudzwa achaonekwa muGPI TEST database.
Mushure mekudzorera tafura kune dhatabhesi yenguva pfupi, unogona kuiendesa kune yekutanga dhatabhesi uchishandisa Management Studio.
Commvault plug-in yeSQL Management Studio
Database administrators havawanzo kuwana iyo backup system (BSS). Dzimwe nguva unofanirwa kuita chimwe chinhu nekukasira, asi IBS maneja haawanikwe. NeCommvault plugin yeSQL Management Studio, maneja wedhatabhesi anogona kuita yekutanga data backup uye kudzoreredza.
QL Management Studio Version
murayiro
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
Mavhezheni eSQL maseva anotsigira Commvault Plug-in uye mirairo iyo inomutsa iyo plug-in. Iyo plugin inotsigirwa chete pa64-bit Windows OS.
1. Ita murairo unoenderana neshanduro yedu yeSQL server:
2. Backup uye kudzorera sarudzo dzave kuwanikwa muManagement Studio. Kuti uite izvi, tinya-kurudyi pane database yaunoda.
Nekudaro, maneja ane mukana wekutaurirana zvakananga nemakopi ekuchengetedza eiyi dhatabhesi pasina Commvault console uye anofona kune SRK maneja.
3. Paunotanga chero ani emabasa aripo emenyu iyi, hwindo rinoonekwa richikumbira zita rako rekupinda uye password. Kuti ubatanidze kuCommServe, shandisa SSO kana chero imwe account kubva kuChengetedzo chikamu muCommserve (Commcell login).
4. Kana zvitupa zvakapinzwa nemazvo uye paine kodzero dzekuwana dzakakwana, maneja wedatabase anogona:
- mhanyisa inoshamisa backup (Backup);
- dzosa dhatabhesi kubva kune backup (Dzosera);
- tarisa nhoroondo yemabasa akapedzwa (Ona Nhoroondo) uye kufambira mberi kwemabasa arikuenderera mberi (Jobho chekutarisa).
Izvi ndizvo zvinoita nhoroondo yeakapedzwa mabasa ekuchengetedza dhatabhesi yakasarudzwa inotaridzika muManagement Studio.
Menyu yekudzoreredza database. Izvo hazvina kana kumbosiyana kubva kune iyo console menyu.
Ndidzo idzi mbiri dzeSQL Agent kubva kuCommvault. Ini ndichawedzera kuti kuchengetedza uchishandisa Commvault kunonyanya kukodzera kune avo vane gumi nemaviri evhavha mubasa, nezviitiko zvakawanda uye dhatabhesi, zvose izvi, zvichida, panzvimbo dzakasiyana-siyana uye zvinoda kumisa zvirongwa zvakasiyana, kudzika, nezvimwewo. maseva mashoma, zvino zveStandard MS SQL maturusi anokwana kuchengetedza.
Source:
Source: www.habr.com