{"id":562,"date":"2019-09-15T13:45:22","date_gmt":"2019-09-15T13:45:22","guid":{"rendered":"http:\/\/labiol.xyz\/?p=562"},"modified":"2019-12-31T14:07:20","modified_gmt":"2019-12-31T14:07:20","slug":"szybki-backup-serwera-mssql-w-trakcie-aktualizacji-vcenter-vum","status":"publish","type":"post","link":"https:\/\/www.labiol.xyz\/index.php\/2019\/09\/15\/szybki-backup-serwera-mssql-w-trakcie-aktualizacji-vcenter-vum\/","title":{"rendered":"Szybki backup serwera mssql w trakcie aktualizacji vCenter\/VUM"},"content":{"rendered":"\n<p>Podczas aktualizacji us\u0142ugi vCenter\/VUM lub innej (je\u015bli kto\u015b ma je jeszcze ma oparte na windows i mssql), zachodzi potrzeba szybkiego backupu ca\u0142ej bazy danych. Mo\u017cna to oczywi\u015bcie zrobi\u0107 za pomoc\u0105 kilku klikn\u0119\u0107 w &#8220;sql management studio&#8221; w spos\u00f3b w jaki opisano tutaj:  <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/create-a-full-database-backup-sql-server?view=sql-server-ver15\">https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/create-a-full-database-backup-sql-server?view=sql-server-ver15<\/a> <\/p>\n\n\n\n<p>Niestety &#8220;sql server management studio&#8221; nie zawsze jest zainstalowany -zw\u0142aszcza dla ma\u0142ej wbudowanej bazy, gdzie rozmiar samego studio mo\u017ce by\u0107 wi\u0119kszy ni\u017c bazy i silnika SQL razem.<\/p>\n\n\n\n<p>Warto w\u00f3wczas pami\u0119ta\u0107, \u017ce jest jeszcze kilka sposob\u00f3w zrobienia backupu a jednym z wygodniejszych jest u\u017cycie polecenia (przystawki) dla powershell.<\/p>\n\n\n\n<p>To czy jest ona zainstalowana mo\u017cna zweryfikowa\u0107 poleceniem: <\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><code>Get-Module -Name SqlServer<\/code><\/p><cite> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/create-a-full-database-backup-sql-server?view=sql-server-ver15\">https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/create-a-full-database-backup-sql-server?view=sql-server-ver15<\/a> <\/cite><\/blockquote>\n\n\n\n<p>Ew. zostaje instalacja modu\u0142u (pod warunkiem dost\u0119pu do internetu):<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><code> Install-Module -Name SqlServer <\/code><\/p><\/blockquote>\n\n\n\n<p>Je\u015bli podczas importu modu\u0142u pojawi si\u0119 b\u0142\u0105d zwi\u0105zany z restrykcj\u0105 na zdalnie podpisane skrypty, w\u00f3wczas mo\u017cna zmieni\u0107 poziom bezpiecze\u0144stwa PowerShell wydaj\u0105c polecenie:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p> <code>Set-ExecutionPolicy -ExecutionPolicy RemoteSigned <\/code><\/p><cite> <a href=\"https:\/\/docs.microsoft.com\/pl-pl\/powershell\/module\/microsoft.powershell.core\/about\/about_execution_policies?view=powershell-6\">https:\/\/docs.microsoft.com\/pl-pl\/powershell\/module\/microsoft.powershell.core\/about\/about_execution_policies?view=powershell-6<\/a> <\/cite><\/blockquote>\n\n\n\n<p>W ko\u0144cu, polecenie do backupu bazy danych ma nast\u0119puj\u0105c\u0105 posta\u0107:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><code>Backup-SqlDatabase-ServerInstance $serverName -Database $sqldbname -BackupFile \"$($backupFolder)$($dbname)_db_$($addinionToName).bak\"<\/code><\/p><\/blockquote>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><code>Backup-SqlDatabase -ServerInstance Computer[\\Instance] -Database &lt;myDatabase&gt; -BackupAction Database -Credential $credential  <\/code><\/p><\/blockquote>\n\n\n\n<p>Inne przyk\u0142ady polecenia mo\u017cna znale\u017a\u0107 w artykule:  <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/create-a-full-database-backup-sql-server?view=sql-server-ver15\">https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/create-a-full-database-backup-sql-server?view=sql-server-ver15<\/a> <\/p>\n\n\n\n<p>Teraz pozostaje to oskryptowa\u0107 i u\u017cywa\u0107 przy ew. aktualizacjach. Przynajmniej do momentu przej\u015bcia na appliance VMware i przerzucania si\u0119 na vPostgresql ( hmmm &#8230; ) lub $$$Oracle$$$.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Podczas aktualizacji us\u0142ugi vCenter\/VUM lub innej (je\u015bli kto\u015b ma je jeszcze ma oparte na windows i mssql), zachodzi potrzeba szybkiego backupu ca\u0142ej bazy danych. Mo\u017cna to oczywi\u015bcie zrobi\u0107 za pomoc\u0105 kilku klikn\u0119\u0107 w &#8220;sql management studio&#8221; w spos\u00f3b w jaki opisano tutaj: https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/create-a-full-database-backup-sql-server?view=sql-server-ver15 Niestety &#8220;sql server management studio&#8221; nie zawsze &hellip; <\/p>\n","protected":false},"author":1,"featured_media":501,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-562","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-vmware"],"_links":{"self":[{"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/posts\/562","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/comments?post=562"}],"version-history":[{"count":12,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/posts\/562\/revisions"}],"predecessor-version":[{"id":577,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/posts\/562\/revisions\/577"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/media\/501"}],"wp:attachment":[{"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/media?parent=562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/categories?post=562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/tags?post=562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}