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
-
From the Config Tool homepage, open the System task and click the
Roles view.
-
Select a role, and click the Resources tab.
-
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.
-
From the Database list, type or select the name of the
database.
The same database server can manage multiple database instances.
-
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.
-
Wait until you see Database status indicating
Connected.
Best Practice: Consider taking regular backups to avoid data loss.