Share via

SQL HA cluster - not synchronizing

Jack 20 Reputation points
2023-10-10T11:39:29.11+00:00

Hi,

I've got a SQL HA failover Cluster with 2 nodes and 2 databases.
Node 1 should be the primary instance for db 1 and secondary for db 2.
Node 2 should be the primary instance for db 2 and secondary for db 1.

A failover occurred yesterday and right now node 2 is the primary for both databases.
However for (..some reason..) node 1 is currently 'Not Synchronizing' db 1 as shown in the HA dashboard.

I've read on the Microsoft help pages I should resume the data movement and that will fix it.
Unfortunately I only see the option to Suspend the data movement, so that seems fine.

Question: can I just suspend the data movement on node 2 (currently primary for db1) and then resume data movement without any issues?

Thanks,
Jack

SQL Server | Other
Accepted answer
  1. Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator
    2023-10-10T21:10:13.36+00:00

    I don't know about the UI, but you can try this from a query window:

    USE master 
go
ALTER DATABASE YourDB SET HADR RESUME

    Not that I am sure that it will resolve the issue.

    1 person found this answer helpful.

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.