Thank this author by sharing:
By Paul Brewer,
Run on a live production system to construct a recovery script from most recent full backup then all subsequent log file backups. Can override backup folder and data/log files WITH MOVE if restoring to a test server with different folder structure. Uses checksum where possible to verify backups. Ignores Symatech or other non SQL backups (VDI Devices) taken between full/transaction log backups. Lists backup files required for the recovery. The entire script, with the exception of the variable declarations and assignments, is actually a single SQL statement.
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.