Host-based backup of VMware vSphere VMs.
Post Reply
itguy1024
Influencer
Posts: 22
Liked: 2 times
Joined: Jun 11, 2015 1:57 pm
Full Name: Scott
Contact:

Constant SQL Truncate Warnings

Post by itguy1024 »

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.
Mildur
Product Manager
Posts: 8678
Liked: 2275 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Constant SQL Truncate Warnings

Post by Mildur »

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
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
itguy1024
Influencer
Posts: 22
Liked: 2 times
Joined: Jun 11, 2015 1:57 pm
Full Name: Scott
Contact:

Re: Constant SQL Truncate Warnings

Post by itguy1024 »

The guest user has sysadmin permissions.
Mildur
Product Manager
Posts: 8678
Liked: 2275 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Constant SQL Truncate Warnings

Post by Mildur »

On every single instance?
Have you looked at the guest helper log what veeam is doing?
GuestHelper log location: \\GuestVM\c$\ProgramData\Veeam\Backup\VeeamGuestHelper_%date%.log
Please do not post the log here. If you need help to understand it, you can open a Support Case with Veeam.
Product Management Analyst @ Veeam Software
Post Reply

Who is online

Users browsing this forum: No registered users and 59 guests