Christian Buettner-167247 (4/30/2010)
Tested it with SSMS and failed ("Select the Backup Sets to restore" shows no entries after selecting the tail backup in "From device:")...
If anyone could tell me if restoring tails from SSMS (only the tail, not the complete backup sequence) is possible, that would be great.
SSMS doesn't support every possible restore strategy: the built-in feature that stitches together a sequence of restores is limited to the most common requirements.
You can still achieve the result via the UI, by performing one step at a time, it's just not as convenient.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi