sp_RestoreScript 1.7 has been released. For information and documentation please visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/
Changes in 1.7
New Parameters
@IncludeCopyOnly –
1 – Copy only backups are included
0 – Copy only backups are excluded
@SingleUser – Put the database into single user mode before restoring
@StopAtMark – Append stopatmark clause to any log restores
@StopBeforeMark – Append stopbeforemark clause to any log restores
New Functionality and Fixes
Functionality – Any database names that make up the file name are now changed to match the name that database is being restored as when WITH MOVE is used.
Functionality – Added support for more backup location types, now supports, disk, tape, logical devices and Azure blob storage
Functionality – Support for STOPATMARK and STOPBEFOREMARK
Functionality – Ability to ignore copy only backups
Functionality – Ability to put a database into single user with rollback immediate before restoring
Fix – prevent selection of log backups that are too early
Fix – automatically appends to any file path where it has been omitted