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
Author
Message
Posted Monday, September 30, 2013 2:27 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 8:54 AM
Points: 95, Visits: 793
Hello,

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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 9:54 AM
Points: 416, Visits: 1,350
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