Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to apply patches one and more sql at same tme Expand / Collapse
Author
Message
Posted Friday, July 19, 2013 9:29 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 8:38 PM
Points: 152, Visits: 826
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
Post #1475555
Posted Friday, July 19, 2013 10:29 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 10:27 AM
Points: 725, Visits: 5,186
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...
Post #1475589
Posted Friday, July 19, 2013 11:46 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:38 PM
Points: 31,018, Visits: 15,453
Are these SPs or Hotfixes?

I know that some of the installs have command line options so you can script an install.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1475616
Posted Friday, July 19, 2013 11:25 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 10:40 AM
Points: 47, Visits: 813
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.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/83190b71-a348-4a0c-85a0-a36ecf7db4a5/installing-sql-service-pack-by-powershell

Regards,
Post #1475728
Posted Monday, July 22, 2013 12:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 8:38 PM
Points: 152, Visits: 826
its hotfix.
Post #1475871
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse