You can copy file to remote server with another step in sql backup job, as long as sql agent service account has write permission on remote location. Or can set sql job remote server to restore db from prod server without copying file, as long as sql agent service account on remote server has read permission on prod server of course.




