April 5, 2007 at 5:16 am
Does anyone know whether it's possible to script the unattended installation of SP2 and the subsequent cumulative hotfix (build 3152) to all 8 named instances on our 2005 Standard Edition server?
Any advice would be greatly appreciated.
April 5, 2007 at 5:45 am
Be sure to make backups of _ALL_ databases !!
With sp1 you could use
SQLServer2005SP1-KB913090-x86-ENU.exe /quiet /allinstances
The same can be done for sp2.
Check SQL2005SP2_SETUP_sqlhotfix.chm. The parameters are described.
You can apply the HF using the same parameters
check out sqlserver2005-kb933097-x86-enu.exe /?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 5, 2007 at 7:02 am
Thanks for your help, ALZDBA. I didn't wait for the parameters to be returned by the executable and assumed it was ploughing straight into the installation!
Cheers.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply