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 Service pack upgrade Expand / Collapse
Posted Monday, September 30, 2013 2:27 PM


Group: General Forum Members
Last Login: Wednesday, September 23, 2015 7:58 AM
Points: 100, Visits: 856

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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, September 25, 2015 11:38 AM
Points: 574, Visits: 1,689
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