Great article. It's nice to see some basic new features every once in a while.
Unfortunately, I presume that the fault of an all or nothing backup will make this too risky for most shops to use. In ours, if it's not on tape and off-site, it's not a successful backup. Even if I have the local copy.
I've stuck with the traditional copy/ftp method, but use SQL Backup from Red Gate to accomplish it. They have gone ahead and incorporated the CopyTo command inline with the backup command, making it very easy to set up a job to backup to several locations consecutively.
I just checked their new version 5 help file, and apparently they have also included a MirrorFile option that allows up to 32 mirror locations. However, according to the documentation, they will continue with the backup even if only one of the locations specified works.
Add compression, encryption, and faster backup and restore speed, and the native Backup for SQL Server just doesn't have a chance to be used by me.
You can go here to review the help file online, if curious: (No, I don't have stock in them. For some reason, I get accused of that a lot. Besides, I'm sure the new site owners won't mind.)
Keep up the good work, and I hopefully I'll see you in your classroom sometime soon.