How to Patch SQL Server in Always On Availability Groups | Step-by-Step Guide | Real Time Patching

Join this channel to get access to perks:
/ @mssqldbatechsupport
Join the Telegram Group for the scripts and assistance:
t.me/+sDwstoLc...
To Download the scripts follow the videpo
• Help Us Manage Storage...
We strongly believe there is always chance of betterment, so suggestions are most welcome.
Happy learning, and All the Best in your professional journey!
The journey of improvement is ongoing and never be an end.
Connect With me,
LinkedIn Page --- / mssqldbatechteam
Facebook Page --- www.facebook.c...
Twitter --- / mssqldbasupport
Instagram --- / mssqldbatechsupport
Email --- [e-mail]
Telegram --- t.me/mssqldbaw...
#azuresql #azure #sqldba #sqlserverdba #sql #sqlserver #sqlserverdeveloper #performance #performancetuning #performanceoptimization #mssql #mssqlserver #mssqlserverdba
Thank you!
MS SQL DBA Tech Support
[e-mail]

[@ssv91952]

Super Harsha Bro, works great for my environment, Thanks for your efforts.

[@MSSQLDBATechSupport]

Glad it helped your environment!

[@darbarshahi]

Thank you, sir, for your quick response and for uploading a video.

[@MSSQLDBATechSupport]

It's my pleasure

[@muzeebkhan471]

Thanks for Sharing🤝

[@MSSQLDBATechSupport]

Thank you too👍

[@aniruddhabera6049]

Thanks for sharing this knowledge

[@MSSQLDBATechSupport]

My pleasure

[@basheerahmed9561]

Thanks for sharing 🙏

[@MSSQLDBATechSupport]

Welcome 😊

[@aniruddhabera6049]

Thanks for sharing this

[@MSSQLDBATechSupport]

My pleasure

[@amarcse06]

What about the always on jobs and normal backup jobs ,replication jobs..do we need to disable before doing or we can ignore the jobs ?

[@MSSQLDBATechSupport]

Its always depends upon your organization policies.. Replications jobs u can disable ,if any other jobs and its running then u have to contact job owners and ask is it ok to stop... upon confirmation u can stop or wait until the job completes...

[@sivasankar7013]

Why we need to change synchornous commit to asynchornous commit and why we need to change readable to no
After providing downtime we are proceeding with patches upgradation
Any reason why need to change to asynchronous commit
Any challenges while we doing patches upgradation like msp and msi files missing kindly do on this video

[@MSSQLDBATechSupport]

We switch to asynchronous commit mode during patching because the secondary replica will be unavailable. In this mode, the primary replica doesn't need acknowledgment from the secondary, ensuring that users won't experience any delays.
Additionally, even though we schedule downtime, sometimes the application still points to the server, which can delay the patching process. To avoid this, we set the readable secondary to "No," which closes any existing connections to the secondary. This ensures that the patching proceeds smoothly, allowing us to complete the task on time.

[@Virustech1999]

This is one of the most important term how to patch in always on but I have Currently DAG in this how can we apply the patch can u Please make the video on this then I also do this then remove from DAG n do this video practical

[@MSSQLDBATechSupport]

I have already done on removal of DAG
ua-cam.com/video/xmjSgzxJaFc/v-deo.htmlsi=ZvBwJpD7y02nGv0S
There are multiple scenarios on this, Lets assume both Both Availability groups replicas have same version, then patching is also same how we showed in this video, First we need to do on secondary availability group (secondary replica) after that we need to fail over this forwarder replica,
and then fail over back to forwarder. now repeat the same in secondary of global primary.

[@Absvenkatm]

Can you please explain patch on clustering as well??

[@MSSQLDBATechSupport]

Sure, I'll be able to work on it once I have some free time.