{"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\/hu\/blog\/administrirovanie\/rezervnoe-kopirovanie-ms-sql-para-poleznyh-funktsij-commvault-pro-kotorye-ne-vse-znayut","title":{"rendered":"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/ebdc042c384f7b3f924eebae96420b62.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nMa ma a Commvault k\u00e9t lehet\u0151s\u00e9g\u00e9r\u0151l fogok mes\u00e9lni az MS SQL biztons\u00e1gi ment\u00e9s\u00e9hez, amelyeket m\u00e9ltatlanul figyelmen k\u00edv\u00fcl hagynak: a granul\u00e1ris helyre\u00e1ll\u00edt\u00e1s \u00e9s a Commvault plugin az SQL Management Studihoz. Az alapbe\u00e1ll\u00edt\u00e1sokkal nem foglalkozom. A bejegyz\u00e9s ink\u00e1bb azok sz\u00e1m\u00e1ra sz\u00f3l, akik m\u00e1r tudj\u00e1k, hogyan kell telep\u00edteni az \u00fcgyn\u00f6k\u00f6t, be\u00e1ll\u00edtani a menetrendet, politik\u00e1kat stb. Arra, hogy hogyan m\u0171k\u00f6dik a Commvault \u00e9s mit tud, m\u00e1r besz\u00e9ltem ebben a <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/dataline\/blog\/318188\/\">a bejegyz\u00e9sben<\/a><\/noindex>.<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h3>Granul\u00e1ris helyre\u00e1ll\u00edt\u00e1s<\/h3>\n<p>\nOpci\u00f3 <b>t\u00e1blaszint\u0171 helyre\u00e1ll\u00edt\u00e1s<\/b> viszonylag nemr\u00e9g jelent meg a Subclient tulajdons\u00e1gai k\u00f6z\u00f6tt. Lehet\u0151v\u00e9 teszi, hogy a t\u00e1bl\u00e1kat helyre\u00e1ll\u00edtsuk az adatb\u00e1zisb\u00f3l an\u00e9lk\u00fcl, hogy az eg\u00e9sz adatb\u00e1zist vissza kellene \u00e1ll\u00edtanunk a biztons\u00e1gi ment\u00e9sb\u0151l. Ez hasznos, amikor tudod, hol van pontosan a hiba vagy az adatveszt\u00e9s. Ek\u00f6zben maga az adatb\u00e1zis nagy, \u00e9s az eg\u00e9sz helyre\u00e1ll\u00edt\u00e1sa sok id\u0151t vesz ig\u00e9nybe. <br \/>\n<img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/76042dd0108a74fa549618971e890f4e.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nEnnek az opci\u00f3nak vannak korl\u00e1tai: <br \/>\n \u2014 A t\u00e1bl\u00e1kat nem lehet vissza\u00e1ll\u00edtani az eredeti adatb\u00e1zisba, csak egy m\u00e1sikba. \u00a0<br \/>\n \u2014 Minden t\u00e1bla az dbo s\u00e9m\u00e1ba ker\u00fcl vissza\u00e1ll\u00edt\u00e1sra. A t\u00e1bl\u00e1t nem lehet felhaszn\u00e1l\u00f3i s\u00e9m\u00e1ba vissza\u00e1ll\u00edtani.<br \/>\n \u2014 Csak a SQL Server helyi felhaszn\u00e1l\u00f3i fi\u00f3kja t\u00e1mogatott rendszergazdai jogosults\u00e1gokkal.<br \/>\n \u2014 A c\u00e9l szervernek, ahova a t\u00e1bl\u00e1t vissza\u00e1ll\u00edtjuk, Windows OS-en kell futnia.<br \/>\n \u2014 A c\u00e9l szerveren, az SQL \u00fcgyn\u00f6k mellett, Media Agentnek \u00e9s Java Runtime Environmentnek is telep\u00edtve kell lennie.<br \/>\n \u2014 Az adatb\u00e1zisnak teljes Recovery modelt kell haszn\u00e1lni. <br \/>\n \u2014 Ha a BDB granul\u00e1ris helyre\u00e1ll\u00edt\u00e1si opci\u00f3ja enged\u00e9lyezve van, a differenci\u00e1lis biztons\u00e1gi ment\u00e9si feladatok ind\u00edt\u00e1sa lehetetlenn\u00e9 v\u00e1lik. \u00a0<\/p>\n<p><img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/f01c21078b9f84845593aec9d10a93ec.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>A t\u00e1blaszint\u0171 helyre\u00e1ll\u00edt\u00e1s opci\u00f3 ki van kapcsolva.<\/i><\/p>\n<p><img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/0c7f2fa2af05f4cdaa1c966a6cd1ef0f.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>A t\u00e1blaszint\u0171 helyre\u00e1ll\u00edt\u00e1s opci\u00f3 ki van kapcsolva.<\/i><\/p>\n<p>A gyakorlatomban volt egy eset, amikor egy \u00fcgyf\u00e9l sz\u00e1m\u00e1ra az SQL Serverhez a k\u00f6vetkez\u0151 \u00fctemez\u00e9st \u00e1ll\u00edtott\u00e1k be: egy teljes biztons\u00e1gi ment\u00e9s hetente egyszer \u00e9s 6 differenci\u00e1lis biztons\u00e1gi ment\u00e9s a h\u00e9tk\u00f6znapokon. Enged\u00e9lyezte a t\u00e1blaszint\u0171 helyre\u00e1ll\u00edt\u00e1s funkci\u00f3t, \u00e9s a differenci\u00e1lis biztons\u00e1gi ment\u00e9si feladatok hib\u00e1val futottak le. <\/p>\n<p>N\u00e9zz\u00fck meg, hogyan fog kin\u00e9zni a helyre\u00e1ll\u00edt\u00e1s.<br \/>\n1. Elind\u00edtjuk a helyre\u00e1ll\u00edt\u00e1st a megfelel\u0151 \u00fcgyn\u00f6k\u00f6n.<br \/>\n<img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/52a9fb15bbffc0d9cd9c03310659bdc2.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n2. A megjelen\u0151 ablakban l\u00e9pj\u00fcnk az <b>Advanced Options<\/b>. V\u00e1lasszuk ki <b>SQL Granular Browse \u2014 View Content.<\/b><br \/>\n<img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/c9224f9168d3aa54d47df397b54dd4df.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n3. A megny\u00edl\u00f3 list\u00e1ban v\u00e1lasszuk ki azt az adatb\u00e1zist, ahonnan a t\u00e1bl\u00e1t vissza\u00e1ll\u00edtjuk, \u00e9s kattintsunk a <b>Restore Granular<\/b>.<br \/>\n<img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/e2880687c818458fe1e4eb074e9b68e1.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n4. A p\u00e1rbesz\u00e9dablakban \u00e1ll\u00edtsuk be az adatb\u00e1zis csatol\u00e1si pontj\u00e1t a biztons\u00e1gi ment\u00e9si f\u00e1jlokb\u00f3l (valami hasonl\u00f3 az Instant Recovery technol\u00f3gi\u00e1hoz).<br \/>\nAdjuk meg:<\/p>\n<ul>\n<li>a neve a ideiglenes adatb\u00e1zisnak;<\/li>\n<li>mennyi ideig tartsuk meg ezt a helyre\u00e1ll\u00edt\u00e1si pontot napokban;<\/li>\n<li>szerver, ahov\u00e1 a datab\u00e1zist csatolni fogjuk. A list\u00e1ban csak azok a szerverek lesznek el\u00e9rhet\u0151k, amelyek teljes\u00edtik az \u00f6sszes sz\u00fcks\u00e9ges felt\u00e9telt, amir\u0151l kor\u00e1bban besz\u00e9ltem: Windows oper\u00e1ci\u00f3s rendszerrel, telep\u00edtett Media Agent-el \u00e9s Java Runtime Environment-el stb.<\/li>\n<\/ul>\n<p>Kattintsunk az OK-ra.<br \/>\n<img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/424def3390c6c4aafb55dd17b7a10e10.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n5. Az \u00faj ablakban kattintsunk a List Recovery Points-ra.<br \/>\n<img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/b44cbeb2d64001dee15f3f9dbf58d5a7.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n6. Megny\u00edlik a csatolt helyre\u00e1ll\u00edt\u00e1si pontok list\u00e1ja. Ha a datab\u00e1zis nagy, v\u00e1rni kell. Ezut\u00e1n kattintsunk <b>B\u00f6ng\u00e9sz\u00e9s<\/b>. Megjelenik egy ablak a kiv\u00e1lasztott adatb\u00e1zis t\u00e1bl\u00e1inak megtekint\u00e9s\u00e9re. <br \/>\n<img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/2671074165684fcdab5843b30e5ffc81.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nMik\u00f6zben a lista l\u00e9trej\u00f6n, gyakran bez\u00e1rj\u00e1k a Helyre\u00e1ll\u00edt\u00e1si Pontok p\u00e1rbesz\u00e9dpanelt, majd nem tudnak visszat\u00e9rni oda. Egyszer\u0171en csak kattintsunk a SQL-szerver p\u00e9ld\u00e1ny\u00e1ra, ahol a helyre\u00e1ll\u00edt\u00e1si pont csatol\u00e1s\u00e1nak folyamata zajlott. L\u00e9pj\u00fcnk az All Tasks lehet\u0151s\u00e9gre, \u00e9s v\u00e1lasszuk a List Recovery Points-t.<br \/>\n<img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/a16653578b1527c220db5911a4d77ea2.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n7. Ha sok t\u00e1bla van, azok megjelen\u00edt\u00e9s\u00e9hez id\u0151be telhet. P\u00e9ld\u00e1ul egy 40 GB-os adatb\u00e1zis eset\u00e9ben a lista kialak\u00edt\u00e1sa k\u00f6r\u00fclbel\u00fcl t\u00edz percig tarthat. V\u00e1lasszuk ki a sz\u00fcks\u00e9ges t\u00e1bl\u00e1t, \u00e9s kattintsunk a Recover All Selected-ra. <br \/>\n<img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/c3e8a0eebf2c9d18d49f8a50a68d2c70.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n8. Az \u00faj ablakban v\u00e1lasszuk ki azt az adatb\u00e1zist, ahov\u00e1 a t\u00e1bl\u00e1t(t\u00e1bl\u00e1kat) vissza szeretn\u00e9nk \u00e1ll\u00edtani. Ebben az esetben a GPI TEST adatb\u00e1zis lesz az.<br \/>\n<img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/c5adb9729db830b65ced5669a868bdaa.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n9. A helyre\u00e1ll\u00edt\u00e1s befejez\u00e9se ut\u00e1n a GPI TEST adatb\u00e1zisban megjelennek a kiv\u00e1lasztott t\u00e1bl\u00e1k.<br \/>\n<img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/3fa2d3f1119bf9246bfc8676d68343cb.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nA t\u00e1bl\u00e1k helyre\u00e1ll\u00edt\u00e1sa ut\u00e1n ideiglenes adatb\u00e1zisb\u00f3l \u00e1thelyezhetj\u00fck \u0151ket az eredeti adatb\u00e1zisba a Management Studio seg\u00edts\u00e9g\u00e9vel. <\/p>\n<h3>Commvault plug-in SQL Management Studio-hoz<\/h3>\n<p>\nAz adatb\u00e1zis-adminisztr\u00e1torok nem mindig f\u00e9rnek hozz\u00e1 a biztons\u00e1gi ment\u00e9si rendszerhez (SRK). N\u00e9ha s\u00fcrg\u0151sen kell tenni valamit, \u00e9s a SRK adminisztr\u00e1tor nincs a k\u00f6zelben. A Commvault plug-in haszn\u00e1lat\u00e1val az SQL Management Studio-ban az adatb\u00e1zis adminisztr\u00e1torai alapvet\u0151 biztons\u00e1gi ment\u00e9si \u00e9s helyre\u00e1ll\u00edt\u00e1si feladatokat v\u00e9gezhetnek. <\/p>\n<p><b>SQL Management Studio verzi\u00f3<\/b><\/p>\n<p><b>Parancs<\/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>A Commvault Plug-in \u00e1ltal t\u00e1mogatott SQL szerver verzi\u00f3k \u00e9s a plug-in aktiv\u00e1l\u00e1s\u00e1hoz sz\u00fcks\u00e9ges parancsok. A plug-in csak a 64-bites Windows oper\u00e1ci\u00f3s rendszeren t\u00e1mogatott.<\/i><\/p>\n<p>1. Hajtsuk v\u00e9gre a parancsot, amely megfelel az SQL server\u00fcnk verzi\u00f3j\u00e1nak:<br \/>\n<img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/0ee5cef1d319279dc40eb75fae82af59.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n2. Mostant\u00f3l a Management Studio-ban el\u00e9rhet\u0151k a biztons\u00e1gi ment\u00e9si \u00e9s helyre\u00e1ll\u00edt\u00e1si lehet\u0151s\u00e9gek. Ehhez kattintsunk a jobb eg\u00e9rgombbal a megfelel\u0151 adatb\u00e1zisra.<br \/>\nAz adminisztr\u00e1tor sz\u00e1m\u00e1ra \u00edgy lehet\u0151s\u00e9ge ny\u00edlt arra, hogy k\u00f6zvetlen\u00fcl kapcsolatba l\u00e9pjen az adatb\u00e1zis biztons\u00e1gi ment\u00e9seivel a Commvault konzolja \u00e9s az SRK adminisztr\u00e1tor\u00e1nak megkeres\u00e9se n\u00e9lk\u00fcl.<br \/>\n<img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/38141c9c785d772532103abd9e7f9174.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n3. B\u00e1rmelyik funkci\u00f3 elind\u00edt\u00e1sakor megjelenik egy ablak, amely k\u00e9ri a felhaszn\u00e1l\u00f3nevet \u00e9s a jelsz\u00f3t. A CommServe-hez val\u00f3 csatlakoz\u00e1shoz SSO-t vagy a Security r\u00e9szlegb\u0151l b\u00e1rmely m\u00e1s fi\u00f3kot haszn\u00e1lhat (Commcell bejelentkez\u00e9s).<br \/>\n<img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/ed666299970851e81cd407680f57a92a.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/af7596ca8dfee7d20a3b2a57b0261b5b.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n4. Ha a hiteles\u00edt\u0151 adatok helyesen lettek megadva \u00e9s elegend\u0151 hozz\u00e1f\u00e9r\u00e9ssel rendelkezik, az adatb\u00e1zis adminisztr\u00e1tora lehet:<br \/>\n \u2014 elind\u00edtani a s\u00fcrg\u0151ss\u00e9gi biztons\u00e1gi ment\u00e9st (Backup);<br \/>\n \u2014 vissza\u00e1ll\u00edtani az adatb\u00e1zist a biztons\u00e1gi ment\u00e9sb\u0151l (Restore);<br \/>\n \u2014 megtekinteni a v\u00e9grehajtott feladatok t\u00f6rt\u00e9net\u00e9t (View History) \u00e9s a folyamatban l\u00e9v\u0151 feladatok el\u0151rehalad\u00e1s\u00e1t (Job monitor).<br \/>\n<img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/77dff526a444c773da617ee3562adda3.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>\u00cdgy n\u00e9z ki a v\u00e9grehajtott biztons\u00e1gi ment\u00e9sek t\u00f6rt\u00e9nete a kiv\u00e1lasztott adatb\u00e1zis eset\u00e9ben a Management Studio-ban.<\/i><\/p>\n<p><img decoding=\"async\" alt=\"MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amit nem mindenki tud\" src=\"\/wp-content\/uploads\/2019\/04\/e00d1d3d570cdfce7be693caaba381e2.JPG\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Az adatb\u00e1zis helyre\u00e1ll\u00edt\u00e1s\u00e1hoz sz\u00fcks\u00e9ges men\u00fc. M\u00e9g csak nem is k\u00fcl\u00f6nb\u00f6zik a konzol men\u00fcj\u00e9t\u0151l.<\/i><\/p>\n<p>Eddig tartott a Commvault SQL \u00fcgyn\u00f6k\u00e9nek e k\u00e9t lehet\u0151s\u00e9ge. Hozz\u00e1tenn\u00e9m, hogy a Commvault seg\u00edts\u00e9g\u00e9vel t\u00f6rt\u00e9n\u0151 biztons\u00e1gi ment\u00e9s jobban megfelel azoknak, akiknek tucatnyi szerver\u00fck van, t\u00f6bb p\u00e9ld\u00e1nnyal \u00e9s adatb\u00e1zissal, lehet\u0151s\u00e9gek szerint k\u00fcl\u00f6nb\u00f6z\u0151 helysz\u00edneken, amelyek k\u00fcl\u00f6nb\u00f6z\u0151 \u00fctemez\u00e9s, m\u00e9lys\u00e9g stb. be\u00e1ll\u00edt\u00e1st ig\u00e9nyelnek. Ha csak n\u00e9h\u00e1ny szervered van, a MS SQL be\u00e9p\u00edtett eszk\u00f6zei elegend\u0151ek a biztons\u00e1gi ment\u00e9shez.<\/p>\n<p>Forr\u00e1s: <noindex><a rel=\"nofollow\" href=\"http:\/\/documentation.commvault.com\/commvault\/v11\/article?p=18110.htm\">documentation.commvault.com<\/a><\/noindex><br \/>\n<br \/>Forr\u00e1s: <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\/hu\/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=\"hu_HU\" \/>\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\/hu\/blog\/administrirovanie\/rezervnoe-kopirovanie-ms-sql-para-poleznyh-funktsij-commvault-pro-kotorye-ne-vse-znayut\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-10-31T18:40:32+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T18:40:32+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47MS SQL biztons\u00e1gi ment\u00e9s: n\u00e9h\u00e1ny hasznos Commvault funkci\u00f3, amelyr\u0151l nem mindenki tud | ProHoster","description":"Ma.","canonical_url":"https:\/\/prohoster.info\/hu\/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":"hu_HU","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\/hu\/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\/hu\/wp-json\/wp\/v2\/posts\/31297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=31297"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/31297\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media\/23263"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=31297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=31297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=31297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}