Creating databases - 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
Product
Security Center
Version
5.9

Under certain circumstances, you might need to create a new database, overwrite the default database assigned to a role, or assign a different database that is prepared by your IT Department if you plan on using a dedicated database server.

Before you begin

If you plan on overwriting the existing database with the new one, you should backup the existing database.

What you should know

All role databases are created from Config Tool, except the Directory database, which must be created from the Server Admin - Main Server page. The procedures are very similar in both cases. Therefore, only creating from Config Tool is described here.

Procedure

  1. From the Config Tool home page, open the System task, and click the Roles view.
  2. Select a role, and click the Resources tab.
  3. From the Database server drop-down list, type or select the name of the database server.
    The value (local)\SQLEXPRESS corresponds to Microsoft SQL Server 2014 Express Edition that was installed by default with Genetec™ Security Center. To specify a database server on a different server than the one hosting the role, enter the name of that remote server.
  4. From the Database drop-down list, type or select the name of the database.
    The same database server can manage multiple database instances.
  5. Click Apply.
    The database creation starts. A window opens, showing the progress of this action. You can close this window and review the history of all database actions by clicking Database actions in the notification tray.
  6. Wait until you see Database status indicating Connected.
    Best Practice: Consider taking regular backups to avoid data loss.