Old Backup History

This warning has been raised because backups older than 60 days (by default, although this can be changed in Aireforge Studio) have been detected.

Suggested Action

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

  • Clear down old backup history entries (which could take a while).
  • Implement a job to maintain the backup history.

How to Clear Down Old Backup Entries in SQL Server

DECLARE @oldest_date DATE = DATEADD(day, 60, GETDATE());
EXEC msdb..sp_delete_backuphistory @oldest_date;

Further Reading

sp_delete_backuphistory (Transact-SQL) | Microsoft Docs

Backup History and Header Information (SQL Server) | Microsoft Docs