关于集群主机数据库打补丁问题的请教,多谢!

renxz

我有2台HP服务器,操作系统为WIN2000 advance server,数据库为SQL SERVER 2000企业版,我用操作系统自带的集群软件做了双机互备.
现在我想给数据库打上补丁SP3A,安装过程中出现"在集群另一节点操作失败",而且'SQL SERVER'服务脱机停止.不知何故,还望各位高手指教!在给集群数据库打补丁时需要注意什么?
另外再次对noise,eathere上次对我的帮助表示感谢!

renxz

在线等候!

翔198

你必须先把备机关掉！才可以打主机的！！打完主机关机！！！ 启动备机！再打备机啊！！一台一台的打啊！！！

renxz

多谢上面的老兄,备机关掉根本就不能装SQL,因为少了集群节点.

dooza

To install the service pack on a failover cluster

1.If any resources have been added with dependencies on SQL Server resources, those dependencies must either be removed or taken offline before you install SP3a. If you do not do this, the installation of SP3a may cause those dependent resources to fail over.


2.Run the service pack from the node that owns the group containing the virtual server that you are going to upgrade. This installs the service pack files on all nodes in the failover cluster.


3.In the Setup dialog box, type the name of the virtual server that you are upgrading.


4.Keep all nodes of the cluster online during setup. This ensures that the upgrade is applied to each node of the cluster.


5.If you removed dependencies or took resources offline in Step 1 above, add back the dependencies or bring the resources back online.


上面是微软网站上的英文资料，我觉得你可以在中sql sp3里可以找到相关的中文资料。