February 25, 2022 at 9:58 am
I've never patched a SQL Server before and was just wanting to know what is the best process to patch the instances, I have a mixture of Stand alone servers and cluster servers with AGs.
Im guessing the sql services will have to restart when patching?
In this process do you have to stop all app servers so that there is no activity on the instance?
Thanks
February 25, 2022 at 1:12 pm
It is a best practice to follow up on SP & CU for your sqlserver version. Especially inspect for issues you experience.
Here's a prep list I found on one of the CU pages:
Hybrid environments deployment
When you deploy an update to a hybrid environment (such as AlwaysOn, replication, cluster, and mirroring), we recommend that you refer to the following articles before you deploy the update:
SQL Server failover cluster rolling update and service pack process.
Note If you do not want to use the rolling update process, follow these steps to apply an update:
Install the update on the passive node.
Install the update on the active node (requires a service restart).
Upgrade and update of availability group servers that use minimal downtime and data loss.
Note If you enabled AlwaysOn with SSISDB catalog, see the information about SSIS with AlwaysOn for more information about how to apply an update in these environments.
How to apply a hotfix for SQL Server in a transactional replication and database mirroring topology
How to apply a hotfix for SQL Server in a replication topology
How to install service packs and hotfixes on an instance of SQL Server that is configured to use database mirroring
Overview of SQL Server Servicing Installation
Whatever you do: Start with a full backup of all your databases !!
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply