Cluster Error 1069 and 1205
0
votes
1
answer
195
views
I have just built a SQL Server 2022 Always on Availability group with 3 Nodes at HQ and 1 Node at DR.
During our testing phase I have noticed every time I rebooted the primary without failing over or moving the cluster resources from the primary I get error
1069
and 1205
in the cluster. My cluster validation came without any error but with some warnings as it is a multi subnet cluster and there was nothing on the cluster logs or sql error logs.
Before I contact Microsoft support I wanted to check if the errors were intended behavior of the cluster. The availability group always automatically failed over every time I rebooted the primary to simulate a failure.
Error 1069
:
> Cluster resource 'ABC_LIVEDB' of type 'SQL Server Availability Group'
> in clustered role 'ABC_LIVEDB' failed.
Error 1205
:
> The Cluster service failed to bring clustered role 'ABC_LIVEDB'
> completely online or offline. One or more resources may be in a failed
> state. This may impact the availability of the clustered role.
I greatly appreciate the guidance.
Asked by SQL_NoExpert
(1117 rep)
Mar 7, 2025, 01:40 AM
Last activity: Jul 9, 2025, 02:08 AM
Last activity: Jul 9, 2025, 02:08 AM