November 11, 2011 at 11:17 am
I have been given a task to automate the installation of SP2 for sql server 2008 using Powershell and was wondering if anybody has done that before..the automation should also include writing the log to a txt file for overall process.......
Thanks in advance.
November 13, 2011 at 4:27 am
There really isnt a lot to automate. You can do this either in batch file or in powershell.
This is ripped out of one my installation batch files.
C:\admin\SQL Silent Install\SQL2005\SQLServer2005SP3-KB955706-x64-ENU.exe" /quiet /allinstances
The installation produces its own logs and you "can" get these created in a cabinet file so its easy to find.
November 14, 2011 at 1:34 am
MysteryJimbo (11/13/2011)
There really isnt a lot to automate. You can do this either in batch file or in powershell.This is ripped out of one my installation batch files.
C:\admin\SQL Silent Install\SQL2005\SQLServer2005SP3-KB955706-x64-ENU.exe" /quiet /allinstances
The installation produces its own logs and you "can" get these created in a cabinet file so its easy to find.
Warning: It would be good for Installation with default options. Say you have a Server which doesn’t have C: drive, your script file will fail.
November 15, 2011 at 2:05 pm
How about using CMS in 2008 and powershell to install service packs on a bunch of servers at the same time ..is it possible ?
November 16, 2011 at 5:13 am
Trooper09 (11/15/2011)
How about using CMS in 2008 and powershell to install service packs on a bunch of servers at the same time ..is it possible ?
I didn't try it myself. Give it a try & let us know if it works ;-). You may create one article on it later. Many guys will be benefited.
November 16, 2011 at 6:40 am
Dev (11/14/2011)
MysteryJimbo (11/13/2011)
There really isnt a lot to automate. You can do this either in batch file or in powershell.This is ripped out of one my installation batch files.
C:\admin\SQL Silent Install\SQL2005\SQLServer2005SP3-KB955706-x64-ENU.exe" /quiet /allinstances
The installation produces its own logs and you "can" get these created in a cabinet file so its easy to find.
Warning: It would be good for Installation with default options. Say you have a Server which doesn’t have C: drive, your script file will fail.
Not true. The service pack will apply itself to all installed features. Surely "no one" would run my command line without first editing the path first. Especially since this version is for 2005 and not 2008.... I've done this on at least 100 instances with different versions and build numbers, even with cumulative updates so I dont think many people will have an issue.
Dev (11/16/2011)
Trooper09 (11/15/2011)
How about using CMS in 2008 and powershell to install service packs on a bunch of servers at the same time ..is it possible ?I didn't try it myself. Give it a try & let us know if it works ;-). You may create one article on it later. Many guys will be benefited.
Possibly work but I think it unlikely based on my experience of the mini shell implementation of powershell.
November 16, 2011 at 6:50 am
Surely "no one" would run my command line without first editing the path first. Especially since this version is for 2005 and not 2008
Are you sure? 😛
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply