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

SQL server patch installation on different servers at a time Expand / Collapse
Author
Message
Posted Monday, January 24, 2011 3:27 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 4:11 AM
Points: 26, Visits: 307
Hello All,

I am trying to get a task done in which I require to run a silent installation of the SQL server Service Pack on multiple servers. The catch here is that this is to be done in non working hours for my organization and hence I am trying to get a method using which i can schedule this silent installation to run on multiple servers at a time/one by one and then when the silent installation is complete or fails, I can check it out the next day.

Now the command for the unattended installation is :

<service pack path> /quiet /allinstances

which is a command shell, so I am looking forward for a way using which I can setup this command to execute on the server at a nonworking time, but I have failed to find a solution.

Any ideas????
Post #1052245
Posted Tuesday, May 3, 2011 3:08 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 9:03 AM
Points: 968, Visits: 965
It's a little late, but I just wrote an article which should help you out:
http://www.sqlservercentral.com/articles/Administration/72733/

Cheers,
Steve
Post #1102730
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse