It copies the backup files not the .mdf or .ldf , moeover the article explains some params of the roocopy so that it will retry a few times to copy the backup files.

Once the backup files copied in the second location you should be able to restore the database.

This tool looks to me more as an"quick and dirty" 🙂 extension of the backup so that it also push the database to another location.

Maybe what you are looking for is mirroring, replication, failover clustering, etc.

Regards,

Iulian