January 27, 2003 at 10:05 am
I'm trying to find instructions on installing security patches to an active/active sql cluster. Does anyone have or know where I can find this info. easily?
Thanks. Tracy
January 27, 2003 at 11:37 am
For SQL Server, this may help:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;330391
Basically, run the Hot Fix Installer from the node that currently has the resource. It'll bring SQL Server off-line and update the binaries on all physical nodes.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
January 27, 2003 at 11:48 am
Thank you for the link. I'm not clear if I have to uncluster first or if that was just for sql 7.0.
January 27, 2003 at 12:30 pm
For a SQL 2K cluster, you shouldn't have to uncluster. Find out what physical node is running the instance you want to patch (you've got two since you've got an active/active). Run the Hot Fix Installer from that node. It'll stop SQL Server and upgrade that instance across all the nodes. I'm assuming you have to repeat for the other instance.
Of course, this is all academic at this point, I haven't tried it because this tool is brand new and it's out to address the "It is hard to install SQL Server hot fixes" argument that's been used by some sysadmins.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply