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.
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
- For more details on database failover, see Directory database failover.
- For more details on creating high availability using SQL failover clusters, see SQL Server Server Failover Cluster Installation.
- For information on SQL Server permissions, see Assigning SQL permissions on remote SQL Servers.