No Recent Transaction Log Backup

If the recovery model is set to FULL, all transactions are logged in the transaction log, with the log only being cleared when the transaction log is backed up (or when a full or incremental database backup is performed). Without frequent backups of the transaction log, the log file will continue to grow with each transaction. And, more importantly, without regular log backups, more data will be lost in the event that the database fails and must be rebuilt from backups.

Suggested Action

Set up regular backups of the transaction log.


Change the recovery model to SIMPLE if this is not a production database, and the ability to restore transaction logs is not required.

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.