asked
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?
No. Unless you clear out the backup history, it will stay for years.....(slowly grinding your msdb database to. a. halt.) Something must have purged the data.
I managed to run a trace and see that the job sp_delete_backuphistory is running every 10 minutes or so, just struggling to find out who or what is running it.
15 People are following this question.
