While backing up SQL workloads, the job returned an error saying “Unable to truncate Microsoft SQL Server transaction logs. Details: Failed to process 'TruncateSQLLog' command. Failed to truncate SQL server transaction logs for instances: . See guest helper log. .”
what could be the reason for this?
In the sql settings, I enabled “backups logs periodically” and specified retention period. does these settings have something to do with the error?
Best answer by Chris.Childerhose
View original
+20
This could be SQL was too busy at the time of the backup or maybe the SQL VSS writer is not in a good state. Also if you have SQL native backup or other jobs running this can interfere as well. Best to check the job logs to see for sure.
+12
You will find the mentioned logs from
C:\ProgramData\Veeam\Backup\VeeamGuestHelper_DATE.log
Look the logs for sql related errors.
+13
Maybe the user used for guest interaction does not have necessary permissions?
+9
Just like
- https://www.veeam.com/kb2027
- https://helpcenter.veeam.com/docs/backup/agents/protection_group_computers.html?ver=110
It is imperative that you take a look at the log as there could be other issues as suggested by
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
