Creating databases - Security Center 5.12

Security Center Administrator Guide 5.12

Product
Security Center
Content type
Guides > Administrator guides
Version
5.12
Language
English
Last updated
2024-09-13

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 back up 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, so only creating from Config Tool is described here.

Procedure

  1. From the Config Tool homepage, open the System task and click the Roles view.
  2. Select a role, and click the Resources tab.
  3. From the Database server list, type or select the name of the database server.
    The value (local)\SQLEXPRESS corresponds to Microsoft SQL Server 2019 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 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.