February 21, 2007 at 11:17 am
I found documentation on how to install SP4 on a cluster, but am questioning how to do the hotfix SQL2000-KB916287-v8.00.2187.
Should the hotfix be applied to each node of the cluster or just to the active node?
Thanks
February 22, 2007 at 2:37 am
Our standard is to apply HF 2187 to every SQL instance.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 22, 2007 at 3:38 am
I'm sure it's cluster aware and is applied to the virtual server - sorry don't do that many patches on clusters so tend to forget!
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 22, 2007 at 8:44 am
It is cluster aware. Apply it to the active node. It will prompt you for login information and will apply the fix to all. The login must be admin. on all nodes in the cluster.
February 22, 2007 at 9:14 am
Tom's note reminded me... The apply of HF 2187 to the active node will only update cluster-aware components on the other node(s).
At the very least, Management Studio will not have been updated. If you have SSIS and have not clustered it, then SSIS on the passive node(s) will not have been updated. If you want the same fix level on all components (my recommendation!) then you need to apply HF 2187 to all nodes individually.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 22, 2007 at 10:25 am
We had to patch our Cluster a couple of years ago, but I couldn't recall the exact steps. I found the article that I used though, and you just need to install it on the active node.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply