Upgrade Mirror Server from SQL 2008 to SQL 2008 R2 RRS feed

  • Question

  • I have SQL Servers (Build # 10.0.2841). I am doing Mirror (Synchronous without witness). Now I need to upgrade (both Principal and Mirror) from SQL 2008 (Build # 10.0.2841) to SQL 2008 R2 (Build # 10.50.2772). I am planning to do in place upgrade. I am planning to follow the given below steps:

    • Pause Mirror
    • Run in place upgrade on both the servers (i.e. Principal and Mirror)
    • Resume Mirror
    • Fail over and fail back mirror

    Is it the right way to upgrade? Or what is the best way to upgrade?

    Thursday, September 29, 2011 12:47 AM


  • There is an excellent article to refer


    Hope this helps.

    Thank you,

    Anup | Forum Support| If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer.
    • Proposed as answer by Pramilarani Thursday, September 29, 2011 4:57 AM
    • Marked as answer by Peja Tao Thursday, October 6, 2011 9:29 AM
    Thursday, September 29, 2011 3:38 AM