Monitor and test for failover
Applies To: Microsoft 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.
Send comments about this article to Microsoft.
© 2014 Microsoft Corporation. All rights reserved.