Question

SQL Logs Not Truncating Even Though Backup Succeeds

+4

Hi Team,

I am getting this warning during a Veeam Agent backup:

Warning: Unable to truncate SQL server transaction logs. Details: Failed to truncate SQL server transaction logs for instance XYZ.

The backup completes successfully and application aware processing is enabled, but the SQL logs are not truncating.

Any idea what could cause this or what I should check next?

Thanks.

+13

Hi,

Did you check all the required permissions? Maybe you can provide some screenshots for us to check.

I’d also recommend to open a Veeam support case to let them assist you on a more detailed level.

LK | Enterprise Architect @ Veeam Software | Former Veeam Vanguard | Security Specialist

+2

In addition to what Lukas mentioned, Check following

Confirm the VSS writer status on the SQL server. Run vssadmin list writers and all writers should show Stable with no errors.

Verify the SQL recovery model. Veeam Log truncation works only if the database is in Full or Bulk Logged recovery model.

Mohamed Ali | VUG leader | VMCE 2024, VCP-DCV, CCP-V

+11

Hi Team,

I am getting this warning during a Veeam Agent backup:

Warning: Unable to truncate SQL server transaction logs. Details: Failed to truncate SQL server transaction logs for instance XYZ.

The backup completes successfully and application aware processing is enabled, but the SQL logs are not truncating.

Any idea what could cause this or what I should check next?

Thanks.

Check event viewer error and post it.

+8

This is a somewhat well-known mistake. Have you seen this post?

Jean Sczepanski Peres

Sign up