locked
Database mirroring - Pricipal and mirror reversal not failover RRS feed

  • Question

  • Hi .
     
     Database mirrored servers A & B

     A - PROD server - Principal server
     B - COB server - Mirror server

     Two server A and B configured for mirroring , after some period Databases in Mirror B server was brought up by taking the tail transaction log backup and restoring it

     After which Database mirroring was configured freshly from B - A

     Currently:

      B - COB server - Principal  server
      A - PROD server - Mirror server

     Now my question here is i want to return to old state without breaking mirroring or configuring it newly  as given below , is it possible ?(Becoz database size is in TB , time consuming for new configuration)

     Example : Needed

      A - PROD server - Principal server
      B - COB server - Mirror server

     Immediate  Feedback appreciable  :)

    Saturday, March 21, 2009 6:49 AM

Answers

  • Thanks fabrice , i managed and completed the COB test successfully already
    • Marked as answer by Rajganesh.dba Saturday, May 9, 2009 11:46 AM
    Saturday, May 9, 2009 11:42 AM

All replies

  • As far as your databases are synchronized, you can switch principal role between your 2 servers in an instant time... 
    http://weblogs.sqlteam.com/tarad/archive/2008/05/04/60585.aspx

    Problems that can occur :
    - you will have to reconfigure client connections if you don't use a witness and SNAC (personnally, i use a dns alias in connection strings, and so, after a failover, i simply change the dns alias to make it points to server B...)
    - If your logins have not been created with the sp_helprevlogin, you can have to fix orphaned users with sp_change_users_login 'Auto_Fix', 'user', 'login', 'password'...
    Saturday, March 21, 2009 8:01 PM
  • Thanks fabrice , i managed and completed the COB test successfully already
    • Marked as answer by Rajganesh.dba Saturday, May 9, 2009 11:46 AM
    Saturday, May 9, 2009 11:42 AM