question

NeophyteSQL avatar image
0 Votes"
NeophyteSQL asked AmeliaGu-msft commented

SQL Server HA

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-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi NeophyteSQL,

Did the answer help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia

0 Votes 0 ·

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.