Skip to main content
Question

Unable to truncate SQL server transaction logs

  • March 27, 2024
  • 10 comments
  • 1146 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
  • March 27, 2024

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+8
  • On the path to Greatness
  • March 27, 2024

Hi @Nourinux ,

have you verified corresponding SQL logs in the event viewer?


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

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
  • March 27, 2024

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+21

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+11
  • Veeam Legend
  • March 28, 2024

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
  • April 1, 2024

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
  • August 7, 2024

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

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.