Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL Server Service pack upgrade Expand / Collapse
Posted Monday, September 30, 2013 2:27 PM


Group: General Forum Members
Last Login: Yesterday @ 11:43 AM
Points: 120, Visits: 1,009

I'm trying to upgrade the service packs of all SQL Server (2008,2008 R2 )instances in our environment.
I would like to upgrade it through a batch file instead of the GUI. In our environment we use cmd or batch file for sql installation but i'm not sure how to create a batch file for service pack upgrades.
Did anyone got a chance to work on this ? Please let me know your suggesstions or thoughts.

Fyi, i have the service pack .exe file , i'm looking for a template batch file ...once i'm ready for the upgrade i just want to update the instance name in the batch file.

Please let me know if you need more information

Thanks in advance
Post #1500194
Posted Monday, September 30, 2013 2:53 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, October 5, 2016 10:57 AM
Points: 645, Visits: 1,930
Usually, if you run the executable with the "/?" switch, it will display your choices.

On old versions of SQL, it was something like this:

C:\install\SQLServer200xSPx-.exe /allinstances /quiet

You can use a network share and call it from there.

But honestly, I do not feel comfortable running service packs unattended, specially on critical servers. What if something fails? What about unexpected reboots?

Here is a useful link though:

Installing Updates from the Command Prompt
Post #1500199
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse