Share via

Databases "not syncronizing" after failover sql 2014

David Gray 176 Reputation points
2020-10-13T14:07:17.883+00:00

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

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,642 questions
0 comments
Accepted answer
  1. David Gray 176 Reputation points
    2020-10-13T14:15:17.35+00:00

    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.

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.