Post reply

How to apply Service Packs/CUs in Always on AG (SQL server 2017).

  • August 1, 2018 at 11:13 am

    #372828

    We have a SQL server 2017 AG with Primary R/W and Secondary only R, asynchronous mode and set to manual fail over for DR. I wonder, what would be the best approach for patching if we don't want to do a fail over? Suspend the availability DBs in AG on Primary then Patch and reboot the Secondary, then wait for it comeback up.  Then do the same for the Primary and resume the AG ? Is it a good process? Or is there any other recommended method? Please let me know. Thanks in advance.

  • August 2, 2018 at 8:20 am

    #2000003

    Usually you would patch the secondary then fail over to it. In your case you'd have to set the AG to synchronous mode first and let it catch up before you perform the failover. (I know you say you don't want to do a failover, but it's not clear why.)

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

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