Huge msdb database
Posted on 2009-12-17
I have a client that is on SQL Server 2000 Standard with service pack 4. Although they have very few SQL jobs, their msdb database is huge. It is over 7.50 GB!
First, why would this database get so big? Secondly what is the cleanest way to shrink this database?
Normally, I would not be so concerned about this database? But, I stumbled upon this after discovering that their nightly backup job was unable to run due to low disk space. I was able to free up a ton of space. So, they are "good" now. I think, though, that it might be a good idea to reduce the size of this database and see what can be done to prevent it from getting that big again.