This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 83%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Hello
Using SQL 2014 Enterprise in a two node AlwaysON group with the databases in synchronous commit. This was about 1 hour ago and the
databases are all still showing as not synchronized.
Data movement is not paused so I cannot resume it.
Any ideas on how to solve this?
Thanks
Additional SQL Server features and topics not covered by specific categories
Answer accepted by question author
Ok so now the databases have slowly started to come back online as synchronized on the secondary. This is a data warehouse so there are no transactions
being applied right now. A failover usually results in green lights in the dashboard within a few minutes.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi @David Gray ,
It seems your issue has been resolved.
In order to close this thread, please kindly accept your answer. Please feel free to let us know if you have any other question.
Best Regards,
Amelia