This is for all v.1 versions of Minion Backup. It creates restore statements for multiple DBs.
To use this just populate the #table with whatever DB names you want to restore and it looks in the Minion.BackupFiles table and build the stmts based off of the latest files in there. It takes the last full backup, the last diff and the last log. Currently though, in this version of the restore SP you have to script each backup type out separately.
This isn't meant to be a complete restore solution in its current state. It's meant to show you how to use the restore SP to build multiple restore stmts. To see an explanation of the input params of the restore SP itself, see the documentation.
No installation. Just run the code and alter it as you need.
Please sign-in with the following login form.