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

šŸ’” Aireforge Advisor can automatically generate a script for this.

  • Set up regular backups of the transaction log, or
  • Change the recovery model to SIMPLE if this is not a production database, and the ability to restore point in time data is not required.

Further Reading

Back Up a Transaction Log | Microsoft Docs

Recovery Models (SQL Server) | Microsoft Docs