Is there a background process that automatically deletes backup history?
Hi I'm trying to write a query to retrieve the last FULL BACKUP date, this particular database servers has many databases with Full, Differential and Transaction log backups that run. On the large databases a full backup gets done once a month, the rest once a week. When querying msdb.dbo.backupset, the max full backup date is retrieved for all db's except the ones backup once a month. It seems to keep backup history for only certain period. MSDB has the following procs that delete backup history: -sp_delete_database_backuphistory -sp_delete_backuphistory but these procs have not been run. My question: Is there any process that automatically deletes the backup history tables?