Steve Jones - Editor (6/10/2010)
If you want to use Powershell here, I found a cool script from SQL Chicken: http://sqlchicken.com/2010/06/powershell-i-heart-you/
Woot! Thanks for the shout-out Steve! Big thanks to Stanley though, very cool base script/issue to work on and learn PowerShell with.
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management