Question

Unable to truncate SQL server transaction logs


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

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?

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.

Userlevel 7
Badge +7

Hi @Nourinux ,

have you verified corresponding SQL logs in the event viewer?

Userlevel 7
Badge +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

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?

Userlevel 7
Badge +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.

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

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