Does the High-Volume Agent Truncate Transaction Logs?

Question

Does the High-Volume Agent truncate SQL Server transaction logs?

Environment

Connector: High-Volume Agent SQL Server

Answer

No, the High-Volume Agent reads from the secondary replica and does not truncate transaction logs. To allow safe log truncation, confirm that the agent has successfully read the relevant transaction log records, then run the following command on the primary replica at regular intervals:

EXEC sp_repldone @xactid = NULL,
                 @xact_seqno = NULL,
                 @numtrans = 0,
                 @time = 0,
                 @reset = 1;

In environments that use Cohesity for SQL Server backups, run this command after each successful Cohesity backup job.

Running this command only after the logs have been read ensures that SQL Server truncates only processed transactions and helps prevent data loss.