Production Mirroring problem - Switch mirrored database back to principal

• kwilt

  SSCrazy

  Points: 2611

  More actions

  August 1, 2009 at 6:46 am

  #203413

  We have a mirror database setup for our production databases. Something caused mirroring to kick in this morning for a single database on the production server (all others are still showing "Principal"). So we need to revert the one database that now shows "Mirror/Synchronized/Restoring" back to Principal.

  I tried bringing up the Mirror dialog box by right-clicking and selecting "Mirror" but receive the following error message:

  Cannot show requested dialog.

  Property Owner is not available for Database . This property may not exist for this object, or may not be retrievable due to insufficient access rights.

  I have sysadmin rights on the server and the databases. My thought was to use the "Failover" button to switch the databases back to normal.

  We currently have production for that database down and user connections disabled until we resolve this issue. Any assistance would be greatly appreciated.

  Kay

• kwilt

  SSCrazy

  Points: 2611

  More actions

  August 1, 2009 at 6:55 am

  #1033326

  Please disregard! I figured it out.

  I used the following script to initiate a manual failover:

  USE master;

  Issued the following statement on the principal server:

  ALTER DATABASE database_name SET PARTNER FAILOVER, where database_name is the mirrored database.

  The single database is now back in the Principal state and the mirror database displays the Mirror/Synchronized/Restoring state as expected.