{"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: paar kasulikku Commvaulti funktsiooni, millest k\u00f5ik ei tea","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, 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, mida eba\u00f5iglaselt k\u00f5rvale j\u00e4etakse: granulaarsest taastamisest ja Commvaulti pluginast SQL Management Studiosse. \u00dcksikasjalikke h\u00e4\u00e4lestamise aspekte ei k\u00e4sitle, see postitus on pigem neile, kes juba oskavad agenti paigaldada, seadistada ajakava, poliitikaid jne. Commvaulti toimimisest ja selle omadustest olen r\u00e4\u00e4kinud selles <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/dataline\/blog\/318188\/\">postitusest<\/a><\/noindex>.<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h3>Granulaarne taastamine<\/h3>\n<p>\nValik <b>tabeli tasandi taastamine<\/b> ilmnes hiljuti Subclienti omadustes. See v\u00f5imaldab lubada tabelite taastamist andmebaasist, ilma et taastataks kogu andmebaasi varundusest. See on mugav, kui tead t\u00e4pselt, kus on viga v\u00f5i andmete kaotus. Samuti v\u00f5ib andmebaas olla suur ja selle t\u00e4ielik taastamine v\u00f5taks palju aega. <br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, 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 Tabeleid ei saa taastada algsesse andmebaasi, ainult teise. \u00a0<br \/>\n \u2014 K\u00f5ik tabelid taastatakse skeemisse dbo. Tabelit ei saa taastada kasutajaskaemesse.<br \/>\n \u2014 Toetatakse ainult SQL-serveri kohalikke kasutajakontosid, millel on s\u00fcsteemiadministraatori \u00f5igused.<br \/>\n \u2014 Sihtserver, kuhu tabelit taastada, peab t\u00f6\u00f6tama Windowsi operatsioonis\u00fcsteemil.<br \/>\n \u2014 Sihtserveril peavad olema paigaldatud lisaks SQL-agendile ka Media Agent ja Java Runtime Environment.<br \/>\n \u2014 Andmebaas peab kasutama Recovery model'i Full-re\u017eiimis. <br \/>\n \u2014 Kui granulaarsed taastamisvalikud on aktiveeritud, ei saa k\u00e4ivitada diferentseeritud varundus\u00fclesandeid. \u00a0<\/p>\n<p><img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/f01c21078b9f84845593aec9d10a93ec.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Tabeli tasandi taastamise valik on v\u00e4lja l\u00fclitatud.<\/i><\/p>\n<p><img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/0c7f2fa2af05f4cdaa1c966a6cd1ef0f.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Tabeli tasandi taastamise valik on v\u00e4lja l\u00fclitatud.<\/i><\/p>\n<p>Minu praktikas oli juhtum, kus kliendil oli SQL-serverile seadistatud j\u00e4rgmine ajakava: \u00fcks t\u00e4ielik varukoopia n\u00e4dalas ja 6 diferentseeritud varukoopiat t\u00f6\u00f6p\u00e4evadel. Ta aktiveeris tabeli tasandi taastamise funktsiooni ning diferentseeritud varundus\u00fclesanded t\u00f6\u00f6tasid viga. <\/p>\n<p>Vaadakem, kuidas taastamine v\u00e4lja n\u00e4eb.<br \/>\n1. K\u00e4ivita taastamine vajaliku agendi juures.<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/52a9fb15bbffc0d9cd9c03310659bdc2.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n2. Avanenud aknas liigu vahekaardile <b>Advanced Options<\/b>. Valime <b>SQL Granular Browse \u2014 View Content.<\/b><br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/c9224f9168d3aa54d47df397b54dd4df.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n3. Avanevas loendis valime andmebaasi, millest soovime tabelit taastada, ja vajutame <b>Restore Granular<\/b>.<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/e2880687c818458fe1e4eb074e9b68e1.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n4. Dialoogis seadistame andmebaasi monteerimispunkti varundusfailidest (midagi nagu Instant Recovery tehnoloogia).<br \/>\nM\u00e4\u00e4rame:<\/p>\n<ul>\n<li>ajutise andmebaasi nime;<\/li>\n<li>kui kaua hoida seda taastamispunkti p\u00e4evades;<\/li>\n<li>server, kuhu me mountime andmebaasi. Nimekirjas on saadaval ainult serverid, mis vastavad k\u00f5ikidele \u00fclalmainitud tingimustele: Windowsi operatsioonis\u00fcsteemiga, installitud Media Agent ja Java Runtime Environment jne.<\/li>\n<\/ul>\n<p>Kliki OK.<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, 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 kliki List Recovery Points.<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/b44cbeb2d64001dee15f3f9dbf58d5a7.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n6. Avaneb loend mountitud taastamispunktidest. Kui andmebaas on suur, tuleb oodata. Seej\u00e4rel kliki <b>Browse<\/b>. Avaneb aken valitud andmebaasi tabelite vaatamiseks. <br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/2671074165684fcdab5843b30e5ffc81.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nSamal ajal kui loend vormistatakse, suletakse sageli dialoog Recovery Points ja p\u00e4rast seda ei suudeta sinna tagasi minna. K\u00f5ik on lihtne: paremkl\u00f5ps SQL-serveri eksemplaril, kuhu taastamispunkti mountimine k\u00e4ivitus. Mine All Tasks ja vali List Recovery Points.<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, 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 kestab loendi \u00fclesehitamine umbes k\u00fcmme minutit. Vali soovitud tabel ja kliki Recover All Selected. <br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/c3e8a0eebf2c9d18d49f8a50a68d2c70.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n8. Uues aknas vali andmebaas, kuhu taastame tabeli(d). Meie puhul on see andmebaas GPI TEST.<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/c5adb9729db830b65ced5669a868bdaa.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n9. Taastamise l\u00f5petamisel lisatakse valitud tabelid andmebaasi GPI TEST.<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/3fa2d3f1119bf9246bfc8676d68343cb.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nTaastatud tabelid ajutisest andmebaasist saab Management Studio vahenditega siirdada algsesse andmebaasi. <\/p>\n<h3>Commvaulti plug-in SQL Management Studio jaoks<\/h3>\n<p>\nAndmebaasi administratooridel ei pruugi alati olla juurdep\u00e4\u00e4su varunduss\u00fcsteemile (VSR). M\u00f5nikord tuleb midagi kiiresti teha, aga VSR administraator ei ole kohal. Commvaulti plug-iniga SQL Management Studio jaoks saab andmebaasi administraator teostada p\u00f5hitoiminguid andmete varundamiseks ja taastamiseks. <\/p>\n<p><b>QL 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-serverite versioonid, mida Commvault Plug-in toetab, ja k\u00e4sklused, mis aktiveerivad plug-ini t\u00f6\u00f6. Plug-in toetatakse ainult 64-bitiste Windowsi operatsioonis\u00fcsteemide versioonides.<\/i><\/p>\n<p>1. T\u00e4ida k\u00e4sk, mis vastab meie SQL serveri versioonile:<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, 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 tuleb paremkl\u00f5psata soovitud andmebaasil.<br \/>\nSeega on administraatoril v\u00f5imalik otse suhelda antud andmebaasi varukoopiateenustega ilma Commvaulti konsooli ja kahjustatute sekkumiseta.<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/38141c9c785d772532103abd9e7f9174.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n3. Iga selle men\u00fc\u00fc saadaoleva funktsiooni k\u00e4ivitamisel kuvatakse aken, kus k\u00fcsitakse kasutajanime ja parooli. CommServe'i \u00fchendamiseks kasutatakse SSO-d v\u00f5i m\u00f5nda muud kontot, mis asub jaotises Security Commserve (Commcell login).<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, 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: paar kasulikku Commvaulti funktsiooni, millest k\u00f5ik ei tea\" src=\"\/wp-content\/uploads\/2019\/04\/af7596ca8dfee7d20a3b2a57b0261b5b.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n4. Kui sisselogimisandmed on \u00f5iged ja juurdep\u00e4\u00e4su\u00f5igused piisavad, saab andmebaasi administraator:<br \/>\n \u2014 k\u00e4ivitada erakorralise varukoopiate tegemise (Backup);<br \/>\n \u2014 taastada andmebaasi varukoopiast (Restore);<br \/>\n \u2014 vaadata tehtud \u00fclesannete ajalugu (View History) ja j\u00e4lgida \u00fclesannete edenemist (Job monitor).<br \/>\n<img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, 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 varukoopiate tegemise ajalugu valitud andmebaasi jaoks.<\/i><\/p>\n<p><img decoding=\"async\" alt=\"MS SQL varundamine: paar kasulikku Commvaulti funktsiooni, 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>See on k\u00f5ik nende kahe Commvaulti SQL-agendi v\u00f5imaluse kohta. T\u00e4iendaksin, et Commvaulti varukoopiad sobivad rohkem neile, kelle hoolduses on k\u00fcmneid servereid, mitme instantsi ja andmebaasiga, k\u00f5ik see v\u00f5ib olla erinevates kohtades ja vajada erinevate ajakavadede, s\u00fcgavuse jne seadistamist. Kui teil on paar serverit, siis piisab varukoopiate tegemiseks ka MS SQL-i tavalistest 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.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0421\u0435\u0433\u043e\u0434\u043d\u044f.\" \/>\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.1.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.\" \/>\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\udd47 MS SQL varukoopiad: m\u00f5ned kasulikud Commvaulti funktsioonid, millest k\u00f5ik ei tea | ProHoster","description":"T\u00e4na.","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.","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}]}}