Sample Header Ad - 728x90

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