SQL server patch installation on different servers at a time

  • 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????

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

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