Does anyone else struggle with non-stop warnings about unable to truncate SQL logs?
Old servers, freshly built servers it doesn't seem to matter. I'll clear the issue one way or another, reach out to Veeam, the warnings keep coming back over and over.
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: . See guest helper log.
-
- Influencer
- Posts: 22
- Liked: 2 times
- Joined: Jun 11, 2015 1:57 pm
- Full Name: Scott
- Contact:
-
- Product Manager
- Posts: 9848
- Liked: 2607 times
- Joined: May 13, 2017 4:51 pm
- Full Name: Fabian K.
- Location: Switzerland
- Contact:
Re: Constant SQL Truncate Warnings
Give the guest application processing user the correct permission on the sql server instance. It should be sysadmin.
https://helpcenter.veeam.com/docs/backu ... =110#vesql
https://helpcenter.veeam.com/docs/backu ... =110#vesql
To back up Microsoft SQL Server data, the following roles must be assigned:
- Administrator role on the target VM.
- Sysadmin role on the target Microsoft SQL Server.
Product Management Analyst @ Veeam Software
-
- Influencer
- Posts: 22
- Liked: 2 times
- Joined: Jun 11, 2015 1:57 pm
- Full Name: Scott
- Contact:
Re: Constant SQL Truncate Warnings
The guest user has sysadmin permissions.
-
- Product Manager
- Posts: 9848
- Liked: 2607 times
- Joined: May 13, 2017 4:51 pm
- Full Name: Fabian K.
- Location: Switzerland
- Contact:
Re: Constant SQL Truncate Warnings
On every single instance?
Have you looked at the guest helper log what veeam is doing?
Have you looked at the guest helper log what veeam is doing?
Please do not post the log here. If you need help to understand it, you can open a Support Case with Veeam.GuestHelper log location: \\GuestVM\c$\ProgramData\Veeam\Backup\VeeamGuestHelper_%date%.log
Product Management Analyst @ Veeam Software
Who is online
Users browsing this forum: No registered users and 23 guests