Delete large backup history
31. 1. 2026
msdb can get massive when the backup history isn’t purged regularly. In that state, sp_delete_backuphistory can run for a very long time (and sometimes becomes a maintenance nightmare). I built an alternative cleanup script that: purges old rows in batches (TOP + loop) is designed to be restartable and predictable…
