Moving databases to other computers

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.

To move a database to another 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 ().