Moving databases to other computers - Security Center 5.7

If you want to change the server hosting a role or add secondary servers for failover, you must host the role’s database on a different computer.

1. From the Config Tool home page, open the System task, and click the Roles view.
2. Select the role whose database you want to move, and then click Maintenance > Deactivate role () in the toolbar at the bottom of the workspace.
3. Click the Resources tab.
4. Back up the current database.
   Tip: Since the backup folder is relative to the current server, it might be a good idea to select a network location that can be reached by any server on your system.
5. (Optional) Delete the current database.
6. Create the database on the new machine .
7. Restore the content that you have backed up to the new database.
8. Click Apply.
9. In the toolbar at the bottom of the workspace, click Activate ().