Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

How to: Manually Fail Over a Database Mirroring Session (SQL Server Management Studio)

When the mirrored database is synchronized (that is, when the database is in the SYNCHRONIZED state), the database owner can initiate manual failover to the mirror server.

During a manual failover, the principal and mirror server roles are swapped for the database on which the failover occurs. The mirror database becomes the principal database and the principal database becomes the mirror. For example, the following table shows the how a manual failover swaps the roles of two mirroring partners: SQLDBENGINE0_1 and SQLDBENGINE0_2.

Server Before failover After failover

SQLDBENGINE0_1

PRINCIPAL

MIRROR

SQLDBENGINE0_2

MIRROR

PRINCIPAL

Note that the server roles for other database mirroring sessions are not affected. For more information, see Manual Failover.

  1. Connect to the principal server instance and, in the Object Explorer pane, click the server name to expand the server tree.

  2. Expand Databases, and select the database to be failed over.

  3. Right-click the database, select Tasks, and then click Mirror. This opens the Mirroring page of the Database Properties dialog box.

  4. Click Failover.

    A confirmation box appears. If you confirm that you want to fail over to the mirror database, failover proceeds, and principal and mirror server roles are swapped. The mirror database becomes the principal database and the principal database becomes the mirror.

    ms186348.note(en-US,SQL.90).gifImportant:
    If you have modified any properties since opening the Mirroring page, those changes will not be saved.

    The dialog box closes automatically.

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.