關(guān)于集群主機數(shù)據(jù)庫打補丁問題的請教,多謝!

renxz

我有2臺HP服務(wù)器,操作系統(tǒng)為WIN2000 advance server,數(shù)據(jù)庫為SQL SERVER 2000企業(yè)版,我用操作系統(tǒng)自帶的集群軟件做了雙機互備.
現(xiàn)在我想給數(shù)據(jù)庫打上補丁SP3A,安裝過程中出現(xiàn)"在集群另一節(jié)點操作失敗",而且'SQL SERVER'服務(wù)脫機停止.不知何故,還望各位高手指教!在給集群數(shù)據(jù)庫打補丁時需要注意什么?
另外再次對noise,eathere上次對我的幫助表示感謝!

renxz

在線等候!

翔198

你必須先把備機關(guān)掉！才可以打主機的！！打完主機關(guān)機�。�！ 啟動備機！再打備機啊��！一臺一臺的打啊�。�！

renxz

多謝上面的老兄,備機關(guān)掉根本就不能裝SQL,因為少了集群節(jié)點.

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.


上面是微軟網(wǎng)站上的英文資料，我覺得你可以在中sql sp3里可以找到相關(guān)的中文資料。