There are a few tools that have been posted on codeplex, that are worth using or at least exploring:
- Microsoft IT Site Delete Capture 1.0 – Simply captures sites that are deleted by end users and backs them up to disk using the event model. You have a recycle bin, but this is basically a site recycle bin (available only to administrators). (Works with WSS 3.0 and Office SharePoint Server 2007)
- MS IT Site Life Cycle Management 1.0 – Notify, Backup then Delete Unused Unneeded sites (Works with WSS 3.0 and Office SharePoint Server 2007)
- MS IT Usage Reporting Framework 2.0 – Simple reporting framework to gather usage and storage metrics on WSS 3.0, MOSS 2007 and works with multiple farms. Note the caveats with SQL read queries listed on the framework homepage (direct select statements against the database).
As mentionned , these tools can be found on codeplex @ http://www.codeplex.com/governance