How to do patching on AlwaysOn servers

Question

How to do patching on AlwaysOn servers

coolchaitu

SSChampion

Points: 10334
More actions
September 8, 2018 at 9:19 am

#408406

Good morning Experts,
How to do patching on AlwaysOn servers for synchronous mode and asynchronous mode

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

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

Eddie Wuerch SSChampion Points: 12535 More actions · Answer 1

You patch AGs the same way you upgrade them.

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/upgrading-always-on-availability-group-replica-instances?view=sql-server-2016

-Eddie

Eddie Wuerch
MCM: SQL

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 2

coolchaitu - Saturday, September 8, 2018 9:19 AM
Good morning Experts,
How to do patching on AlwaysOn servers for synchronous mode and asynchronous mode

Sounds like a interview question. If you really understood how always on works while setting up AG you should be able to answer your question. If this is something someone else handed you down please go through MS documentation.

coolchaitu SSChampion Points: 10334 More actions · Answer 3

curious_sqldba - Sunday, September 9, 2018 8:17 PM
coolchaitu - Saturday, September 8, 2018 9:19 AM
Good morning Experts,
How to do patching on AlwaysOn servers for synchronous mode and asynchronous mode
Sounds like a interview question. If you really understood how always on works while setting up AG you should be able to answer your question. If this is something someone else handed you down please go through MS documentation.

Don't assume things. It is not an interview question. Your reply is so immaturity. Why these forums if everybody understands everything. Everybody knows there is documentation. If you know the answer tell it else keep quiet

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 4

coolchaitu - Sunday, September 9, 2018 10:47 PM
curious_sqldba - Sunday, September 9, 2018 8:17 PM
coolchaitu - Saturday, September 8, 2018 9:19 AM
Good morning Experts,
How to do patching on AlwaysOn servers for synchronous mode and asynchronous mode
Sounds like a interview question. If you really understood how always on works while setting up AG you should be able to answer your question. If this is something someone else handed you down please go through MS documentation.
Don't assume things. It is not an interview question. Your reply is so immaturity. Why these forums if everybody understands everything. Everybody knows there is documentation. If you know the answer tell it else keep quiet

Keep in mind people on this forum are taking time out of there regular lives and helping other people. If you are being lazy to google and assuming you can throw a question here to get an answer is probably not the right way to learn. How about trying it out at Microsoft virtual labs yourself? Long story short , i am assuming you meant to ask how do you patch servers involved in AG with out having significant outage. You failover to secondary node patch first node, then fail it back and patch secondary.