patching automation

Question

patching automation

ramyours2003

SSChampion

Points: 12268
More actions
March 26, 2019 at 4:51 am

#2031657

i have 20 servers in my environment , need to do automation for sql patching some are cluster and some are standalone , can any one help in providing script to do
August 4, 2021 at 6:20 am

This was removed by the editor as SPAM
May 25, 2022 at 5:20 am

This was removed by the editor as SPAM

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

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

andreas.kreuzberg SSCertifiable Points: 6192 More actions · Answer 1

Hi,
it depends.
Single Nodes are offline if you are patching, no script needed.
And there are a lot of topic, how to patch an Cluster / AOAG.
AOAG, patch the inactive node first, failover and then patch the next inactive node.
Cluster, try to patch the inactive node first. But there are some patches, which need to be installed on the active node.

And be sure, to have a backup from your database, and you testet the restore.

Kind regards,
Andreas

ramyours2003 SSChampion Points: 12268 More actions · Answer 2

Thanks for the reply .I know to patch the sql server but i want to do automate this task on servers.i need how to automate the sql patching on servers .

Sue_H SSC Guru Points: 90860 More actions · Answer 3

ramyours2003 - Tuesday, March 26, 2019 8:07 AM
Thanks for the reply .I know to patch the sql server but i want to do automate this task on servers.i need how to automate the sql patching on servers .

You may want to look at using Powershell for automating the patching. There are quite a few Posh scripts related to automating that. One example:
Update multiple SQL Server systems with PowerShell

dbatools also has a command in their Posh tool set for doing this:
Update-DbaInstance

Sue