Create MS SQL Server Restore Job

To restore databases from database backup restore points, please go to Physical Backup > Database Backup > Restore page. There are 4 steps to restore databases from the database backup restore points.

Step 1: Restore Point

In the Restore Point dropdown list, select a backup node which stores the desired restore points. Select a target database restore point under your database which you want to restore. You can quickly find the target restore point by searching the job name, database name or the date of the restore point. One restore job can only select one restore point.

Step 2: Restore Destination

After selecting the desired restore point, please select the target database instance on which you wish to restore. The target instance can be different but the version of your destination should keep consistent with backups.

Step 3: Restore Strategy

There are 2 options for database restore, Override Original Database and Create New Database. If you want to use the Override Original Database restore, please pay attention to this mode, it will directly override the database. It is recommended to use the Create New Database restore to first restore the data to a new path to verify the data then perform override original database restore.

Select Create New Database need to edit database name, database file path, and log file path. The path must be correct and have enough free disk space, the path will be automatically created during the restore process.

Transmission Strategy： If you enable the Encrypted Transfer, the data transmission channel will be SSL encrypted.

Throttling Policy: This feature can be used to limit the database restore speed.

Step 4: Review & Confirm

After completing the settings mentioned above, you are able to review and confirm the settings in one screen.

Once the job has been created, you’ll be redirected to the Monitor Center > Jobs page.

As the database restore job is by default to be executed right after the creation of the job, so it will run automatically when you see it in the current job list, it should be in running status already, and once completed, the job will be automatically deleted from the current job list.

After this, you can browse the restored job from History Jobs. Your restored data will be found in the path you configured while creating the restore job.