{"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\/cs\/blog\/administrirovanie\/rezervnoe-kopirovanie-ms-sql-para-poleznyh-funktsij-commvault-pro-kotorye-ne-vse-znayut","title":{"rendered":"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/ebdc042c384f7b3f924eebae96420b62.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nDnes v\u00e1m pov\u00edm o dvou funkc\u00edch Commvault pro z\u00e1lohov\u00e1n\u00ed MS SQL, kter\u00e9 jsou nepr\u00e1vem opom\u00edjeny: granularn\u00ed obnov\u011b a pluginu Commvault pro SQL Management Studio. Z\u00e1kladn\u00ed nastaven\u00ed zmi\u0148ovat nebudu. \u010cl\u00e1nek je sp\u00ed\u0161e pro ty, kte\u0159\u00ed ji\u017e um\u011bj\u00ed instalovat agenta, nastavovat pl\u00e1n a politiky atd. O tom, jak Commvault funguje a co v\u0161echno um\u00ed, jsem ji\u017e hovo\u0159il v tomto <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/dataline\/blog\/318188\/\">p\u0159\u00edsp\u011bvku<\/a><\/noindex>.<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h3>Granularn\u00ed obnova<\/h3>\n<p>\nVolba <b>obnova na \u00farovni tabulky<\/b> se v nastaven\u00ed Subclient objevila pom\u011brn\u011b ned\u00e1vno. Umo\u017e\u0148uje aktivovat mo\u017enost obnovy tabulek z datab\u00e1ze, ani\u017e by bylo nutn\u00e9 obnovovat celou datab\u00e1zi z z\u00e1lohy. To je u\u017eite\u010dn\u00e9, kdy\u017e v\u00edte, kde konkr\u00e9tn\u011b do\u0161lo k chyb\u011b nebo \u00fabytku dat. Pokud je datab\u00e1ze velk\u00e1, celkov\u00e9 obnoven\u00ed by zabralo hodn\u011b \u010dasu. <br \/>\n<img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/76042dd0108a74fa549618971e890f4e.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nTato mo\u017enost m\u00e1 sv\u00e9 omezen\u00ed: <br \/>\n \u2014 Tabulky nelze obnovit do p\u016fvodn\u00ed datab\u00e1ze, pouze do jin\u00e9. \u00a0<br \/>\n \u2014 V\u0161echny tabulky jsou obnoveny do sch\u00e9matu dbo. Tabulka nem\u016f\u017ee b\u00fdt obnovena do u\u017eivatelsk\u00e9ho sch\u00e9matu.<br \/>\n \u2014 Podporov\u00e1na je pouze lok\u00e1ln\u00ed \u00fa\u010det SQL serveru s pr\u00e1vy spr\u00e1vce syst\u00e9mu.<br \/>\n \u2014 C\u00edlov\u00fd server, na kter\u00fd se tabulka obnovuje, mus\u00ed b\u011b\u017eet na opera\u010dn\u00edm syst\u00e9mu Windows.<br \/>\n \u2014 Na c\u00edlov\u00e9m serveru mus\u00ed b\u00fdt krom\u011b agenta SQL nainstalov\u00e1ny Media Agent a Java Runtime Environment.<br \/>\n \u2014 Datab\u00e1ze mus\u00ed pou\u017e\u00edvat model obnoven\u00ed v re\u017eimu Full. <br \/>\n \u2014 Pokud je zapnuta mo\u017enost granularn\u00ed obnovy DB, ztr\u00e1c\u00ed se mo\u017enost spou\u0161t\u011bt \u00fakoly pro diferenci\u00e1ln\u00ed z\u00e1lohov\u00e1n\u00ed. \u00a0<\/p>\n<p><img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/f01c21078b9f84845593aec9d10a93ec.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Mo\u017enost obnovy na \u00farovni tabulky je vypnuta.<\/i><\/p>\n<p><img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/0c7f2fa2af05f4cdaa1c966a6cd1ef0f.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Mo\u017enost obnovy na \u00farovni tabulky je vypnuta.<\/i><\/p>\n<p>V m\u00e9 praxi byl p\u0159\u00edpad, kdy m\u011bl klient pro SQL server nastaven\u00e9 n\u00e1sleduj\u00edc\u00ed pl\u00e1ny: jeden pln\u00fd backup jednou t\u00fddn\u011b a 6 diferenci\u00e1ln\u00edch z\u00e1loh ve v\u0161edn\u00ed dny. Aktivoval funkci obnovy na \u00farovni tabulky a \u00fakoly pro diferenci\u00e1ln\u00ed z\u00e1lohov\u00e1n\u00ed selh\u00e1valy. <\/p>\n<p>Pod\u00edv\u00e1me se, jak bude samotn\u00e1 obnova vypadat.<br \/>\n1. Spus\u0165te obnovu na pot\u0159ebn\u00e9m agentovi.<br \/>\n<img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/52a9fb15bbffc0d9cd9c03310659bdc2.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n2. V otev\u0159en\u00e9m okn\u011b p\u0159ejd\u011bte na z\u00e1lo\u017eku <b>Pokro\u010dil\u00e9 mo\u017enosti<\/b>. Vyberte <b>SQL Granular Browse \u2014 Zobrazit obsah.<\/b><br \/>\n<img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/c9224f9168d3aa54d47df397b54dd4df.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n3. V otev\u0159en\u00e9m seznamu vyberte datab\u00e1zi, ze kter\u00e9 budeme obnovovat tabulku, a stiskn\u011bte <b>Obnovit granularn\u011b<\/b>.<br \/>\n<img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/e2880687c818458fe1e4eb074e9b68e1.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n4. V dialogov\u00e9m okn\u011b nastavte bod p\u0159ipojen\u00ed datab\u00e1ze z z\u00e1lo\u017en\u00edch soubor\u016f (n\u011bco jako technologie Instant Recovery).<br \/>\nUve\u010fte:<\/p>\n<ul>\n<li>n\u00e1zev pro do\u010dasnou datab\u00e1zi;<\/li>\n<li>jak dlouho uchov\u00e1vat tento bod obnovy v dnech;<\/li>\n<li>server, na kter\u00fd budeme p\u0159ipojovat datab\u00e1zi. V seznamu budou dostupn\u00e9 pouze servery, kter\u00e9 spl\u0148uj\u00ed v\u0161echny pot\u0159ebn\u00e9 podm\u00ednky, o kter\u00fdch jsem mluvil v\u00fd\u0161e: s opera\u010dn\u00edm syst\u00e9mem Windows, nainstalovan\u00fdmi Media Agent a Java Runtime Environment a tak d\u00e1le.<\/li>\n<\/ul>\n<p>Klikneme na OK.<br \/>\n<img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/424def3390c6c4aafb55dd17b7a10e10.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n5. V nov\u00e9m okn\u011b klikneme na List Recovery Points.<br \/>\n<img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/b44cbeb2d64001dee15f3f9dbf58d5a7.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n6. Otev\u0159e se seznam p\u0159ipojen\u00fdch bod\u016f obnoven\u00ed. Pokud je datab\u00e1ze velk\u00e1, m\u016f\u017ee chv\u00edli trvat, ne\u017e se na\u010dte. Pak klikneme na <b>Proch\u00e1zet<\/b>. Objev\u00ed se okno pro prohl\u00ed\u017een\u00ed tabulek z vybran\u00e9 datab\u00e1ze. <br \/>\n<img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/2671074165684fcdab5843b30e5ffc81.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nPokud se seznam vytv\u00e1\u0159\u00ed, \u010dasto zav\u00edraj\u00ed dialogov\u00e9 okno Recovery Points a pak se nemohou vr\u00e1tit zp\u011bt. Je to jednoduch\u00e9: klikn\u011bte prav\u00fdm tla\u010d\u00edtkem na instanci SQL serveru, kde byl spu\u0161t\u011bn proces p\u0159ipojen\u00ed bodu obnoven\u00ed. P\u0159ejd\u011bte do All Tasks a vyberte List Recovery Points.<br \/>\n<img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/a16653578b1527c220db5911a4d77ea2.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n7. Pokud je mnoho tabulek, m\u016f\u017ee trvat n\u011bjak\u00fd \u010das, ne\u017e se zobraz\u00ed. Nap\u0159\u00edklad pro datab\u00e1zi o velikosti 40 GB se seznam vytv\u00e1\u0159\u00ed p\u0159ibli\u017en\u011b deset minut. Vybereme pot\u0159ebnou tabulku, klikneme na Recover All Selected. <br \/>\n<img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/c3e8a0eebf2c9d18d49f8a50a68d2c70.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n8. V nov\u00e9m okn\u011b vybereme datab\u00e1zi, do kter\u00e9 budeme obnovovat tabulku(y). V na\u0161em p\u0159\u00edpad\u011b je to datab\u00e1ze GPI TEST.<br \/>\n<img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/c5adb9729db830b65ced5669a868bdaa.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n9. Po dokon\u010den\u00ed obnoven\u00ed se ve datab\u00e1zi GPI TEST objev\u00ed vybran\u00e9 tabulky.<br \/>\n<img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/3fa2d3f1119bf9246bfc8676d68343cb.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nPo obnoven\u00ed tabulky do do\u010dasn\u00e9 datab\u00e1ze je lze p\u0159esunout do p\u016fvodn\u00ed datab\u00e1ze pomoc\u00ed Management Studio. <\/p>\n<h3>Plug-in od Commvault pro SQL Management Studio<\/h3>\n<p>\nSpr\u00e1vci datab\u00e1z\u00ed nemaj\u00ed v\u017edy p\u0159\u00edstup do syst\u00e9mu z\u00e1lohov\u00e1n\u00ed (SZ). N\u011bkdy je pot\u0159eba n\u011bco ud\u011blat rychle a administr\u00e1tor SZ nen\u00ed na m\u00edst\u011b. S pomoc\u00ed plug-inu Commvault pro SQL Management Studio bude spr\u00e1vce DB schopen prov\u00e1d\u011bt z\u00e1kladn\u00ed \u00fakony z\u00e1lohov\u00e1n\u00ed a obnovy dat. <\/p>\n<p><b>Verze SQL Management Studio<\/b><\/p>\n<p><b>P\u0159\u00edkaz<\/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>Verze SQL server\u016f, kter\u00e9 podporuj\u00ed plug-in Commvault a p\u0159\u00edkazy, kter\u00e9 aktivuj\u00ed funk\u010dnost plug-inu. Plug-in je podporov\u00e1n pouze na 64-bitov\u00e9 verzi opera\u010dn\u00edho syst\u00e9mu Windows.<\/i><\/p>\n<p>1. Provedeme p\u0159\u00edkaz, kter\u00fd odpov\u00edd\u00e1 na\u0161\u00ed verzi SQL Server:<br \/>\n<img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/0ee5cef1d319279dc40eb75fae82af59.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n2. Nyn\u00ed jsou v Management Studio dostupn\u00e9 mo\u017enosti z\u00e1lohov\u00e1n\u00ed a obnovy. K tomu je t\u0159eba kliknout prav\u00fdm tla\u010d\u00edtkem my\u0161i na po\u017eadovanou datab\u00e1zi.<br \/>\nAdministr\u00e1tor takto z\u00edskal mo\u017enost p\u0159\u00edmo interagovat s rezervn\u00edmi kopiemi t\u00e9to datab\u00e1ze bez pou\u017eit\u00ed konzole Commvault a bez \u017e\u00e1dost\u00ed o pomoc spr\u00e1vci SRK.<br \/>\n<img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/38141c9c785d772532103abd9e7f9174.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n3. P\u0159i spu\u0161t\u011bn\u00ed jak\u00e9koli z dostupn\u00fdch funkc\u00ed tohoto menu se zobraz\u00ed okno s v\u00fdzvou k zad\u00e1n\u00ed u\u017eivatelsk\u00e9ho jm\u00e9na a hesla. Pro p\u0159ipojen\u00ed k CommServe se pou\u017e\u00edv\u00e1 SSO nebo jak\u00fdkoli jin\u00fd \u00fa\u010det v \u010d\u00e1sti Security v Commserve (p\u0159ihl\u00e1\u0161en\u00ed do Commcell).<br \/>\n<img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/ed666299970851e81cd407680f57a92a.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/af7596ca8dfee7d20a3b2a57b0261b5b.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n4. Pokud byly p\u0159ihla\u0161ovac\u00ed \u00fadaje zad\u00e1ny spr\u00e1vn\u011b a opr\u00e1vn\u011bn\u00ed jsou dostate\u010dn\u00e1, spr\u00e1vce DB m\u016f\u017ee:<br \/>\n \u2014 spustit mimo\u0159\u00e1dn\u00e9 z\u00e1lohov\u00e1n\u00ed (Backup);<br \/>\n \u2014 obnovit datab\u00e1zi ze z\u00e1lohy (Restore);<br \/>\n \u2014 zobrazit historii proveden\u00fdch \u00faloh (View History) a sledovat pr\u016fb\u011bh \u00faloh v procesu vykon\u00e1v\u00e1n\u00ed (Job monitor).<br \/>\n<img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/77dff526a444c773da617ee3562adda3.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Takto v Management Studio vypad\u00e1 historie proveden\u00fdch z\u00e1loh pro vybranou datab\u00e1zi.<\/i><\/p>\n<p><img decoding=\"async\" alt=\"Z\u00e1lohov\u00e1n\u00ed MS SQL: n\u011bkolik u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed\" src=\"\/wp-content\/uploads\/2019\/04\/e00d1d3d570cdfce7be693caaba381e2.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Menu pro obnovu datab\u00e1ze. Ani se neli\u0161\u00ed od menu konzole.<\/i><\/p>\n<p>To je v\u0161e o t\u011bchto dvou funkc\u00edch SQL agenta od Commvault. Dod\u00e1m, \u017ee z\u00e1lohov\u00e1n\u00ed pomoc\u00ed Commvault je vhodn\u011bj\u0161\u00ed pro ty, kte\u0159\u00ed spravuj\u00ed des\u00edtky server\u016f, s n\u011bkolika instancemi a datab\u00e1zemi, z nich\u017e n\u011bkter\u00e9 mohou b\u00fdt na r\u016fzn\u00fdch lokalit\u00e1ch a vy\u017eaduj\u00ed nastaven\u00ed r\u016fzn\u00fdch \u010dasov\u00fdch pl\u00e1n\u016f, hloubky atd. Pokud m\u00e1te dva servery, sta\u010d\u00ed na z\u00e1lohu i integrovan\u00e9 n\u00e1stroje MS SQL.<\/p>\n<p>Zdroj: <noindex><a rel=\"nofollow\" href=\"http:\/\/documentation.commvault.com\/commvault\/v11\/article?p=18110.htm\">documentation.commvault.com<\/a><\/noindex><br \/>\n<br \/>Zdroj: <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.3 - 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\/cs\/blog\/administrirovanie\/rezervnoe-kopirovanie-ms-sql-para-poleznyh-funktsij-commvault-pro-kotorye-ne-vse-znayut\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"cs_CZ\" \/>\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\/cs\/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\udd47Z\u00e1lohov\u00e1n\u00ed MS SQL: p\u00e1r u\u017eite\u010dn\u00fdch funkc\u00ed Commvault, o kter\u00fdch ne ka\u017ed\u00fd v\u00ed | ProHoster","description":"Dnes.","canonical_url":"https:\/\/prohoster.info\/cs\/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":"cs_CZ","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\/cs\/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\/cs\/wp-json\/wp\/v2\/posts\/31297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=31297"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/31297\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media\/23263"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=31297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=31297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=31297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}