{"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\/sq\/blog\/administrirovanie\/rezervnoe-kopirovanie-ms-sql-para-poleznyh-funktsij-commvault-pro-kotorye-ne-vse-znayut","title":{"rendered":"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/ebdc042c384f7b3f924eebae96420b62.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nSot dit\u00ebn sot do t\u00eb flas p\u00ebr dy mund\u00ebsi t\u00eb Commvault p\u00ebr backup-in e MS SQL, t\u00eb cilat jan\u00eb shpesh t\u00eb n\u00ebnvler\u00ebsuara: rikuperimi granular dhe plugini Commvault p\u00ebr SQL Management Studio. Nuk do t\u00eb diskutoj pika bazike t\u00eb konfigurimit. Ky post \u00ebsht\u00eb kryesisht p\u00ebr ata q\u00eb tashm\u00eb din\u00eb si t\u00eb instalojn\u00eb agjentin, t\u00eb konfigurjn\u00eb orare, politika, etj. Kam folur p\u00ebr m\u00ebnyr\u00ebn se si funksionon Commvault dhe \u00e7far\u00eb mund t\u00eb b\u00ebj\u00eb, n\u00eb k\u00ebt\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/dataline\/blog\/318188\/\">post<\/a><\/noindex>.<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h3>Rikuperimi Granular<\/h3>\n<p>\nOpcioni <b>rikuperimi n\u00eb nivel tabelash<\/b> u shfaq n\u00eb pron\u00ebsit\u00eb e Subclient-it relativisht koh\u00ebt e fundit. Ajo lejon aktivizimin e mund\u00ebsis\u00eb p\u00ebr rikuperimin e tabelave nga databaza, pa rikuperuar t\u00eb gjith\u00eb databaz\u00ebn nga backup-i. Kjo \u00ebsht\u00eb e dobishme, kur dihet sakt\u00ebsisht ku ndodhet gabimi ose humbja e t\u00eb dh\u00ebnave. Nd\u00ebrkoh\u00eb, vet\u00eb baza \u00ebsht\u00eb e madhe dhe rikuperimi i saj t\u00ebr\u00ebsisht do t\u00eb marr\u00eb shum\u00eb koh\u00eb. <br \/>\n<img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/76042dd0108a74fa549618971e890f4e.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nKjo opsion ka disa kufizime: <br \/>\n \u2014 Tabelat nuk mund t\u00eb rikuperohen n\u00eb baz\u00ebn origjinale, vet\u00ebm n\u00eb nj\u00eb tjet\u00ebr. \u00a0<br \/>\n \u2014 T\u00eb gjitha tabelat rikuperohen n\u00eb skem\u00ebn dbo. Nj\u00eb tabel\u00eb nuk mund t\u00eb rikuperohet n\u00eb nj\u00eb skem\u00eb t\u00eb p\u00ebrdoruesit.<br \/>\n \u2014 Mb\u00ebshtetet vet\u00ebm llogaria lokale n\u00eb SQL-server me t\u00eb drejta admini sistemik.<br \/>\n \u2014 Serveri target, ku rikuperohet tabela, duhet t\u00eb funksionoj\u00eb n\u00eb sistemin operativ Windows.<br \/>\n \u2014 N\u00eb serverin target, p\u00ebrve\u00e7 agjentit SQL, duhet t\u00eb jen\u00eb instaluar Media Agent dhe Java Runtime Environment.<br \/>\n \u2014 Baza e t\u00eb dh\u00ebnave duhet t\u00eb p\u00ebrdor\u00eb modelin e rikuperimit n\u00eb m\u00ebnyr\u00eb t\u00eb Plot\u00eb. <br \/>\n \u2014 N\u00ebse opsioni i rikuperimit granular t\u00eb DB \u00ebsht\u00eb aktivizuar, humbet mund\u00ebsia p\u00ebr t\u00eb ekzekutuar pun\u00ebt p\u00ebr backup-in diferencial. \u00a0<\/p>\n<p><img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/f01c21078b9f84845593aec9d10a93ec.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Opsioni i rikuperimit n\u00eb nivel tabelash \u00ebsht\u00eb i fikur.<\/i><\/p>\n<p><img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/0c7f2fa2af05f4cdaa1c966a6cd1ef0f.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Opsioni i rikuperimit n\u00eb nivel tabelash \u00ebsht\u00eb i fikur.<\/i><\/p>\n<p>N\u00eb praktik\u00ebn time kishte nj\u00eb rast, kur nj\u00eb klient kishte konfigurur orarin e m\u00ebposht\u00ebm p\u00ebr SQL-server: nj\u00eb backup i plot\u00eb nj\u00eb her\u00eb n\u00eb jav\u00eb dhe 6 backup-e diferenciale gjat\u00eb dit\u00ebve t\u00eb pun\u00ebs. Ai aktivizoi funksionin e rikuperimit n\u00eb nivel tabelash, dhe pun\u00ebt p\u00ebr backup-in diferencial u ekzekutuan me gabim. <\/p>\n<p>T\u00eb shohim se si do t\u00eb duket rikuperimi i vet\u00eb.<br \/>\n1. Nisni rikuperimin n\u00eb agjentin e nevojsh\u00ebm.<br \/>\n<img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/52a9fb15bbffc0d9cd9c03310659bdc2.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n2. N\u00eb dritaren q\u00eb shfaqet, kaloni n\u00eb tab-in <b>Opsionet e Avancuara<\/b>. Zgjidhni <b>SQL Granular Browse \u2014 Shiko P\u00ebrmbajtjen.<\/b><br \/>\n<img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/c9224f9168d3aa54d47df397b54dd4df.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n3. N\u00eb list\u00ebn e hapur zgjidhni databaz\u00ebn nga e cila do t\u00eb rikuperoni tabel\u00ebn, dhe klikoni <b>Rikupero Granular<\/b>.<br \/>\n<img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/e2880687c818458fe1e4eb074e9b68e1.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n4. N\u00eb dritaren e dialogut, konfiguroni pik\u00ebn e montimit t\u00eb databaz\u00ebs nga skedar\u00ebt e backup-it (di\u00e7ka si teknologjia Instant Recovery).<br \/>\nSh\u00ebnoni:<\/p>\n<ul>\n<li>emrin p\u00ebr databaz\u00ebn p\u00ebrkoh\u00ebsisht;<\/li>\n<li>sa e gjat\u00eb duhet t\u00eb mbajm\u00eb k\u00ebt\u00eb pik\u00eb rikuperimi n\u00eb dit\u00eb;<\/li>\n<li>serveri ku do t\u00eb montojm\u00eb baz\u00ebn e t\u00eb dh\u00ebnave. N\u00eb list\u00eb do t\u00eb jen\u00eb t\u00eb disponueshme vet\u00ebm server\u00ebt q\u00eb plot\u00ebsojn\u00eb t\u00eb gjitha kushtet e nevojshme q\u00eb p\u00ebrmenda m\u00eb lart: me sistemin operativ Windows, me Agentin e Mediave dhe Java Runtime Environment t\u00eb instaluar etj.<\/li>\n<\/ul>\n<p>Klikoni OK.<br \/>\n<img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/424def3390c6c4aafb55dd17b7a10e10.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n5. N\u00eb dritaren e re, klikoni mbi List Recovery Points.<br \/>\n<img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/b44cbeb2d64001dee15f3f9dbf58d5a7.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n6. Do t\u00eb hapet lista e pikave t\u00eb rikuperimit t\u00eb montuara. N\u00ebse baza e t\u00eb dh\u00ebnave \u00ebsht\u00eb e madhe, do t'ju duhet t\u00eb prisni. M\u00eb pas, klikoni <b>Browse<\/b>. Do t\u00eb shfaqet nj\u00eb dritare p\u00ebr t\u00eb par\u00eb tabelat nga baza e t\u00eb dh\u00ebnave t\u00eb zgjedhur. <br \/>\n<img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/2671074165684fcdab5843b30e5ffc81.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nNd\u00ebrsa formohet lista, shpesh dialogu i pikave t\u00eb rikuperimit mbyllet, dhe pastaj nuk arrijn\u00eb t\u00eb kthehen p\u00ebrs\u00ebri. \u00cbsht\u00eb e thjesht\u00eb: klikoni me t\u00eb djatht\u00ebn mbi instanc\u00ebn e serverit SQL, ku \u00ebsht\u00eb nisur procesi i montimit t\u00eb pik\u00ebs s\u00eb rikuperimit. Shkoni te All Tasks dhe zgjidhni List Recovery Points.<br \/>\n<img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/a16653578b1527c220db5911a4d77ea2.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n7. N\u00ebse ka shum\u00eb tabela, mund t\u00eb jet\u00eb e nevojshme disa minuta p\u00ebr t'i shfaqur ato. P\u00ebr shembull, p\u00ebr nj\u00eb baz\u00eb t\u00eb dh\u00ebnash prej 40 GB, lista formohet p\u00ebr rreth dhjet\u00eb minuta. Zgjidhni tabel\u00ebn e nevojshme, klikoni Recover All Selected. <br \/>\n<img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/c3e8a0eebf2c9d18d49f8a50a68d2c70.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n8. N\u00eb dritaren e re, zgjidhni baz\u00ebn ku do t\u00eb rikuperoni tabel\u00ebn(t). N\u00eb rastin ton\u00eb \u2014 kjo \u00ebsht\u00eb baza GPI TEST.<br \/>\n<img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/c5adb9729db830b65ced5669a868bdaa.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n9. Pas p\u00ebrfundimit t\u00eb rikuperimit, tabelat e zgjedhura do t\u00eb shfaqen n\u00eb baz\u00ebn GPI TEST.<br \/>\n<img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/3fa2d3f1119bf9246bfc8676d68343cb.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nPasi tabela t\u00eb rikuperohet n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave t\u00eb p\u00ebrkohshme, ajo mund t\u00eb transferohet n\u00eb baz\u00ebn origjinale p\u00ebrmes Management Studio. <\/p>\n<h3>Plug-in nga Commvault p\u00ebr SQL Management Studio<\/h3>\n<p>\nAdministrator\u00ebt e bazave t\u00eb t\u00eb dh\u00ebnave nuk kan\u00eb gjithmon\u00eb qasje n\u00eb sistemin e rezervimit (SRK). Ndonj\u00ebher\u00eb \u00ebsht\u00eb e nevojshme t\u00eb b\u00ebni dicka urgjente, por administratori i SRK nuk \u00ebsht\u00eb n\u00eb vend. Me ndihm\u00ebn e plug-in-it Commvault p\u00ebr SQL Management Studio, administratori i B.D. do t\u00eb jet\u00eb n\u00eb gjendje t\u00eb kryej\u00eb veprime bazike t\u00eb rezervimit dhe rikuperimit t\u00eb t\u00eb dh\u00ebnave. <\/p>\n<p><b>QL Management Studio Version<\/b><\/p>\n<p><b>Komand\u00eb<\/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>Versionet e SQL-server\u00ebve q\u00eb mb\u00ebshtesin plug-in-in Commvault dhe komandat q\u00eb aktivizojn\u00eb funksionimin e tij. Plug-in-i mb\u00ebshtetet vet\u00ebm n\u00eb versionin 64-bit t\u00eb sistemit operativ Windows.<\/i><\/p>\n<p>1. Kryeni komand\u00ebn q\u00eb p\u00ebrputhet me versionin ton\u00eb t\u00eb serverit SQL:<br \/>\n<img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/0ee5cef1d319279dc40eb75fae82af59.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n2. Tani, n\u00eb Management Studio jan\u00eb b\u00ebr\u00eb t\u00eb disponueshme opsionet p\u00ebr rezervimin dhe rikuperimin. P\u00ebr k\u00ebt\u00eb, \u00ebsht\u00eb e nevojshme t\u00eb klikoni me t\u00eb djatht\u00ebn mbi baz\u00ebn e t\u00eb dh\u00ebnave t\u00eb nevojshme.<br \/>\nK\u00ebshtu, administratori kishte mund\u00ebsin\u00eb p\u00ebr t\u00eb bashk\u00ebvepruar drejtp\u00ebrdrejt me kopjet rezerv\u00eb t\u00eb k\u00ebsaj baze t\u00eb dh\u00ebnash pa p\u00ebrdorur konsol\u00ebn Commvault dhe pa u drejtuar tek administratori i SRK.<br \/>\n<img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/38141c9c785d772532103abd9e7f9174.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n3. Kur t\u00eb aktivizohet cilido nga funksionet e disponueshme t\u00eb k\u00ebtij meniu, do t\u00eb shfaqet nj\u00eb dritare p\u00ebr k\u00ebrkes\u00ebn e emrit t\u00eb p\u00ebrdoruesit dhe fjal\u00ebkalimit. P\u00ebr lidhjen me CommServe p\u00ebrdoret SSO ose ndonj\u00eb llogari tjet\u00ebr nga seksioni Siguria n\u00eb Commserve (Commcell login).<br \/>\n<img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/ed666299970851e81cd407680f57a92a.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/af7596ca8dfee7d20a3b2a57b0261b5b.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n4. N\u00ebse t\u00eb dh\u00ebnat e aksesit jan\u00eb futur sakt\u00eb dhe ka t\u00eb drejta t\u00eb mjaftueshme, administratori i DB-s\u00eb mund:<br \/>\n \u2014 t\u00eb aktivizoj\u00eb nj\u00eb kopjim rezerv\u00eb t\u00eb jasht\u00ebzakonsh\u00ebm (Backup);<br \/>\n \u2014 t\u00eb rikthej\u00eb baz\u00ebn nga kopja rezerv\u00eb (Restore);<br \/>\n \u2014 t\u00eb shikoj\u00eb historikun e detyrave t\u00eb realizuara (View History) dhe progresin e detyrave n\u00eb proces (Job monitor).<br \/>\n<img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/77dff526a444c773da617ee3562adda3.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>K\u00ebshtu duket historia e detyrave t\u00eb realizuara t\u00eb kopjimit rezerv\u00eb p\u00ebr baz\u00ebn e dh\u00ebnash t\u00eb zgjedhur n\u00eb Management Studio.<\/i><\/p>\n<p><img decoding=\"async\" alt=\"Backup MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk jan\u00eb t\u00eb gjith\u00eb t\u00eb informuar\" src=\"\/wp-content\/uploads\/2019\/04\/e00d1d3d570cdfce7be693caaba381e2.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Meniu p\u00ebr rikthimin e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave. Ajo as q\u00eb ndryshon nga menuja e konsol\u00ebs.<\/i><\/p>\n<p>Kjo \u00ebsht\u00eb e gjitha p\u00ebr k\u00ebto dy mund\u00ebsi t\u00eb agentit SQL nga Commvault. Do t\u00eb shtoja se kopjimi rezerv\u00eb me mjete t\u00eb Commvault \u00ebsht\u00eb m\u00eb i p\u00ebrshtatsh\u00ebm p\u00ebr ata q\u00eb menaxhojn\u00eb dhjet\u00ebra server\u00eb, me disa instance dhe DB, ndoshta t\u00eb gjith\u00eb kjo n\u00eb lokacione t\u00eb ndryshme dhe k\u00ebrkon konfigurimin e orar\u00ebve t\u00eb ndrysh\u00ebm, thell\u00ebsis\u00eb etj. N\u00ebse keni disa server\u00eb, mjete t\u00eb MS SQL brenda do t\u00eb mjaftojn\u00eb p\u00ebr kopjimin.<\/p>\n<p>Burimi: <noindex><a rel=\"nofollow\" href=\"http:\/\/documentation.commvault.com\/commvault\/v11\/article?p=18110.htm\">documentation.commvault.com<\/a><\/noindex><br \/>\n<br \/>Burimi: <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\/sq\/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=\"sq_AL\" \/>\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\/sq\/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\udd47Kopjimi rezerv\u00eb i MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk din\u00eb t\u00eb gjith\u00eb | ProHoster","description":"Sot.","canonical_url":"https:\/\/prohoster.info\/sq\/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":"sq_AL","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\/sq\/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\/sq\/wp-json\/wp\/v2\/posts\/31297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=31297"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/31297\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/23263"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=31297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=31297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=31297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}