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.
💡 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;
sp_delete_backuphistory (Transact-SQL) | Microsoft Docs
Backup History and Header Information (SQL Server) | Microsoft Docs