March 12, 2015 at 6:55 am
how to update the windows patch on sql server where the server is configured in always on ?
March 12, 2015 at 7:14 am
ramyours2003 (3/12/2015)
how to update the windows patch on sql server where the server is configured in always on ?
Hi ramyours2003,
alwaysOn with SQL Server Failover Cluster or Highavailability Groups?
Does not matter if your HAG Setup is correct (User copy, all DBs Part of HAG, Listener correct)
Then follow these steps:
1) Start Failover
2) Patch passiv Server with your Windows Updates (with restart)
3) Start Failover
4) Patch passiv Server with your Windows Updates (with restart)
I hope this is understandable
March 12, 2015 at 7:23 am
Thanks for the reply ,
I have 2 servers ,server1 and server 2 where the availability Group is primary on server 2 and active node is server1 . In this how can I do patch ?
March 12, 2015 at 7:31 am
ramyours2003 (3/12/2015)
Thanks for the reply ,I have 2 servers ,server1 and server 2 where the availability Group is primary on server 2 and active node is server1 . In this how can I do patch ?
You habe 2 Servers with 1 HAG
When server 2 is the primary then server 2 is the active (primary) node.
Server 1 is the secondary server.
1) Start windows updates on your secondary server (with restart)
2) Take a look in your HAG Dashboard for errors
3) No errors, then start a manual failover (Server 1 is now primary, server 2 is secondary)
4) Start windows updates on your new secondary (server 2) ((with restart))
5) Take a look in your HAG Dashboard for errors
6) Failback when server 2 is generell your primary workload server
March 12, 2015 at 8:34 am
Thanks for the reply and workaround ...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply