SQL Server deployment option: failover - Genetec Mission Control™ 3.0.5.0

Genetec Mission Control™ Deployment Guide 3.0.5.0

Applies to
Genetec Mission Control™ 3.0.5.0
Last updated
2022-05-02
Content type
Guides > Deployment guides
Language
English (United States)
Product
Genetec Mission Control™
Version
3.0

The SQL database is essential for optimal operations. If the SQL database is lost all roles become unavailable. You can distribute your SQL database through failover configuration to prevent data loss.

Failover through backup

To protect the Directory database by regularly backing up the master database instance, you can set up Directory database failover using the backup and restore method.

For more details, see Setting up Directory database failover through backup and restore.

Failover through mirroring

To protect the Directory database so you do not lose any data if a failover occurs, you can set up Directory database failover to use Microsoft SQL Server Database Mirroring.

CAUTION:
Microsoft Database Mirroring is being phased out. For new installations, it is recommended to use SQL AlwaysOn.

For details, see Setting up Directory database failover through mirroring.

Failover through SQL AlwaysOn

If you are using the Windows feature SQL AlwaysOn as your Directory database failover solution, you must configure the Directory Manager to use SQL AlwaysOn in Config Tool.

For details, see Setting up Directory database failover through SQL AlwaysOn.

Reference resources