SQL Log Truncation and Log Backup Silently Fails After Installing Veeam 9.5 Update 3

KB ID: 2447
Product: Veeam Backup & Replication
Version: 9.x
Last Modified: 2018-02-23


After installing Veeam 9.5 Update 3, SQL logs are truncated during backup, but truncation task is still marked as success in job statistics. SQL Log Backup sessions complete with 0 KB transferred.

You can confirm if any SQL VMs are affected by this change by checking the Guest Helper log located on the Guest VM.

GuestHelper log location:  \\GuestVM\c$\ProgramData\Veeam\Backup\VeeamGuestHelper_%date%.log

The specific error you will find in the GuestHelper log if affected is the following:

Description = The UPDATE permission was denied on the object 'backupset', database 'msdb', schema 'dbo'.



This is due to a change in required SQL Permissions in 9.5 Update 3. These permissions requirements were changed to resolve a previous issue with how Veeam sends requests to SQL to finalize database backup and log truncation. The specific change in permissions is that the msdb system database now requires db_datawriter role, whereas before this was not needed.

Required SQL Permissions for SQL log backup and truncation can be found here:



To resolve this issue, please give the following SQL permissions to the account credentials specified to use for Guest Processing:

  • Sysadmin role, or the following can be used if you need to provide only minimal permissions:
    • SQL Server instance-level roles: dbcreator and public
    • Database-level roles: db_backupoperator, db_denydatareader, public
    • For System Databases:
      • master - db_backupoperator, db_datareader, public;
      • msdb - db_backupoperator, db_datawriter, db_datareader, public
    • Securables: view any definition, view server state
    • For truncation of SQL Server 2012 or SQL Server 2014 database transaction logs, this account should have the db_backupoperator database role (minimal required) or the sysadmin server role.


How helpful is this article: 
4.8 out of 5 based on 2 ratings

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.

Request new content

Report a typo on this page:

Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!

Orphus system