Post reply

Change Compatility level in active mirroring session

  • July 18, 2013 at 1:52 am

    #280191

    Hello,

    i've changed the compatibility level on the principal mirrored database but this change has not been apply to the second database.

    Is there a way to change that without dropping the the mirror and creating it again?

    regards,

    OJ

  • August 13, 2013 at 6:05 am

    #1640885

    You can fail the database on the principal to the mirror make the change test it and fail the database back to the original principal.

    Cheers

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply