This topic has not yet been rated - Rate this topic

Monitor and test for failover

The Mirrored databases can fail over either manually or automatically.

To monitor and test the failover, follow these steps:

Start Reporting Services, 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 fail-over 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 Implementing Application Failover with Database Mirroring.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)