In this post I will show you the steps to move the System Center Orchestrator database to a different SQL machine. When I first installed the Orchestrator beta I had SQL server and all Orchestrator components on the same machine, but of course after a couple of days I needed to move the database to a dedicated SQL server.
- Stop all currently running and queued instances of runbooks. This can be done using the System Center Orchestrator Runbook Designer, or the Opalis Integration Server Client, or the System Center Orchestrator web console.
- Stop the following services on your Orchestrator management server,
- Stop the following services on your Orchestrator Runbook Servers
- Create a back of your Orchestrator database. Open Microsoft SQL Server Management Studio, right-click the Orchestrator database, select backup from the menu. Choose to do a Full backup to a file, for example C:\TEMP\Orchestrator
- Restore the database backup onto the new SQL server that you are moving to. Open Microsoft SQL Server Management Studio, right-click Databases and select Restore Database. Input the file as devices and Orchestrator as database name to restore to.
- In SQL Server Management Studio, add the Orchestrator service Account as Login and configure it to use the Orchestrator database as default database. Also configure the account with db_owner permissions on the Orchestrator database
- On your Orchestrator management server start the Data Store Configuration tool, configure to use the new SQL server and a existing database, the Orchestrator database. If you get a warning saying that the data store already exists, click Yes
- On your Orchestrator Runbook Servers, repeat step 7
- Start all services on your Orchestrator management server, that you stopped on step 2
- Start all services on your Orchestrator Runbook servers, that you stopped on step 3
After these steps everything except the web console and the web services was working fine. To get both the web console and web service to work against the new database I simple uninstalled them, and re-installed them. The re-installation took a couple of minutes. I guess there is a configuration file we could edit too, but re-installation is a fast and simple solution.
Please note that this is provided “as is” with no warranties at all.