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="C:Program FilesMicrosoft SQL Server100ToolsBinnSQLCMD.EXE" set prg64path="C:Program FilesMicrosoft SQL Server100ToolsBinn" REM Falls x64-Managementstudio: c: cd /d %prg64path% sqlcmd -E -S %server%%VMWARESSO% -i %VMWARESSOSQL% move /Y %VMWARESSODEST% %VMWARESSODESTPATH%VMWARESSO-RSA-%date%.bak "%programfiles%7-Zip7z.exe" a %VMWARESSODESTPATH%VMWARESSO-RSA-%date%.%ARCHIVFRMT% %VMWARESSODESTPATH%VMWARESSO-*.bak erase %VMWARESSODESTPATH%VMWARESSO-*.bak SET VMWAREVCENTER=vim_sqlexp SET VMWAREVCENTERDEST=C:BKPDBvCenterServerVIM_VCDB.bak SET VMWAREVCENTERDESTPATH=C:BKPDBvCenterServer SET VMWAREVCENTERSQL=C:Installsrcvmware-vcenter.sql set prg64="C:Program FilesMicrosoft SQL Server100ToolsBinnSQLCMD.EXE" set prg64path="C:Program FilesMicrosoft SQL Server100ToolsBinn" sqlcmd -E -S %server%%VMWAREVCENTER% -i %VMWAREVCENTERSQL% move /Y %VMWAREVCENTERDEST% %VMWAREVCENTERDESTPATH%VMWAREVCENTER-RSA-%date%.bak "%programfiles%7-Zip7z.exe" a %VMWAREVCENTERDESTPATH%VMWAREVCENTER-RSA-%date%.%ARCHIVFRMT% %VMWAREVCENTERDESTPATH%VMWAREVCENTER-*.bak erase %VMWAREVCENTERDESTPATH%VMWAREVCENTER-*.bak ping -n 30 127.0.0.1 >nul
vmware-sso.sql:
BACKUP DATABASE [RSA] TO DISK = N'C:BKPDBVMwareSSoRSA.bak' WITH NOFORMAT, NOINIT, NAME = N'RSA-Vollständig Datenbank Sichern', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO
vmware-vcenter.sql:
BACKUP DATABASE [VIM_VCDB] TO DISK = N'C:BKPDBvCenterServerVIM_VCDB.bak' WITH NOFORMAT, NOINIT, NAME = N'VIM_VCDB-Vollständig Datenbank Sichern', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO