Windows Failover cluster SQL server Reset failure count

Question

Is there any way to reset the failure count within 6 hours ?

I have two node cluster , node 1 failure and the failover to node 2 (failure count 1) , however node 2 also can't bring up the roles .

I fix the issue and the on node 1 bring the role online . If the node 1 failure again , the roles should be in failure state, (coz 1 failover threshold breach) .

How can I reset the failure count once I bring on role online at node 1 ?

Answer 1

Hi @sakuraime ,

This is actually the failover threshold that the count refers to, as far as I know you cannot reset it manually, the time period configured for the clustered role needs to expire to reset the value. Resource brought online successfully does not change the fact that there was a fault during the time period.

Refer to the old similar thread.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.