Andrew Hodge wrote:The problem with this is you cant restore filenames based on wildcard like you can in sqlbackup.
So if you have a backup name that changes due to including the date and time then it becomes difficult to script for.
Can I have a feature request of allowing the virtual restore to allow wildcard filenames
Sorry for the loooong delay in replying, this slipped through due to holiday breaks.
This request is also covered in this thread http://www.red-gate.com/MessageBoard/viewtopic.php?p=49845
The short version is that SQL Virtual Restore uses native T-SQL syntax, and as such the approach proposed by epetro in the other thread (dynamic T-SQL) is the way to do this. That said, we're working on making scheduling easier to do, but I can't provide details on this yet.