Veeam 9.5 update 3a and SQL backups

Ill like to highlight that after updating “Veeam Backup and Replication” to “version 9.5 update 3a” you might start to see warnings like this in your Veeam status reports:

Warning: [TDB]Unable to update SQL backupset for instance : Code = 0x80040e09 Code meaning = IDispatch error #3081 Source = Microsoft OLE DB Provider for SQL Server Description = The UPDATE permission was denied on the object ‘backupset’, database ‘msdb’, schema ‘dbo’.

The reason for this is that in “update 3a” Veeam has changed their way of taking backing up and handling the transaction log of MS SQL servers.

Veeam KB2689 will give you some useful information on this topic.

I have a dedicated account on the domain called “VeeamVSS” which I’m using for all domain servers so the only thing that I did to solve the problem was to include “VeeamVSS” in the local “Log on as a batch job” group on the SQL server and then assign it the “sysadmin” role inside the SQL server. If you would like to know more about the needed permissions for SQL db and log backup for Veeam, then look here in the Veeam helpcenter: Link

The backup email report is again showing my favorite color – GREEN!

The above issue was also mentioned in Anton Gostev weekly newsletter, which I can highly recommend that you assign yourself to. Here is a guide on subscribing to his weekly digest: Link

Please follow and like my blog:

2 comments

    1. Inside SQL Management studio: Security -> Logins – right click the user that must have sysadmin role and select properties.
      Under “Server Roles” click “sysadmin”.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.