Why spend time in a script to backup one or several databases when there are so many tools available.

SQL Backup and FTP lets you backup your databases, schedule backup jobs, and sends you detailed reports in your email. You can even save your backups in remote servers via FTP.