Any can help to solve this error please?
“
2024/3/27 11:04:52 :: Unable to truncate SQL server transaction logs. Details: Failed to truncate SQL server transaction logs for instances: MSSQLSERVER.
“
It is from a backup job of a physical server.
Question
Unable to truncate SQL server transaction logs
+23Hello!
Have you followed the documentation to make sure the account you’re using to interact with the server has the relevant SQL Server permissions on this instance?
Michael Paul - Opinions are my own and do not necessarily reflect the opinion of Veeam | https://micoolpaul.com | Mastodon: @micoolpaul@masto.nu | Bluesky: @micoolpaul.com
Hello!
Have you followed the documentation to make sure the account you’re using to interact with the server has the relevant SQL Server permissions on this instance?
Yes I did.
And the warning error started only today, the backup was successful with warning for few days.
+8Hi
have you verified corresponding SQL logs in the event viewer?
Marco Sorrentino - Italy | System Engineer | VMCE & VMCA
+21Do you have AAIP enabled in your job for SQL? Check the logs here for the backup job name to see if that gives you more details - C:\ProgramData\Veeam\Backup
Chris Childerhose - VMCA2024 | VMCE2023 | VMCE-SP2024 | Veeam Vanguard 8* | Veeam Legend 5* | VUG Canada Leader | vExpert 6* | Toronto VMUG Leader | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site – https://just-virtualization.tech
Do you have AAIP enabled in your job for SQL? Check the logs here for the backup job name to see if that gives you more details - C:\ProgramData\Veeam\Backup
Yes enabled.
What keyword are we looking for in the logs?
+21Do you have AAIP enabled in your job for SQL? Check the logs here for the backup job name to see if that gives you more details - C:\ProgramData\Veeam\Backup
Yes enabled.
What keyword are we looking for in the logs?
Error or warning. Look for lines about truncation.
Chris Childerhose - VMCA2024 | VMCE2023 | VMCE-SP2024 | Veeam Vanguard 8* | Veeam Legend 5* | VUG Canada Leader | vExpert 6* | Toronto VMUG Leader | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site – https://just-virtualization.tech
+11Any can help to solve this error please?
“
2024/3/27 11:04:52 :: Unable to truncate SQL server transaction logs. Details: Failed to truncate SQL server transaction logs for instances: MSSQLSERVER.
“
It is from a backup job of a physical server.
Please refer to the KB https://www.veeam.com/kb2027.
Antonio D'Andrea | VMCE 2021 | VMCA 2022 | VMTSP2024 | Veeam Legend | VUG Italy Leader | Object First Ace | VCP6-DCV | I want it written on my tombstone "Please start a restore to the last valid backup"
Any can help to solve this error please?
“
2024/3/27 11:04:52 :: Unable to truncate SQL server transaction logs. Details: Failed to truncate SQL server transaction logs for instances: MSSQLSERVER.
“
It is from a backup job of a physical server.
Please refer to the KB https://www.veeam.com/kb2027.
Thanks!
But it didn’t solve the issue.
I opened a case about it, the support team is checking the logs and figuring out the root of the issue.
+21This is a very good article if it pertains to your issue. I would check it out.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.