MSDB Cleanup

Enterprise Manager hang

My customer’s SQL 2000 .818 box has started timing out when he tries to use Enterprise manager to backup or restore a database.

After giving him the command to run in Query Analyzer, I took a look at his backup tables in MSDB and found roughly 3.8 million records in each…dating back to mid 2005.

I’ll be running sp_delete_backuphistory tonight. 🙂

If you don’t want to use the cursor driven proc provided by MSFT, click here for Tara Kizer’s custom script:

Sorry for the long delay between postings…its been slow 🙂


Leave a Comment

Sign up for our Newsletter

%d bloggers like this: