Sample migration scripts and commands Backup SQL Server master service key sample Sqlcmd SERVICE MASTER KEY TO FILE ='C:\BACKUP\MASTER_KEY.BAK' ENCRYPTION BY –Q ”BACKUP PASSWORD = 'password'” Backup Orchestrator database sample Sqlcmd DATABASE Orchestrator TO DISK=N'C:\BACKUP\OrchestratorDB.bak'” –Q ”BACKUP Restore SQL Server master service key sample Sqlcmd SERVICE MASTER KEY FROM FILE = –Q “RESTORE 'c:\temp_backups\keys\service_master_key' DECRYPTION BY PASSWORD = 'password'” Restore Orchestrator database sample Sqlcmd DATABASE [Orchestrator] FROM DISK = –Q ”RESTORE N'C:\BACKUP\OrchestratorDB.bak'WITH FILE = 1, NOUNLOAD, STATS = 10” Install Orchestrator from batch file sample %systemdrive%\sco\setup\setup.exe /Silent /ServiceUserName:%computername%\administrator /ServicePassword:password /Components:All /DbServer:%computername% /DbPort:1433 /DbNameNew:OrchestratorSysPrep /WebConsolePort:82 /WebServicePort:81 /OrchestratorRemote /UseMicrosoftUpdate:1 /SendCEIPReports:1 /EnableErrorReporting:always Best Practices Analyzer The Microsoft System Center 2012 - Orchestrator Best Practices Analyzer is a tool that looks at the configuration data in an Orchestrator deployment and identifies settings that may cause issues within your environment. It performs the following functions: Gathers information an Orchestrator deployment  Determines if the configurations are set according to the Microsoft recommended best  practices Reports on collected configurations, indicating settings that differ from recommendations   Indicates potential problems in the deployment Installation The Orchestrator BPA must be installed on the Orchestrator Management server. It depends on having the Microsoft Baseline Configuration Analyzer 2.1 () installed on the Orchestrator Management Server prior to installation. Install process:
Sample migration scripts and commands Backup SQL Server master service key sample Sqlcmd –Q ”BACKUP SERVICE MASTER KEY TO FILE ='C:\BACKUP\MASTER_KEY.BAK' ENCRYPTION BY PASSWORD = 'password'” Backup Orchestrator database sample Sqlcmd –Q ”BACKUP DATABASE Orchestrator TO DISK=N'C:\BACKUP\OrchestratorDB.bak'” Restore SQL Server master service key sample Sqlcmd –Q “RESTORE SERVICE MASTER KEY FROM FILE = 'c:\temp_backups\keys\service_master_key' DECRYPTION BY PASSWORD = 'password'” Restore Orchestrator database sample Sqlcmd –Q ”RESTORE DATABASE [Orchestrator] FROM DISK = N'C:\BACKUP\OrchestratorDB.bak'WITH FILE = 1, NOUNLOAD, STATS = 10” Install Orchestrator from batch file sample %systemdrive%\sco\setup\setup.exe /Silent /ServiceUserName:%computername%\administrator /ServicePassword:password /Components:All /DbServer:%computername% /DbPort:1433 /DbNameNew:OrchestratorSysPrep /WebConsolePort:82 /WebServicePort:81 /OrchestratorRemote /UseMicrosoftUpdate:1 /SendCEIPReports:1 /EnableErrorReporting:always Best Practices Analyzer The Microsoft System Center 2012 - Orchestrator Best Practices Analyzer is a tool that looks at the configuration data in an Orchestrator deployment and identifies settings that may cause issues within your environment. It performs the following functions:  Gathers information an Orchestrator deployment  Determines if the configurations are set according to the Microsoft recommended best practices  Reports on collected configurations, indicating settings that differ from recommendations  Indicates potential problems in the deployment Installation The Orchestrator BPA must be installed on the Orchestrator Management server. It depends on having the Microsoft Baseline Configuration Analyzer 2.1 () installed on the Orchestrator Management Server prior to installation. Install process:
SC2012_Orch_Admin.docx