{"id":31297,"date":"2019-10-31T21:40:32","date_gmt":"2019-10-31T18:40:32","guid":{"rendered":"https:\/\/prohoster.info\/blog\/rezervnoe-kopirovanie-ms-sql-para-poleznyh-funktsij-commvault-pro-kotorye-ne-vse-znayut\/"},"modified":"2019-10-31T21:40:32","modified_gmt":"2019-10-31T18:40:32","slug":"rezervnoe-kopirovanie-ms-sql-para-poleznyh-funktsij-commvault-pro-kotorye-ne-vse-znayut","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/rezervnoe-kopirovanie-ms-sql-para-poleznyh-funktsij-commvault-pro-kotorye-ne-vse-znayut","title":{"rendered":"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/ebdc042c384f7b3f924eebae96420b62.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nT\u00e4na r\u00e4\u00e4gin kahest Commvaulti v\u00f5imalusest MS SQL-i varundamiseks, mis j\u00e4\u00e4vad tihti m\u00e4rkamata: granulaarsest taastamisest ja Commvaulti lisandist SQL Management Studio jaoks. P\u00f5hiseadistamist ei k\u00e4sitle. Postitus on pigem neile, kes oskavad juba agenti installida, plaanide seadistamist ja poliitikaid jne. Kuidas Commvault t\u00f6\u00f6tab ja mida see oskab, r\u00e4\u00e4kisin selles <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/dataline\/blog\/318188\/\">postituses<\/a><\/noindex>.<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h3>Granulaarne taastamine<\/h3>\n<p>\nValik <b>tabeli tasemel taastamine<\/b> ilmus Subclienti omadustes suhteliselt hiljuti. See v\u00f5imaldab sissel\u00fclitada tabelite taastamise v\u00f5imaluse andmebaasist, taastamata samal ajal kogu andmebaasi varukoopiast. See on mugav, kui tead t\u00e4pselt, kus viga v\u00f5i andmete kaotus on. Samuti on andmebaas suur ja selle taastamine v\u00f5taks palju aega. <br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/76042dd0108a74fa549618971e890f4e.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nSellel valikul on piirangud: <br \/>\n \u2014 Tabelit ei saa taastada algsesse andmebaasi, ainult teise. \u00a0<br \/>\n \u2014 K\u00f5ik tabelid taastatakse skeemi dbo. Tabelit ei saa taastada kasutaja skeemi.<br \/>\n \u2014 Toetatakse ainult kohalikke SQL-serveri konto administraatori \u00f5igustega.<br \/>\n \u2014 Sihtserver, kuhu me taastame tabela, peab t\u00f6\u00f6tama Windowsi operatsioonis\u00fcsteemil.<br \/>\n \u2014 Sihtserveril peavad lisaks SQL-agendile olema installitud Media Agent ja Java Runtime Environment.<br \/>\n \u2014 Andmebaasil peab olema t\u00e4ielik taaste mudel. <br \/>\n \u2014 Kui andmebaasi granular taastamise valik on sisse l\u00fclitatud, kaob v\u00f5imalus k\u00e4ivitada diferentsiaalsete varunduste \u00fclesandeid. \u00a0<\/p>\n<p><img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/f01c21078b9f84845593aec9d10a93ec.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Table-level-restore valik on v\u00e4lja l\u00fclitatud.<\/i><\/p>\n<p><img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/0c7f2fa2af05f4cdaa1c966a6cd1ef0f.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Table-level-restore valik on v\u00e4lja l\u00fclitatud.<\/i><\/p>\n<p>Minu praktikas oli juhtum, kus kliendil oli SQL-serveris seadistatud j\u00e4rgmine ajakava: \u00fcks t\u00e4isvarundus n\u00e4dalas ja 6 diferentsiaalset varundust n\u00e4dalap\u00e4evadel. Ta l\u00fclitas sisse table-level-restore funktsiooni, ja diferentsiaalsete varunduste \u00fclesanded k\u00e4ivitusid veaga. <\/p>\n<p>Vaatame, milline see taastamine v\u00e4lja n\u00e4eb.<br \/>\n1. K\u00e4ivitame taastamise soovitud agendil.<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/52a9fb15bbffc0d9cd9c03310659bdc2.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n2. Ilmunud aknas liikuge vahekaardile <b>Advanced Options<\/b>. Valige <b>SQL Granular Browse \u2014 View Content.<\/b><br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/c9224f9168d3aa54d47df397b54dd4df.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n3. Avatud nimekirjast valime andmebaasi, millest tahame tabelit taastada, ja kl\u00f5psame <b>Restore Granular<\/b>.<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/e2880687c818458fe1e4eb074e9b68e1.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n4. Dialoogikastis seadistame andmebaasi mount-punkti varukoopiate failidest (midagi sarnast Instant Recovery tehnoloogiaga).<br \/>\nM\u00e4\u00e4rame:<\/p>\n<ul>\n<li>ajutine andmebaasi nimi;<\/li>\n<li>kui kaua hoida antud taastamispunkti p\u00e4evades;<\/li>\n<li>server, kuhu me andmebaasi mountime. Nimekirjas on saadaval ainult serverid, mis vastavad k\u00f5igile eelpool nimetatud n\u00f5uetele: Windows OS, installitud Media Agent ja Java Runtime Environment jne.<\/li>\n<\/ul>\n<p>Vajutage OK.<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/424def3390c6c4aafb55dd17b7a10e10.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n5. Uues aknas vajutage List Recovery Points.<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/b44cbeb2d64001dee15f3f9dbf58d5a7.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n6. Avaneb loetelu mountitud taastamispunktidest. Kui andmebaas on suur, siis peate ootama. Seej\u00e4rel vajutage <b>Browse<\/b>. Avaneb aken valitud andmebaasi tabelite sirvimiseks. <br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/2671074165684fcdab5843b30e5ffc81.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nSamuti suletakse sageli taastamispunktide dialoog, kui nimekiri on juba koostatud, ja hiljem ei saa sinna tagasi minna. See on lihtne: paremkl\u00f5psake SQL-serveri instantsil, kus taastamispunkti mountimise protsess k\u00e4idi. Minge All Tasks ja valige List Recovery Points.<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/a16653578b1527c220db5911a4d77ea2.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n7. Kui tabeleid on palju, v\u00f5ib nende kuvamiseks kuluda aega. N\u00e4iteks 40 GB andmebaasi puhul koostatakse nimekiri umbes k\u00fcmme minutit. Valige vajalik tabel ja vajutage Recover All Selected. <br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/c3e8a0eebf2c9d18d49f8a50a68d2c70.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n8. Uus aken valib andmebaasi, kuhu me taastame tabeli(d). Meie juhul on see andmebaas GPI TEST.<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/c5adb9729db830b65ced5669a868bdaa.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n9. P\u00e4rast taastamist ilmuvad valitud tabelid GPI TEST andmebaasi.<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/3fa2d3f1119bf9246bfc8676d68343cb.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nP\u00e4rast tabeli taastamist ajutisse andmebaasi saab selle \u00fcle kanda algsesse andmebaasi Management Studio vahendite abil. <\/p>\n<h3>Commvaulti pistikprogramm SQL Management Studio jaoks<\/h3>\n<p>\nAndmebaasi administraatoritel ei ole alati juurdep\u00e4\u00e4su varunduss\u00fcsteemile (VKS). M\u00f5nikord on vaja kiiresti midagi teha, kuid VKS administraator ei ole kohal. Commvaulti pistik programmi SQL Management Studio abil v\u00f5ib andmebaasi administraator teha p\u00f5hilisi andmete varundamise ja taastamise toiminguid. <\/p>\n<p><b>SQL Management Studio versioon<\/b><\/p>\n<p><b>K\u00e4sk<\/b><\/p>\n<p>SQL 2008 R2<\/p>\n<p>CvSQLAddInConfig.exe \/i 10 \/r<\/p>\n<p>SQL 2012<\/p>\n<p>CvSQLAddInConfig.exe \/i 11 \/r<\/p>\n<p>SQL 2014<\/p>\n<p>CvSQLAddInConfig.exe \/i 12 \/r<\/p>\n<p>SQL 2016<\/p>\n<p>CvSQLAddInConfig.exe \/i 13 \/r<\/p>\n<p>SQL 2017<\/p>\n<p>CvSQLAddInConfig.exe \/i 14 \/r<\/p>\n<p><i>SQL serveri versioonid, mis toetavad Commvault pistikprogrammi ja k\u00e4sud, mis aktiveerivad pistikprogrammi t\u00f6\u00f6. Pistikprogramm toetatakse ainult Windowsi 64-bitiste versioonide puhul.<\/i><\/p>\n<p>1. Sooritage k\u00e4sk, mis vastab meie SQL serveri versioonile:<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/0ee5cef1d319279dc40eb75fae82af59.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n2. N\u00fc\u00fcd on Management Studios saadaval varundamise ja taastamise valikud. Selleks peate paremklikkima vajalikul andmebaasil.<br \/>\nSeega on administraatoril v\u00f5imalus otse suhelda selle andmebaasi varukoopiate loomisega ilma Commvaulti konsooli ja s\u00fcsteemi administraatori poole p\u00f6\u00f6rdumiseta.<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/38141c9c785d772532103abd9e7f9174.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n3. Kui aktiveerida m\u00f5ni saadaval olev funktsioon men\u00fc\u00fcst, ilmub aken, kus k\u00fcsitakse sisselogimist ja parooli. CommServe'i \u00fchendamiseks kasutatakse SSO-d v\u00f5i m\u00f5nda muud kasutajat, mis on m\u00e4\u00e4ratud jaotises Security Commserve'is (Commcell sisselogimine).<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/ed666299970851e81cd407680f57a92a.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/af7596ca8dfee7d20a3b2a57b0261b5b.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n4. Kui sisselogimise andmed on \u00f5iged ja \u00f5igusi on piisavalt, v\u00f5ib andmebaasi administraator:<br \/>\n \u2014 alustada erakorralist varukoopiat (Backup);<br \/>\n \u2014 taastada andmebaasi varukoopiast (Restore);<br \/>\n \u2014 vaadata teostatud \u00fclesannete ajalugu (View History) ja j\u00e4lgida \u00fclesannete edenemist (Job monitor).<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/77dff526a444c773da617ee3562adda3.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Nii n\u00e4eb Management Studios v\u00e4lja teostatud varukoopiate ajalugu valitud andmebaasi jaoks.<\/i><\/p>\n<p><img decoding=\"async\" alt=\"MS SQL varundamine: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/e00d1d3d570cdfce7be693caaba381e2.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Andmebaasi taastamise men\u00fc\u00fc. See ei erine isegi konsooli men\u00fc\u00fcst.<\/i><\/p>\n<p>Selleks on k\u00f5ik Commvaulti SQL-agendi kahe v\u00f5imaluse kohta. Lisaksin, et Commvault'i abil varundamine sobib rohkem neile, kelle hoolduses on k\u00fcmneid servereid, mitme instantsiga ja andmebaasidega, mis k\u00f5ik v\u00f5ivad asuda erinevates kohtades ning vajavad erinevate ajakava, s\u00fcgavuse jne seadistamist. Kui teil on paar serverit, siis piisab varundamiseks ka MS SQL sisseehitatud vahenditest.<\/p>\n<p>Allikas: <noindex><a rel=\"nofollow\" href=\"http:\/\/documentation.commvault.com\/commvault\/v11\/article?p=18110.htm\">documentation.commvault.com<\/a><\/noindex><br \/>\n<br \/>Allikas: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/dataline\/blog\/447666\/\">habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0421\u0435\u0433\u043e\u0434\u043d\u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443 \u043f\u0440\u043e \u0434\u0432\u0435 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438 Commvault \u0434\u043b\u044f \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0433\u043e \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f MS SQL, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043d\u0435\u0437\u0430\u0441\u043b\u0443\u0436\u0435\u043d\u043d\u043e \u043e\u0431\u0445\u043e\u0434\u044f\u0442 \u0441\u0442\u043e\u0440\u043e\u043d\u043e\u0439: \u0433\u0440\u0430\u043d\u0443\u043b\u044f\u0440\u043d\u043e\u0435 \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0438 \u043f\u043b\u0430\u0433\u0438\u043d Commvault \u0434\u043b\u044f SQL Management Studio. \u00a0\u0411\u0430\u0437\u043e\u0432\u044b\u0435 \u043c\u043e\u043c\u0435\u043d\u0442\u044b \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0440\u0430\u0441\u0441\u043c\u0430\u0442\u0440\u0438\u0432\u0430\u0442\u044c \u043d\u0435 \u0431\u0443\u0434\u0443. \u041f\u043e\u0441\u0442 \u0441\u043a\u043e\u0440\u0435\u0435 \u0434\u043b\u044f \u0442\u0435\u0445, \u043a\u0442\u043e \u0443\u0436\u0435 \u0443\u043c\u0435\u0435\u0442 \u0443\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0442\u044c \u0430\u0433\u0435\u043d\u0442, \u043d\u0430\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0442\u044c \u0440\u0430\u0441\u043f\u0438\u0441\u0430\u043d\u0438\u0435, \u043f\u043e\u043b\u0438\u0442\u0438\u043a\u0438 \u0438 \u043f\u0440. \u041e \u0442\u043e\u043c, \u043a\u0430\u043a \u0443\u0441\u0442\u0440\u043e\u0435\u043d Commvault \u0438 \u0447\u0442\u043e \u043e\u043d \u0443\u043c\u0435\u0435\u0442, \u0440\u0430\u0441\u0441\u043a\u0430\u0437\u044b\u0432\u0430\u043b \u0432 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":23263,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-31297","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0421\u0435\u0433\u043e\u0434\u043d\u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443 \u043f\u0440\u043e \u0434\u0432\u0435 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438 Commvault \u0434\u043b\u044f \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0433\u043e \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f MS SQL, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043d\u0435\u0437\u0430\u0441\u043b\u0443\u0436\u0435\u043d\u043d\u043e \u043e\u0431\u0445\u043e\u0434\u044f\u0442 \u0441\u0442\u043e\u0440\u043e\u043d\u043e\u0439: \u0433\u0440\u0430\u043d\u0443\u043b\u044f\u0440\u043d\u043e\u0435 \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0438 \u043f\u043b\u0430\u0433\u0438\u043d Commvault \u0434\u043b\u044f SQL Management Studio. \u0411\u0430\u0437\u043e\u0432\u044b\u0435 \u043c\u043e\u043c\u0435\u043d\u0442\u044b \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0440\u0430\u0441\u0441\u043c\u0430\u0442\u0440\u0438\u0432\u0430\u0442\u044c \u043d\u0435 \u0431\u0443\u0434\u0443. \u041f\u043e\u0441\u0442 \u0441\u043a\u043e\u0440\u0435\u0435 \u0434\u043b\u044f \u0442\u0435\u0445, \u043a\u0442\u043e \u0443\u0436\u0435 \u0443\u043c\u0435\u0435\u0442 \u0443\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0442\u044c \u0430\u0433\u0435\u043d\u0442, \u043d\u0430\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0442\u044c \u0440\u0430\u0441\u043f\u0438\u0441\u0430\u043d\u0438\u0435, \u043f\u043e\u043b\u0438\u0442\u0438\u043a\u0438 \u0438 \u043f\u0440. \u041e \u0442\u043e\u043c, \u043a\u0430\u043a \u0443\u0441\u0442\u0440\u043e\u0435\u043d Commvault \u0438 \u0447\u0442\u043e \u043e\u043d \u0443\u043c\u0435\u0435\u0442, \u0440\u0430\u0441\u0441\u043a\u0430\u0437\u044b\u0432\u0430\u043b \u0432\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/rezervnoe-kopirovanie-ms-sql-para-poleznyh-funktsij-commvault-pro-kotorye-ne-vse-znayut\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"et_EE\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0420\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0435 \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 MS SQL: \u043f\u0430\u0440\u0430 \u043f\u043e\u043b\u0435\u0437\u043d\u044b\u0445 \u0444\u0443\u043d\u043a\u0446\u0438\u0439 Commvault, \u043f\u0440\u043e \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043d\u0435 \u0432\u0441\u0435 \u0437\u043d\u0430\u044e\u0442 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0421\u0435\u0433\u043e\u0434\u043d\u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443 \u043f\u0440\u043e \u0434\u0432\u0435 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438 Commvault \u0434\u043b\u044f \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0433\u043e \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f MS SQL, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043d\u0435\u0437\u0430\u0441\u043b\u0443\u0436\u0435\u043d\u043d\u043e \u043e\u0431\u0445\u043e\u0434\u044f\u0442 \u0441\u0442\u043e\u0440\u043e\u043d\u043e\u0439: \u0433\u0440\u0430\u043d\u0443\u043b\u044f\u0440\u043d\u043e\u0435 \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0438 \u043f\u043b\u0430\u0433\u0438\u043d Commvault \u0434\u043b\u044f SQL Management Studio. \u0411\u0430\u0437\u043e\u0432\u044b\u0435 \u043c\u043e\u043c\u0435\u043d\u0442\u044b \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0440\u0430\u0441\u0441\u043c\u0430\u0442\u0440\u0438\u0432\u0430\u0442\u044c \u043d\u0435 \u0431\u0443\u0434\u0443. \u041f\u043e\u0441\u0442 \u0441\u043a\u043e\u0440\u0435\u0435 \u0434\u043b\u044f \u0442\u0435\u0445, \u043a\u0442\u043e \u0443\u0436\u0435 \u0443\u043c\u0435\u0435\u0442 \u0443\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0442\u044c \u0430\u0433\u0435\u043d\u0442, \u043d\u0430\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0442\u044c \u0440\u0430\u0441\u043f\u0438\u0441\u0430\u043d\u0438\u0435, \u043f\u043e\u043b\u0438\u0442\u0438\u043a\u0438 \u0438 \u043f\u0440. \u041e \u0442\u043e\u043c, \u043a\u0430\u043a \u0443\u0441\u0442\u0440\u043e\u0435\u043d Commvault \u0438 \u0447\u0442\u043e \u043e\u043d \u0443\u043c\u0435\u0435\u0442, \u0440\u0430\u0441\u0441\u043a\u0430\u0437\u044b\u0432\u0430\u043b \u0432\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/rezervnoe-kopirovanie-ms-sql-para-poleznyh-funktsij-commvault-pro-kotorye-ne-vse-znayut\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-10-31T18:40:32+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T18:40:32+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47MS SQL varundamine: paar kasulikku Commvault'i funktsiooni, millest k\u00f5ik ei tea | ProHoster","description":"T\u00e4na r\u00e4\u00e4gin kahest Commvault'i v\u00f5imest MS SQL varundamiseks, mis j\u00e4\u00e4vad \u00f5igustatult t\u00e4helepanuta: granulaarsest taastamisest ja Commvault'i pistikprogrammist SQL Management Studiole. P\u00f5hilisi seadistamise aspekte ei k\u00e4sitle. Postitus on pigem neile, kes juba oskavad agenti installida, ajakava seada, poliitikaid jne. Commvault'i struktuuri ja omaduste kohta r\u00e4\u00e4kisin.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/rezervnoe-kopirovanie-ms-sql-para-poleznyh-funktsij-commvault-pro-kotorye-ne-vse-znayut","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0420\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0435 \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 MS SQL: \u043f\u0430\u0440\u0430 \u043f\u043e\u043b\u0435\u0437\u043d\u044b\u0445 \u0444\u0443\u043d\u043a\u0446\u0438\u0439 Commvault, \u043f\u0440\u043e \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043d\u0435 \u0432\u0441\u0435 \u0437\u043d\u0430\u044e\u0442 | ProHoster","og:description":"\u0421\u0435\u0433\u043e\u0434\u043d\u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443 \u043f\u0440\u043e \u0434\u0432\u0435 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438 Commvault \u0434\u043b\u044f \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0433\u043e \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f MS SQL, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043d\u0435\u0437\u0430\u0441\u043b\u0443\u0436\u0435\u043d\u043d\u043e \u043e\u0431\u0445\u043e\u0434\u044f\u0442 \u0441\u0442\u043e\u0440\u043e\u043d\u043e\u0439: \u0433\u0440\u0430\u043d\u0443\u043b\u044f\u0440\u043d\u043e\u0435 \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0438 \u043f\u043b\u0430\u0433\u0438\u043d Commvault \u0434\u043b\u044f SQL Management Studio. \u0411\u0430\u0437\u043e\u0432\u044b\u0435 \u043c\u043e\u043c\u0435\u043d\u0442\u044b \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0440\u0430\u0441\u0441\u043c\u0430\u0442\u0440\u0438\u0432\u0430\u0442\u044c \u043d\u0435 \u0431\u0443\u0434\u0443. \u041f\u043e\u0441\u0442 \u0441\u043a\u043e\u0440\u0435\u0435 \u0434\u043b\u044f \u0442\u0435\u0445, \u043a\u0442\u043e \u0443\u0436\u0435 \u0443\u043c\u0435\u0435\u0442 \u0443\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0442\u044c \u0430\u0433\u0435\u043d\u0442, \u043d\u0430\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0442\u044c \u0440\u0430\u0441\u043f\u0438\u0441\u0430\u043d\u0438\u0435, \u043f\u043e\u043b\u0438\u0442\u0438\u043a\u0438 \u0438 \u043f\u0440. \u041e \u0442\u043e\u043c, \u043a\u0430\u043a \u0443\u0441\u0442\u0440\u043e\u0435\u043d Commvault \u0438 \u0447\u0442\u043e \u043e\u043d \u0443\u043c\u0435\u0435\u0442, \u0440\u0430\u0441\u0441\u043a\u0430\u0437\u044b\u0432\u0430\u043b \u0432","og:url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/rezervnoe-kopirovanie-ms-sql-para-poleznyh-funktsij-commvault-pro-kotorye-ne-vse-znayut","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T18:40:32+00:00","article:modified_time":"2019-10-31T18:40:32+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"31297","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-21 05:28:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 03:19:49","updated":"2026-01-21 05:28:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/31297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=31297"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/31297\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/23263"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=31297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=31297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=31297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}