This is a Veeam problem. Not a SQL Server problem.
Backup job won't run on SQL server
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. ."
2 answers
Sort by: Most helpful
-
-
william bishop 0 Reputation points
2023-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.