I like what you have done although I have not tried running the script yet.

Ideally I would like to copy the database to another server, not onto the same server (normally to be used for reporting purposes).

In my (limited) experience I have had to run one job to do the backup, then a seperate scheduled task that (via batch job) copies the backup file to remote server, then a seperate agent task scheduled to run about an hour later that restores the file on that server.

If there is a way to run just one script, that does the backup, then restores the file on the remote server, that would be even better.

T