September 30, 2013 at 2:27 pm
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
September 30, 2013 at 2:53 pm
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:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply