Setting up Directory database 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.

Before you begin

What you should know

With Database Mirroring, the database failover is handled by Microsoft SQL Server. The Principal and Mirror instances of the Directory database are kept in sync at all times. There is no loss of data during failover.
NOTE: Following a database failover, the first database query performed by Security Center client applications are likely to fail. When a query fails, the message "Database transaction has failed" appears on screen. Close the message box and try again to resume normal operation.

To use Database Mirroring as your Directory database failover solution:

  1. From the Config Tool home page, open the System task, and click the Roles view.
  2. Select the Directory Manager () role, and click the Database failover tab.
  3. Switch the Use database failover option to ON, and select the Mirroring option.

    The database you’re currently connected to is the Principal database.

  4. Under Mirror database, enter the database server name of the Mirror database.
  5. Click Apply.