Moving databases to other computers - Security Center 5.9

Security Center Administrator Guide 5.9

Applies to
Security Center 5.9
Last updated
2022-10-25
Content type
Guides > Administrator guides
Language
English (United States)
Product
Security Center
Version
5.9

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.

Before you begin

  • Make sure you have a machine available with SQL Server installed.
  • The machine does not need to be a Security Center server.
  • The server hosting your role must be able to access the database on the new server. For more information, see Connecting roles to remote database servers.

What you should know

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

Procedure

  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 the Resources tab.
  3. 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.
  4. (Optional) Delete the current database.
  5. Create the database on the new machine.
  6. Restore the content that you have backed up to the new database.
  7. Click Apply.