MSDB Backup history Becoming Unmanageable
Posted on 2002-06-12
We have a server with a large number of user databases. (currently 300 odd)
We have a bit of a job managing backup history in MSDB for this server.
I can't believe Microsoft missed this out of their Maintenance plans, but we must run the:
sp_delete_backuphistory every couple of months on this server which can take a day or so to run.
(It seems to take about 1 and a half hours to clear one day's worth!!)
Does anyone have any other experiences or information on dealing with this issue more effectively?