關(guān)于集群主機(jī)數(shù)據(jù)庫(kù)打補(bǔ)丁問(wèn)題的請(qǐng)教,多謝!

renxz

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

翔198

你必須先把備機(jī)關(guān)掉！才可以打主機(jī)的�。〈蛲曛鳈C(jī)關(guān)機(jī)�。�！ 啟動(dòng)備機(jī)！再打備機(jī)�。�！一臺(tái)一臺(tái)的打�。。。�

renxz

多謝上面的老兄,備機(jī)關(guān)掉根本就不能裝SQL,因?yàn)樯倭思�群�?jié)點(diǎn).

dooza

To install the service pack on a failover cluster \r\n\r\n1.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.\r\n\r\n\r\n2.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.\r\n\r\n\r\n3.In the Setup dialog box, type the name of the virtual server that you are upgrading.\r\n\r\n\r\n4.Keep all nodes of the cluster online during setup. This ensures that the upgrade is applied to each node of the cluster.\r\n\r\n\r\n5.If you removed dependencies or took resources offline in Step 1 above, add back the dependencies or bring the resources back online. \r\n\r\n\r\n上面是微軟網(wǎng)站上的英文資料，我覺(jué)得你可以在中sql sp3里可以找到相關(guān)的中文資料。