Share via

Windows Failover cluster SQL server Reset failure count

sakuraime 2,326 Reputation points
2021-07-28T07:56:38.257+00:00

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 ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,823 questions
0 comments
Accepted answer
  1. CathyJi-MSFT 22,206 Reputation points Microsoft Vendor
    2021-07-28T10:01:50.45+00:00

    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.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.