Ugh - you two beat me to it. Ironically, I just finished such a script to back up and compress my web server's SQL databases (they exceed 2GB, and besides the fact that the ZIP utility seems to take forever when that's the case, I really need each database individually zipped for easy restoration if the need arises).
-R