Schedule Restore


#1

We use the backup software to back different environments. I would like to be able schedule a restore just like a backup.

This would allow me to move production data to test environment automatically.

If this is already available, I can’t find it.


#2

Hi Chris,

Sorry, but there is no such option in SQLBackupAndFTP, we can recommend you to create a restore job and run it via Command Prompt using Windows Scheduler. Here are more details on how to run a backup job via Command Prompt https://sqlbackupandftp.com/blog/run-sqlbackupandftp-v11-command-line To run a restore job just use the following command:

SqlBak.Job.Cli.exe -runJob -jobName "Job"

Also, you can try our another product - SqlBak https://sqlbak.com/ it allows you to add a restore process to your backup job, just set an appropriate settings at the “Restore on another computer” section.