inplace upgrade for 2014 to 2016 with readable secondary.

  • I will be taking a VMWARE based 2014 AG that has one active and one read only node and doing in place upgrade to 2016.  Since the one node is read only is it better to upgrade that box first and then the primary?

  • Not having done this, I would say yes.  I base this on how I upgraded mirrored databases.

  • This was removed by the editor as SPAM

  • tcronin 95651 - Wednesday, December 20, 2017 2:49 PM

    I will be taking a VMWARE based 2014 AG that has one active and one read only node and doing in place upgrade to 2016.  Since the one node is read only is it better to upgrade that box first and then the primary?

    yes, correct. The rolling upgrade scenario is applicable here.
    However some prefer a clean install, it's entirely up to you.
    I've never had too much issue with inplace upgrades of, Windows yes, but not sql

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • This was removed by the editor as SPAM

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

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