Automating SQL Server Service Pack installation

  • Hello all,

    I need to upgrade the Service Pack level on my office environment servers and as the number of servers is large I want to automate this process so that I can just run a command and leave the rest on the server so that I do not have to night watch the installation. One of the reasons for this is that I need to perform the upgrade in the off working hours so as to decrease the resource usage on the server.

    To clarify more a similar thing is when we install the SQL server using Command Line and mention the Configuration file from which the setup can get the details :

    Setup.exe /ConfigurationFile=ConfigurationFile.INI

    I am looking for something like this so that I can just run the setup and leave and view if something has gone wrong in the nightly installation.

    Thanks in advance for any help that I can get.

  • Automating installation is a good idea but installing service packs w/o knowing the imapct :w00t:... is not advisible.

    Abhijit - http://abhijitmore.wordpress.com

  • Hey Abhijit,

    Well I just need a process to test it out. The Service Pack to be installed are already tested on different servers. I need a way to just automate the running of the installers and then for them to completed with the pre provided information regarding the installation.

    Any ideas?

  • http://msdn.microsoft.com/en-us/library/dd638062(v=sql.100).aspx

    if you find the above steps confusing use this tool :

    http://sqlslipstreamer.codeplex.com/

  • rahulr.sharma (1/18/2011)


    Well I just need a process to test it out. The Service Pack to be installed are already tested on different servers. I need a way to just automate the running of the installers and then for them to completed with the pre provided information regarding the installation.

    If you don't care much about downtime on your servers, go along. If downtime is "not an option", then automatic patching and automatic installation of service packs are not an option either. You may very well have tested it, but I've seen so many cases where small differences makes an installation fail, or give error situations. And of course, you do definitely NOT want automatic updates of a cluster or other high availability solutions, those "require" patching according to best practices to minimize downtime.



    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

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

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