none
How to move mirror database to other sql server instance without breaking the mirror ??

    Question

  • Greetings Team,

    I have a one technical challenge here is goes.... 

    " How to move the mirror database to other SQL Server instance without breaking the mirroring "

    If you have any idea or workaround... Please suggest me on this.. ??

    Your help must be appreciated.

    Thanks,

    Prasad

    Thursday, April 25, 2013 6:57 AM

Answers

All replies

  • Hi 

    Please refer below link may be it helps your activity with out any down time  ....:-)

    @@http://blogs.msdn.com/b/sqlcat/archive/2010/04/05/moving-the-transaction-log-file-of-the-mirror-database.aspx

    Thursday, April 25, 2013 7:49 AM
  • Do You mean to move the mirroring database in one server to another server ? Not sure You can do this without breaking existing mirroring session.


    Srinivasan

    Thursday, April 25, 2013 12:51 PM
  • This might be work to full fill acheive the above requirement..

    On the mirror server, Use ALTER DATABASE MODIFY FILE to move the log file.

    ALTER DATABASE <db_name> MODIFY FILE (NAME = LOG_FILE, FILENAME = ‘new location’).

    1. Stop the SQL Server instance which has the mirrored database.
    2. Move the log file to the correct location physically (use appropriate OS command).
    3. Start the SQL Server instance which has the mirrored database.

    Can any one have any idea's please share it will be useful in many scenario's.

    Thanks in anticipation.

    Thanks,

    PRasad

    Friday, April 26, 2013 1:51 AM