Braking a Mirror

  • Hello Everyone

    I hope that you had a nice weekend.

    I am getting ready to break the mirror between two SQL Servers. I know how to do this, but is there anything that I should be on the lookout for before breaking the mirror? Anyone ever had a mirror that would not break?

    Let me know if you have ever had any hang ups or snags.

    Andrew SQLDBA

  • Hi Andrew

    I've never personally had any issues with breaking a mirror, I've probably only done it about 20 times though.

    Cheers

    Mat

  • No issue I have done this before.If break the mirror with the intention of re-mirroring,just lookout for the configurations,if you had used certificates make sure they are secure or you may have to redo the whole process again.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • Thank You everyone. I appreciate the input. I have not had an issue before myself either. But I always like to get another opinion before beginning.

    I just noticed that I spelled "Breaking" incorrectly. LOL

    Thanks again

    Andrew SQLDBA

Viewing 4 posts - 1 through 3 (of 3 total)

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