SQL群集资源组“失败”但群集工作正常 [英] SQL Cluster Resource Group 'Failed' but Cluster working fine

问题描述

我们的SQL群集连续几个月在"角色"下处于"'失败"状态> 资源组。但集群工作正常！



在系统事件日志中，每小时都有一个事件ID 1069错误（源：FailoverClustering）："群集资源"SQL Server CEIP（MSSQL2016）'类型'通用服务'$群集角色'RsrcGrp-MSSQL2016'中的b $ b失败。我已经采取了MSKB中给出的纠正步骤：＃883732，但它没有任何区别。



在运行群集验证测试时，我们只看到一个警告。它只是重复事件日志中的内容。

顺便说一句，此群集基于VMware基础架构中的2个VM。



我怎样才能摆脱失败资源组状态。

解决方案

您好CEIP是客户体验改善服务，因此您的群集无需运行。  

您是否尝试过将资源联机看看会发生什么？ 我可能认为它使用的服务仅安装在一个节点上，因此在故障转移后失败了吗？

服务包括：

   SQL Analysis Services CEIP 
 SQL Server CEIP服务
 SQL Server集成服务CEIP服务  

Our SQL cluster, for many months, has "‘Failed" status under Roles > Resource Group. But the cluster is working fine!

In the System event log, every hour, there is an Event ID 1069 error (Source: FailoverClustering): "Cluster resource 'SQL Server CEIP (MSSQL2016)' of type 'Generic Service' in clustered role 'RsrcGrp-MSSQL2016' failed." I have taken corrective steps given in MSKB: #883732, but it has made no difference.

On running Cluster Validation tests, we see only a Warning. It simply repeats what is in the event log.
BTW, this cluster is based on 2 VMs in VMware infrastructure.

How may I get rid of Failed state of Resource group.

解决方案

Hi CEIP is the Customer Experience Improvement Service and so this is not needed for your cluster to run.  

Have you tried to bring the resource online to see what happens?  I may be that the service that this uses is only installed on one node and therefore it failed after a failover?

Services would include:

SQL Analysis Services CEIP
SQL Server CEIP service
SQL Server Integration Services CEIP service

这篇关于SQL群集资源组“失败”但群集工作正常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！