Post reply

Install Service Packs In Parallel Across Multiple Servers - Script Or Tool?

  • February 6, 2012 at 11:45 am

    #264037

    Is there a script or any third party tool which can help in deploying service packs and CU's across multiple sql servers in parallel?

  • February 7, 2012 at 4:49 pm

    #1444228

    I did some research and found two different things. Basically i want to install a SP from management studio on the same server where i am running the script.

    BOL said to use this:

    xp_cmdshell 'C:\Temp\SQLServer2005SP4-KB2463332-x86-ENU /qs /IAcceptSQLServerLicenseTerms /Action=Patch /InstanceName=MSSQLSERVer'

    Based on this http://www.databasejournal.com/features/mssql/article.php/3623126/SQL-Server-2005-150-Unattended-installation-150-Part-V.htm sounds like i should be using :

    xp_cmdshell 'C:\Temp\SQLServer2005SP4-KB2463332-x86-ENU /quiet'

    None of these work, they don't give any error but keeps running. Ideally should take about 45 - 60 mins to complete the install but this one keeps running and i don't even see any log under default folder. My goal is to install sp using management studio on the same server, has anyone done that before?

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

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