FYI, I was getting the below error after upgrading from 9.0 to 9.5 3a.
- Code: Select all
7/12/2018 10:51:36 PM :: [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'.
I just wanted to note that I granted sysadmin access to our Veeam service account on all database instances, reran the jobs and everything was successful for me.
Strangely, I have one instance with databases using the simple recovery model that have always had a warning because Veeam was attempting to truncate logs (I haven't changed this setting because the job is also truncating logs on SQL servers using the Full recovery model). After the sysadmin rights were added, the warning has disappeared as well and the jobs reports that logs were truncated. Seems strange to me, but my goal of getting past the new error and having successful backups was achieved, so I guess I'm not going to question it.