步骤1:升级被动节点
1. 先从被动节点升级数据库引擎
2.升级好后安装累积更新包CU5
3.在被动节点升级完成后,将SQL及DTC群集服务转移到被动节点.发生的错误
使得SQL SERVER 服务Properties, Advanced Policies两个节点都要选上。
Failover Cluster - Moving resource error
When trying tomove "SQL Server (MSSQLSERVER)" service to second node we receivenext error:
The operation has failed.
The action "Move to node SQL2" did not complete.
Error Code: 0x80071398
The operation failed because either the specified cluster node is not owner ofthe group, or the node is not a possible owned of the group
First of all we need to check if node is owner of the group:
cluster res "SQL Server" /listowners
If node doesn't exist in cluster owner group add it:
cluster res "SQL Server" /addowner:SQL2
Where "SQL Server" - name of clustered service or application;SQL2 - name of second node.
Second step is checking if second node is a possible owner of the group:
1. Go to cluster shared disk
2. Click Properties, Advanced Policies
3. Make sure that second node checkbox is checked.
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/7da7d9e6-c42e-4b63-ade5-272f689c5ab7/the-action-move-to-node-sqln1-did-not-
complete-an-error-occured-moving-the-clustered-service-or