July 19, 2013 at 9:29 am
one of the our client ask to me ,300 sql servers need to apply patches same time ?
how to do ? Any vb cript or batch command..
Plz anyone help on this
Thanks,
jery
July 19, 2013 at 10:29 am
The only time (that I'm aware of) that you need to install patches at (almost) the same time, is in any sort of a DR / HA setup (clustering, log shipping, etc) You want to keep both SQL Servers at the same version.
Typically with a cluster the recommendation is to move all services to one host, patch and reboot the "inactive" host, once it comes back up and the cluster stabilizes repeat the process for the next host(s).
Otherwise, when and how many servers get patched depends on the business rules and the people doing the patches...
July 19, 2013 at 11:46 am
Are these SPs or Hotfixes?
I know that some of the installs have command line options so you can script an install.
July 19, 2013 at 11:25 pm
It is possible from Powershell Jobs, except those 300 machines need to have PS Remoting enabled with force enabled and appropriate permission to take session, take a look at this.
Regards,
July 22, 2013 at 12:15 am
its hotfix.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply