I used this code to refresh a database from production to a report server every night. You can change the parameters to meet your purpose.
As we know, this is equivalent to doing log-shipping except log-shipping does not allow you to utilize destination server as a report server as it is constantly being restored.
Here we are doing it once a night. The report server data is fresh one day behind. If you copy the backup files from another server, add the shell copy commands to get your files.
In our environment, we are doing weekend full-backup and weeknight diff-backup, you might want to choose for your environment.
To find backup set history, see my other publications.
