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.

What you should know

This procedure is not necessary for the Archiver role. For Archiver roles, it is recommended to host the database locally.

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 ().