To create a Restore Job, click on Job – Add Restore Job or click on the plus icon and select Add Restore Job.
To configure a simple restore job, adjust the settings in the opened dialog as follows.
- Choose a location where your backups are stored. This can be done in the Take backups from section. If you choose the File option, you will be able to select a specific file on a local computer (no need to connect to any storage).
When you select a source of backup files, SQLBackupAndFTP scans through the files looking for the following file types:
{DatabaseName}{YYYY}{MM}{DD}{hh}{mm}[log|diff].[sql|bacpac|7z|zip|bak].
- Select the backup that you want to restore in the Select databases to restore section. If you need to restore a differential or transaction log backup, simply choose that backup, and SQLBackupAndFTP will automatically restore all the necessary preceding backups. Note, that you can select multiple databases to be restored in one job. You can select all databases from the destination to be restored by clicking the Add all link or remove all by clicking the Remove all link.
If you need to restore a backup to under a different name, simply click on the gear icon and specify a database name in the Restore database to box in the opened window. If it is a new database, it will be created automatically.
- The next section is Restore to Database Server, where you need to configure the connection to the DBMS where the backups should be restored. Simply click on the gear icon to access and configure the necessary settings.
These are the main settings, and now the job can be executed by clicking the Restore button at the top of the app.
Below are additional settings that can be included in the restore job:
- Schedule configuration for running the restore job
- Notification settings for successful completion or failure of the job
- If the backup is password-protected, specify the password in the corresponding window
- Ability to specify a temporary folder. Note that the temporary folder is used for all created jobs. If it is changed, the change will apply to all jobs.
- The Keep files local option in the Restore options section allows you to retain already downloaded backup files for future job runs. If the option is disabled, downloaded backup files in the temporary folder will be deleted after the restore operation is completed.
