Log file growth availability groups

Question

if database backups (Full and T Log) are issued on SQL Server databases included in aviability groups on the secondary replica, does the T -log continue to grow on the primary replica , how does the T-log kept in check on primary

Answer 1

Hi NeophyteSQL,

The log backup on the primary replica will truncate the log if database backups (Full and T Log) are issued on SQL Server databases on the secondary replica.
Once hardened to the secondary database log file, a dedicated redo thread in the secondary replica instance applies the contained log records to the corresponding data file(s). The primary replica cannot overwrite log blocks in its own log file until all redo threads in all secondary replicas have applied the contained log records. Please refer to Data synchronization process which might help.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.