Grant Fritchey (8/16/2016)
I have an article on how to retrieve information [/url]from your backups that could help. You'll just have to convert that information into what you need for the restore as Jeff has outlined.
It's a real shame that MS doesn't allow INTO sometemptable on these commands especially since they're not designed to identify the meta-data and so you can't even use something like a dynamic OPENROWSET to capture the output. Do you know of a non-xp_CmdShell method to get the data from such command into a table?
--Jeff Moden
Change is inevitable... Change for the better is not.