Is there any other way to resume mirroring while moving database to another server?

• Thinky Night

  SSCommitted

  Points: 1663

  More actions

  August 7, 2012 at 8:22 am

  #259719

  Hi All,

  I will try to move my db to another server while a live mirroring session is running?

  I will detach and attach db but i do not prefer removing mirroring?

  How do i achieve this without removing mirroring?

  Regards,

• SQL Show

  SSCertifiable

  Points: 6143

  More actions

  August 7, 2012 at 9:22 pm

  #1522943

  Do you mean to move you mirrored Database to new server without breaking up mirroring session?

  It is not possible without breaking mirror. If you can get downtime, break the mirror and establish it in new server.