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 🙂