Skip to main content
Question

Unable to truncate SQL server transaction logs

  • Mar 27, 2024 3:49 AM UTC
  • 10 comments
  • 1636 views

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.

 

10 comments

MicoolPaul
Forum|alt.badge.img+23

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?


  • Author
  • New Here
  • Mar 27, 2024 6:21 AM UTC

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
Forum|alt.badge.img+9
  • Veeam Vanguard
  • Mar 27, 2024 8:28 AM UTC

Hi @Nourinux ,

have you verified corresponding SQL logs in the event viewer?


Chris.Childerhose
Forum|alt.badge.img+23

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


  • Author
  • New Here
  • Mar 27, 2024 11:42 PM UTC

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
Forum|alt.badge.img+23

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.


Andanet
Forum|alt.badge.img+13
  • On the path to Greatness
  • Mar 28, 2024 11:33 PM UTC

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. 


  • Author
  • New Here
  • Apr 1, 2024 3:35 AM UTC

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.


  • New Here
  • Aug 7, 2024 4:26 PM UTC

Chris.Childerhose
Forum|alt.badge.img+23

May be this: 1 new message (stephenwagner.com)

 

Petr

This is a very good article if it pertains to your issue.  I would check it out.