Let’s say you want to restore from a server named Prod1 (which has MB on it) to a server named QA5. To set this up with Minion Backup:
- On Prod1, add a row to Minion.BackupRestoreSettingsPath with ServerName=’QA5’ and DBName = ‘MinionDefault’ (to make it applicable to all databases), and configure other settings as appropriate.
- On Prod1, configure restore tuning settings in Minion.BackupRestoreTuningThresholds.
- Now you can run the procedure ‘Minion.BackupRestoreDB’ to generate the restore statements. Run once for each backup type (e.g., once for Full and once for Log). The SP will automatically generate the statement for the latest backup(s) for that database.
- Run the statements on QA5.
Questions? Write us at MinionWareSales@MidnightDBA.com, or catch us on Twitter.