Home Forums SQL Server 2016 SQL Server 2016 - Administration inplace upgrade for 2014 to 2016 with readable secondary. RE: inplace upgrade for 2014 to 2016 with readable secondary.

  • December 21, 2017 at 8:30 am

    #1973094

    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" 😉