Monitor and test for failover

 

Applies To: Dynamics CRM 2013

The Mirrored databases can fail over either manually or automatically. To verify failover can successfully occur, use the procedure here.

Monitor and test failovers

  1. Start SQL Server Management Studio, right-click the Primary database, point to Tasks, and then click Mirror.

  2. On the Database Properties window, you can monitor the status of the synchronization between the Primary and Mirrored database. To test the failover feature manually, click Failover. When failover occurs, SQL Server will switch the mirroring session roles between the Primary database and the Mirrored database to make the mirror the primary and the primary the mirror.

For more information about how to implement database mirroring, see Data Mirroring Deployment.

See Also

Configure an organization database for SQL Server 2008 database mirroring
Install Microsoft Dynamics CRM Server 2013 to use a Microsoft SQL Server 2008 cluster environment