Log file truncation on AG database I am POCing AlwaysON DAG for my company, and i have come into a very interesting debacle.
Seems like even though primary and replica's and all synced up, the log file on the primary DB does not get truncated automatically even with a checkpoint. It would have to wait for a log backup to be issued. Does it mean that even with AG, we still need to have scheduled TLOG backups running?
Since the databases in an AG always have to have Full Recovery Model, yes, the databases definitely need log backups scheduled frequently to avoid excessive log file growth.