{"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":"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" src=\"\/wp-content\/uploads\/2019\/04\/ebdc042c384f7b3f924eebae96420b62.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nSot do flas p\u00ebr dy mund\u00ebsi t\u00eb Commvault p\u00ebr backup-in e MS SQL, t\u00eb cilat shpesh anashkalohen pa arsye: rikuperimi granular dhe plugin-i Commvault p\u00ebr SQL Management Studio. Nuk do t\u00eb shqyrtoj aspektet baz\u00eb t\u00eb konfigurimit. Ky postim \u00ebsht\u00eb m\u00eb shum\u00eb p\u00ebr ata q\u00eb already din\u00eb si t\u00eb instalojn\u00eb agjent\u00ebt, t\u00eb konfigurojn\u00eb orarit, politikat, etj. Thash\u00eb m\u00eb par\u00eb p\u00ebr at\u00eb se si funksionon Commvault dhe \u00e7far\u00eb mund t\u00eb b\u00ebj\u00eb. <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/dataline\/blog\/318188\/\">postin<\/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 relativisht koh\u00ebt e fundit. Ajo lejon aktivizimin e mund\u00ebsis\u00eb p\u00ebr rikuperimin e tabelave nga baza e t\u00eb dh\u00ebnave pa rikuperuar t\u00eb gjith\u00eb baz\u00ebn nga backup-i. Kjo \u00ebsht\u00eb e dobishme kur e di sakt\u00ebsisht ku ndodhet gabimi ose humbja e t\u00eb dh\u00ebnave. Nd\u00ebrkoh\u00eb, baza vet\u00eb \u00ebsht\u00eb e madhe dhe rikuperimi i saj t\u00ebr\u00eb do t\u00eb marr\u00eb shum\u00eb koh\u00eb. <br \/>\n<img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" src=\"\/wp-content\/uploads\/2019\/04\/76042dd0108a74fa549618971e890f4e.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nKjo mund\u00ebsi ka disa kufizime: <br \/>\n \u2014 Tabelat nuk mund t\u00eb rikuperohen n\u00eb baz\u00ebn e dh\u00ebnave origjinale, vet\u00ebm n\u00eb nj\u00eb tjet\u00ebr. \u00a0<br \/>\n \u2014 T\u00eb gjitha tabelat rikuperohen n\u00eb skem\u00ebn dbo. Tabela nuk mund t\u00eb rikuperohet n\u00eb nj\u00eb skem\u00eb p\u00ebrdoruesi.<br \/>\n \u2014 Mb\u00ebshtetet vet\u00ebm llogaria lokale e SQL-serverit me t\u00eb drejta administratori sistematik.<br \/>\n \u2014 Serveri objektiv, ku do t\u00eb rikuperojm\u00eb tabel\u00ebn, duhet t\u00eb funksionoj\u00eb n\u00eb sistemin operativ Windows.<br \/>\n \u2014 N\u00eb serverin objektiv, p\u00ebrve\u00e7 agjentit SQL, duhet t\u00eb jen\u00eb instalur 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 \u00ebsht\u00eb aktivizuar mund\u00ebsia e rikuperimit granular t\u00eb BD-s\u00eb, humb mund\u00ebsin\u00eb p\u00ebr t\u00eb analizuar detyrat e backup-it diferencial. \u00a0<\/p>\n<p><img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" src=\"\/wp-content\/uploads\/2019\/04\/f01c21078b9f84845593aec9d10a93ec.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Mund\u00ebsia e rikuperimit n\u00eb nivel tabelash \u00ebsht\u00eb e \u00e7aktivizuar.<\/i><\/p>\n<p><img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" src=\"\/wp-content\/uploads\/2019\/04\/0c7f2fa2af05f4cdaa1c966a6cd1ef0f.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Mund\u00ebsia e rikuperimit n\u00eb nivel tabelash \u00ebsht\u00eb e \u00e7aktivizuar.<\/i><\/p>\n<p>N\u00eb praktik\u00ebn time kishte nj\u00eb rast kur klienti p\u00ebr SQL-server kishte konfiguruar orarin e m\u00ebposht\u00ebm: nj\u00eb backup t\u00eb plot\u00eb nj\u00eb her\u00eb n\u00eb jav\u00eb dhe 6 backup-e diferenciale n\u00eb dit\u00ebt e jav\u00ebs. Ai aktivizoi funksionin e rikuperimit n\u00eb nivel tabelash, dhe detyrat p\u00ebr backup-in diferencial d\u00ebshtuan. <\/p>\n<p>Le t\u00eb shohim si do t\u00eb duket vet\u00eb rikuperimi.<br \/>\n1. Nisemi rikuperimin n\u00eb agjentin e nevojsh\u00ebm.<br \/>\n<img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" src=\"\/wp-content\/uploads\/2019\/04\/52a9fb15bbffc0d9cd9c03310659bdc2.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n2. N\u00eb dritaren e shfaqur kalojm\u00eb n\u00eb tabin <b>Mund\u00ebsi t\u00eb Avancuara<\/b>. Zgjidhni <b>SQL Granular Browse \u2014 Shiko p\u00ebrmbajtjen.<\/b><br \/>\n<img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" src=\"\/wp-content\/uploads\/2019\/04\/c9224f9168d3aa54d47df397b54dd4df.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n3. N\u00eb list\u00ebn e hapur zgjedhim baz\u00ebn nga e cila do t\u00eb rikuperojm\u00eb tabel\u00ebn dhe shtypim <b>Rikupero Granular<\/b>.<br \/>\n<img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" src=\"\/wp-content\/uploads\/2019\/04\/e2880687c818458fe1e4eb074e9b68e1.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n4. N\u00eb dritaren e bised\u00ebs, konfigurojm\u00eb pik\u00ebn e montimit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave nga skedar\u00ebt e backup-it (di\u00e7ka si teknologjia Instant Recovery).<br \/>\nSpecifikojm\u00eb:<\/p>\n<ul>\n<li>emrin p\u00ebr baz\u00ebn e t\u00eb dh\u00ebnave p\u00ebrkohshme;<\/li>\n<li>sa dit\u00eb do ta mbajm\u00eb k\u00ebt\u00eb pik\u00eb rikuperimi;<\/li>\n<li>serverin, ku do t\u00eb montojm\u00eb baz\u00ebn e t\u00eb dh\u00ebnave. N\u00eb list\u00eb do t\u00eb jen\u00eb n\u00eb dispozicion vet\u00ebm serverat q\u00eb p\u00ebrmbushin t\u00eb gjitha kushtet e nevojshme, p\u00ebr t\u00eb cilat kam folur m\u00eb lart: me sistemin operativ Windows, me Media Agent dhe Java Runtime Environment t\u00eb instaluar etj.<\/li>\n<\/ul>\n<p>Shtypim OK.<br \/>\n<img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" src=\"\/wp-content\/uploads\/2019\/04\/424def3390c6c4aafb55dd17b7a10e10.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n5. N\u00eb dritar\u00ebn e re klikojm\u00eb mbi Listo Pikat e Rikuperimit.<br \/>\n<img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" src=\"\/wp-content\/uploads\/2019\/04\/b44cbeb2d64001dee15f3f9dbf58d5a7.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n6. Do t\u00eb hapet nj\u00eb list\u00eb e pikave t\u00eb rikuperimit t\u00eb montuara. N\u00ebse baza e t\u00eb dh\u00ebnave \u00ebsht\u00eb e madhe, do t\u00eb duhet t\u00eb presim. Pastaj klikohet <b>Shiko<\/b>. Do t\u00eb shfaqet nj\u00eb dritare p\u00ebr t\u00eb par\u00eb tabelat nga baza e p\u00ebrzgjedhur. <br \/>\n<img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" src=\"\/wp-content\/uploads\/2019\/04\/2671074165684fcdab5843b30e5ffc81.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nGjat\u00eb formimit t\u00eb list\u00ebs, shpesh dialogu i Pikave t\u00eb Rikuperimit mbyllet, dhe pastaj nuk arrijn\u00eb t\u00eb kthehen s\u00ebrish. E gjith\u00eb kjo \u00ebsht\u00eb e thjesht\u00eb: klikoni me butonin e djatht\u00eb mbi instanc\u00ebn e SQL-serverit, ku u nisi procesi i montimit t\u00eb pik\u00ebs s\u00eb rikuperimit. Kaloni n\u00eb t\u00eb gjitha detyrat dhe zgjidhni Listo Pikat e Rikuperimit.<br \/>\n<img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" src=\"\/wp-content\/uploads\/2019\/04\/a16653578b1527c220db5911a4d77ea2.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n7. N\u00ebse ka shum\u00eb tabela, p\u00ebrpara se t\u00eb shfaqen, mund t\u00eb nevojitet pak koh\u00eb. P\u00ebr shembull, p\u00ebr nj\u00eb baz\u00eb t\u00eb dh\u00ebnash prej 40 GB lista formohet n\u00eb nj\u00ebzet minuta. Zgjidhni tabel\u00ebn e nevojshme, klikoni Rikupero t\u00eb gjitha t\u00eb p\u00ebrzgjedhura. <br \/>\n<img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" 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 n\u00eb t\u00eb cil\u00ebn do t\u00eb rikuperoni tabel\u00ebn(-at). N\u00eb rastin ton\u00eb, kjo \u00ebsht\u00eb baza GPI TEST.<br \/>\n<img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" src=\"\/wp-content\/uploads\/2019\/04\/c5adb9729db830b65ced5669a868bdaa.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n9. Pasi t\u00eb p\u00ebrfundoj\u00eb rikuperimi, n\u00eb baz\u00ebn GPI TEST do t\u00eb shfaqen tabelat e p\u00ebrzgjedhura.<br \/>\n<img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" src=\"\/wp-content\/uploads\/2019\/04\/3fa2d3f1119bf9246bfc8676d68343cb.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nPas rikuperimit t\u00eb tabel\u00ebs n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave p\u00ebrkohshme, ajo mund t\u00eb transferohet n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave origjinale p\u00ebrmes mjeteve t\u00eb Management Studio. <\/p>\n<h3>Plugin-i 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 backup-it. Ndonj\u00ebher\u00eb \u00ebsht\u00eb e nevojshme t\u00eb b\u00ebsh di\u00e7ka urgjente, nd\u00ebrsa administratori i backup-it nuk \u00ebsht\u00eb n\u00eb vend. Me ndihm\u00ebn e plugin-it Commvault p\u00ebr SQL Management Studio, administratori i BD-s\u00eb do t\u00eb mund t\u00eb kryej\u00eb veprimet baz\u00eb p\u00ebr backup-in dhe rikuperimin e t\u00eb dh\u00ebnave. <\/p>\n<p><b>QL Management Studio Version<\/b><\/p>\n<p><b>Komanda<\/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-serverave q\u00eb mb\u00ebshtesin Commvault Plug-in dhe komandat q\u00eb aktivizojn\u00eb funksionimin e plugin-it. Plugin-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 SQL server:<br \/>\n<img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" 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 backup-in dhe rikuperimin. P\u00ebr k\u00ebt\u00eb, duhet t\u00eb klikoni me butonin e djatht\u00eb mbi baz\u00ebn e t\u00eb dh\u00ebnave t\u00eb nevojshme.<br \/>\nK\u00ebshtu, administratorit iu dha mund\u00ebsia t\u00eb nd\u00ebrveproj\u00eb drejtp\u00ebrdrejt me kopjet rezerv\u00eb t\u00eb k\u00ebtij database pa pasur nevoj\u00ebn p\u00ebr konsol\u00ebn Commvault dhe pa u drejtuar te administratori i SRK.<br \/>\n<img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" src=\"\/wp-content\/uploads\/2019\/04\/38141c9c785d772532103abd9e7f9174.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n3. Kur t\u00eb aktivizohet ndonj\u00eb nga funksionet e disponueshme n\u00eb k\u00ebt\u00eb menu, do t\u00eb shfaqet nj\u00eb dritare q\u00eb k\u00ebrkon emrin e p\u00ebrdoruesit dhe fjal\u00ebkalimin. 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=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" src=\"\/wp-content\/uploads\/2019\/04\/ed666299970851e81cd407680f57a92a.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" 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 identifikimit jan\u00eb futur si\u00e7 duhet dhe ka mjaft t\u00eb drejta qasje, administratori i DB-s\u00eb mund t\u00eb:<br \/>\n \u2014 aktivizoj\u00eb nj\u00eb kopjim jasht\u00ebzakonsh\u00ebm (Backup);<br \/>\n \u2014 rikthej\u00eb baz\u00ebn nga nj\u00eb kopje rezerv\u00eb (Restore);<br \/>\n \u2014 shikoj\u00eb historin\u00eb e detyrave t\u00eb kryera (View History) dhe progresin e detyrave n\u00eb proces (Job monitor).<br \/>\n<img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" 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 kryera p\u00ebr kopjim nga Management Studio p\u00ebr baz\u00ebn e dh\u00ebnash t\u00eb p\u00ebrzgjedhur.<\/i><\/p>\n<p><img decoding=\"async\" alt=\"B\u00ebrja e kopjave rezerv\u00eb t\u00eb MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, t\u00eb cilat nuk i di \u00e7do njeri\" src=\"\/wp-content\/uploads\/2019\/04\/e00d1d3d570cdfce7be693caaba381e2.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Menuja p\u00ebr rikthimin e databaz\u00ebs. Ajo madje nuk ndryshon nga menuja e konsol\u00ebs.<\/i><\/p>\n<p>Kjo \u00ebsht\u00eb gjith\u00e7ka p\u00ebr k\u00ebto dy mund\u00ebsi t\u00eb agentit SQL nga Commvault. Do t\u00eb shtoja se kopjimi me mjetet e Commvault \u00ebsht\u00eb m\u00eb i p\u00ebrshtatsh\u00ebm p\u00ebr ata q\u00eb mbajn\u00eb qindra servera, me disa instanca dhe DB, ndoshta n\u00eb vende t\u00eb ndryshme dhe k\u00ebrkon konfigurimin e orareve t\u00eb ndryshme, thell\u00ebsive etj. N\u00ebse keni vet\u00ebm disa servera, at\u00ebher\u00eb p\u00ebr kopjim mjafton edhe mjetet standarde t\u00eb MS SQL.<\/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.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\/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.0.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 \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\/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 i MS SQL: disa funksione t\u00eb dobishme t\u00eb Commvault, p\u00ebr t\u00eb cilat nuk e din\u00eb t\u00eb gjith\u00eb | ProHoster","description":"Sot do t\u00eb flas p\u00ebr dy mund\u00ebsi t\u00eb Commvault p\u00ebr kopjimin e MS SQL, t\u00eb cilat shpesh kalohen pa u v\u00ebn\u00eb re: rikthimi granular dhe plugin-i Commvault p\u00ebr SQL Management Studio. Nuk do t\u00eb diskutoj pika baz\u00eb t\u00eb konfigurimit. Postimi \u00ebsht\u00eb kryesisht p\u00ebr ata q\u00eb tashm\u00eb din\u00eb si t\u00eb instalojn\u00eb agjentin, t\u00eb rregullojn\u00eb oraret, politikat etj. P\u00ebr m\u00ebnyr\u00ebn se si funksionon Commvault dhe \u00e7far\u00eb \u00ebsht\u00eb n\u00eb gjendje, kam folur n\u00eb","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 \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\/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}]}}