Share via

SQL Server HA

NeophyteSQL 241 Reputation points
2021-08-12T18:54:11.383+00:00

Node is the primary replica and Node B is the Secondary Replica.

Node A and Node B have databases in the Always ON AG. Databases are being synced from Node A to Node B.

what are the consequences if Node A is down for an extended period of time. How to re sync the databases on Node B and will the log files continue to grow on Node B?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 14,016 Reputation points Microsoft External Staff
    2021-08-13T05:31:20.497+00:00

    Hi NeophyteSQL,

    When the primary replica is down, an automatic failover is triggered on the instance of SQL Server that is hosting the primary replica, the secondary replica transitions to the resolving role and then to the primary role. The secondary replica works as a new primary replica. It rolls back any uncommitted transactions and database become available for the users. But in some times, the secondary replica cannot be transitioned to the primary role, and the availability databases are inaccessible. Please refer to this doc which might help.

    How to re sync the databases on Node B and will the log files continue to grow on Node B?

    Yes. And until the replica on node A is available and the data is synchronized, the log can be truncated.

    Best Regards,
    Amelia

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.