46,190 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
This is a Veeam problem. Not a SQL Server problem.
Backup job won't run on SQL server
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 53%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sigurd Rønning
6
Reputation points
Hi,
Can anyone help with this error message? We are using Veeam backup.
"Unable to truncate Microsoft SQL Server transaction logs. Details: Failed to call RPC function 'Vss.TruncateSqlLogs': Error code: 0x80004005. Failed to invoke func [TruncateSqlLogs]: Unspecified error. Failed to process 'TruncateSQLLog' command. Failed to truncate SQL server transaction logs for instances: ADVENT. See guest helper log. ."
Community Center | Not monitored
{count} votes
-
Olaf Helper 47,436 Reputation points2022-05-18T08:04:43.013+00:00 We are using Veeam backup.
That's a thrid-party product; have you contacted Veeam support first, may it's a known issue?
-
Dirk Hondong 871 Reputation points2022-05-18T08:19:23.827+00:00 Hi there,
I suppose veeam uses an agent on your target SQL Server.
Under which user account is the veeam agent running?
It seems that the executing account does not have the appropriate permissions.Best regards
Dirk -
Sigurd Rønning 6 Reputation points
2022-05-18T08:32:50.427+00:00 Hi,
The account Veeam uses to take backup have the correct permissions since it's in the "administrators" group locally on the server, so permissions shouldn't be the issue here.. but thanks for the reply!
-
Sigurd Rønning 6 Reputation points
2022-05-18T08:33:23.733+00:00 Hi,
Haven't talked to them yet, can try that. Thanks!
-
Dirk Hondong 871 Reputation points
2022-05-18T08:42:55.703+00:00 Hi there,
what about the permission inside SQL Server?
-
Sigurd Rønning 6 Reputation points
2022-05-18T09:18:01.37+00:00 It has the sysadmin role inside the SQL server.
-
Dirk Hondong 871 Reputation points
2022-05-18T09:36:45.86+00:00 Ok, then it is really weird. Go for Veeam.
I asked because I remember a similar backup software where the executing account needed sysadmin inside instance as well as admin rights on the windows machine.
RPC port is available ,eg Firewall isn't blocking anything?
also, does it happen for a specific database or for all databases?
-
Sigurd Rønning 6 Reputation points
2022-05-18T09:39:41.373+00:00 The FW shouldn't be blocking anything between the SQL server and backup server. My guess is that it's happening for only a few databases, but it might be the whole server. The error message doesn't really say anything about that. I will contact Veeam and see what they have to say. Thanks!
Sign in to comment
2 answers
Sort by: Most helpful
-
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 86%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWB%3C/text%3E%3C/svg%3E)
william bishop 0 Reputation points2023-07-14T13:26:08.89+00:00 You have two choices, you can either make the backup account you're using for veeam a sysadmin on the sql box, or you add the backup account to sql server, and go to each database and give the user backup operator permission. Confirmed working either way in a large veeam environment with quite a few sql servers.