Restore multiple db's onto another server
Part 1 of the problem is that the nightly backups create backup file names with the date and time in them. While this is necessary for keeping a few backups of the same db on disk, it's a pain in the glutes to work with when it comes to trying to automate a restore process. Is there way for Redgate to just look for the latest backups? I don't mean manually clicking through files!!! I mean a scheduled job that does these restores to a dev or test server.
Part 2 of the problem is that when looking at the Restore wizard, there does not seem to be a way to restore to a remote server. I should note that the remote servers in question do have a Redgate Backup licence. Looking at the help, it seems the only way to specify a remote server is if restoring a single database, not multiple databases?
I've looked at the command line option. I can certainly script out multiple restores, which is great. However, I am then stuck because of the timestamps in the backup file names.