SQL群集资源组“失败”但群集工作正常

问题描述

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



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



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

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



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

解决方案

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.

解决方案

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