Hi, I have all my DB set to full backup every 24 hours and transaction logs every 12 hours.
The backups all appear to run ok however the logs are not being truncated. Am I missing any settings?
Hi Ben,
SQLBackupAndFTP performs backups of your SQL Server databases via Standard T-SQL Commands in the same way as you do it via SSMS.
To truncate Transaction Logs, you have to have regularly run transaction log backups. Also, you can add the needed scripts to truncate or shrink your transaction log after a backup at the “Run custom scripts” section. Perhaps you have to run the transaction log backups more frequently than every 12 hours, for example, every hour?
Here are more details: How to automate maintenance of your databases | SQLBackupAndFTP's blog
Also, you can find more detail on how to truncate and shrink transaction log on the web.
If you have any other questions, please let us know.