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.

Start SQL Server Management Studio, right-click the Primary database, point to Tasks, and then click Mirror.
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