• EN
Question

Unable to truncate SQL server transaction logs

N
Userlevel 2

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.

 

8 comments

MicoolPaul
Userlevel 7
Badge +20

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?

Michael Paul - #VeeamLegend | #VeeamVanguard | Veeam Certified Architect | VMware vExpert | https://micoolpaul.com | Twitter: @MicoolPaul | Mastodon: @micoolpaul@masto.nu | Bluesky: @micoolpaul.bsky.social
N
Userlevel 2

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.

marco_s
Userlevel 7
Badge +7

Hi @Nourinux ,

have you verified corresponding SQL logs in the event viewer?

Marco Sorrentino - Italy | System Engineer | VMCE & Veeam Lover
Chris.Childerhose
Userlevel 7
Badge +20

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

Chris Childerhose - VMCA2022 | VMCE2023 | Veeam Vanguard 7* | Veeam Legend 3* | vExpert 5* | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site – https://just-virtualization.tech
N
Userlevel 2

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?

Chris.Childerhose
Userlevel 7
Badge +20

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?

Error or warning. Look for lines about truncation.

Chris Childerhose - VMCA2022 | VMCE2023 | Veeam Vanguard 7* | Veeam Legend 3* | vExpert 5* | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site – https://just-virtualization.tech
Andanet
Userlevel 7
Badge +10

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. 

Antonio D'Andrea | VCP6-DCV | VMCE 2021 | VMCA 2022 | VMTSP2023 | Veeam Legend 2023 | VUG Italy Leader | I want it written on my tombstone "Please start a restore to the last valid backup"
N
Userlevel 2

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.

Comment


Terms & Conditions