{"id":246,"date":"2013-03-18T20:43:19","date_gmt":"2013-03-18T19:43:19","guid":{"rendered":"http:\/\/freddy.afers.org\/?p=246"},"modified":"2013-03-18T20:43:19","modified_gmt":"2013-03-18T19:43:19","slug":"backup-script-vcenter-server-sso","status":"publish","type":"post","link":"https:\/\/freddy.afers.org\/?p=246","title":{"rendered":"Backup Script vCenter Server &#038; SSO"},"content":{"rendered":"<p>Ich benutze dieses Script, um die Datenbank (SQL-Express) des vCenter Servers und VMware SSO zu sichern:<\/p>\n<pre class=\"code\">\n@echo off\nSET Server=[servername]\nREM Archivformat festlegen, 7zip oder zip:\nSET ARCHIVFRMT=7z\nSET VMWARESSO=vim_sqlexp\nSET VMWARESSODEST=C:BKPDBVMwareSSoRSA.bak\nSET VMWARESSODESTPATH=C:BKPDBVMwareSSo\nSET VMWARESSOSQL=C:Installsrcvmware-sso.sql\nset prg64=\"C:Program FilesMicrosoft SQL Server100ToolsBinnSQLCMD.EXE\"\nset prg64path=\"C:Program FilesMicrosoft SQL Server100ToolsBinn\"\n\nREM Falls x64-Managementstudio:\nc:\ncd \/d %prg64path%\nsqlcmd -E -S %server%%VMWARESSO% -i %VMWARESSOSQL%\n\nmove \/Y %VMWARESSODEST% %VMWARESSODESTPATH%VMWARESSO-RSA-%date%.bak\n\"%programfiles%7-Zip7z.exe\" a %VMWARESSODESTPATH%VMWARESSO-RSA-%date%.%ARCHIVFRMT% %VMWARESSODESTPATH%VMWARESSO-*.bak\nerase %VMWARESSODESTPATH%VMWARESSO-*.bak\n\nSET VMWAREVCENTER=vim_sqlexp\nSET VMWAREVCENTERDEST=C:BKPDBvCenterServerVIM_VCDB.bak\nSET VMWAREVCENTERDESTPATH=C:BKPDBvCenterServer\nSET VMWAREVCENTERSQL=C:Installsrcvmware-vcenter.sql\nset prg64=\"C:Program FilesMicrosoft SQL Server100ToolsBinnSQLCMD.EXE\"\nset prg64path=\"C:Program FilesMicrosoft SQL Server100ToolsBinn\"\n\n\nsqlcmd -E -S %server%%VMWAREVCENTER% -i %VMWAREVCENTERSQL%\n\nmove \/Y %VMWAREVCENTERDEST% %VMWAREVCENTERDESTPATH%VMWAREVCENTER-RSA-%date%.bak\n\"%programfiles%7-Zip7z.exe\" a %VMWAREVCENTERDESTPATH%VMWAREVCENTER-RSA-%date%.%ARCHIVFRMT% %VMWAREVCENTERDESTPATH%VMWAREVCENTER-*.bak\nerase %VMWAREVCENTERDESTPATH%VMWAREVCENTER-*.bak\nping -n 30 127.0.0.1 &gt;nul\n<\/pre>\n<p>vmware-sso.sql:<\/p>\n<pre class=\"code\">\nBACKUP DATABASE [RSA] TO  DISK = N'C:BKPDBVMwareSSoRSA.bak' WITH NOFORMAT, NOINIT,  NAME = N'RSA-Vollst\u00e4ndig Datenbank Sichern', SKIP, NOREWIND, NOUNLOAD,  STATS = 10\nGO\n<\/pre>\n<p>vmware-vcenter.sql:<\/p>\n<pre class=\"code\">\nBACKUP DATABASE [VIM_VCDB] TO  DISK = N'C:BKPDBvCenterServerVIM_VCDB.bak' WITH NOFORMAT, NOINIT,  NAME = N'VIM_VCDB-Vollst\u00e4ndig Datenbank Sichern', SKIP, NOREWIND, NOUNLOAD,  STATS = 10\nGO\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Ich benutze dieses Script, um die Datenbank (SQL-Express) des vCenter Servers und VMware SSO zu sichern: @echo off SET Server=[servername] REM Archivformat festlegen, 7zip oder zip: SET ARCHIVFRMT=7z SET VMWARESSO=vim_sqlexp SET VMWARESSODEST=C:BKPDBVMwareSSoRSA.bak SET VMWARESSODESTPATH=C:BKPDBVMwareSSo SET VMWARESSOSQL=C:Installsrcvmware-sso.sql set prg64=&#8220;C:Program FilesMicrosoft SQL Server100ToolsBinnSQLCMD.EXE&#8220; set prg64path=&#8220;C:Program FilesMicrosoft SQL Server100ToolsBinn&#8220; REM Falls x64-Managementstudio: c: cd \/d %prg64path% sqlcmd -E [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,10],"tags":[],"class_list":["post-246","post","type-post","status-publish","format-standard","hentry","category-batch","category-scripting","et-bg-layout-dark","et-white-bg"],"_links":{"self":[{"href":"https:\/\/freddy.afers.org\/index.php?rest_route=\/wp\/v2\/posts\/246","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freddy.afers.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/freddy.afers.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/freddy.afers.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/freddy.afers.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=246"}],"version-history":[{"count":0,"href":"https:\/\/freddy.afers.org\/index.php?rest_route=\/wp\/v2\/posts\/246\/revisions"}],"wp:attachment":[{"href":"https:\/\/freddy.afers.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/freddy.afers.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/freddy.afers.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}