Thank this author by sharing:
By Dimitris Mesinis,
This script is designed to restore to a new DB in a specific point in time from backup files (FULL/DIFF/LOG) created from Ola Hallengren's backup solution (http://ola.hallengren.com). Just fill the "Initialize variables" section and the generator will print all the necessary commands, you can review and execute them manually for extra security. Although it is based on a specific solution with little or no modifications it can be universal for all directory/file naming conventions.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.