Create MS SQL Server Restore Job
To restore databases from database backup restore points, please go to Data Resilience > Restore > Database page. There are 4 steps to restore databases from the database backup restore points.
Step 1: Restore Point
In the Recovery Data Source dropdown list, select the database type as “SQL Server.” Expand the backup task to choose the backup point you want to restore, then click the “Next” button. When there are many databases, you can use the search function to locate the database you need to restore.
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.
Notice SQL Server databases support batch recovery: A single recovery task can select multiple databases for recovery, with only one backup point allowed per database.
Step 3: Restore Strategy
Restore mode can be configured, supporting both “Override Original Database” and “Create New Database” options. Override Original Database is suitable for restoring data to a production database server, directly overwriting the existing data in the target database.
When using the Override Original Database feature, the target host must contain a database with the same name and path as the backup source database.
Notice This method overwrites data files on the target host during restoration. Exercise caution when using Overwrite Original Database. It is recommended to first verify data using Create New Database Restoration before proceeding with Overwrite Original Database.
Create New Database is suitable for verifying backup data and restoring to a different machine. After selecting new database recovery, you must configure a new database name, database file path, and log file path.
Notice During batch recovery: 1. Overwriting recovery is not permitted for databases with identical names. 2. When recovering a newly created database, duplicate database names are not allowed.
Configure start type: Recovery methods include Start Immediately and Start at Specified Time.
Throttling Policy: This feature can be used to limit the database restore speed. When multiple speed limit policies exist for the same time period, the transmission speed is restricted to the minimum value among all speed limit policies.
Transmission Strategy：If you enable the Encrypted Transfer, the data transmission channel will be SSL encrypted.
The Script configuration is disabled by default. Enabling it allows you to configure scripts to run before and after backups. Before Recovery script: Executes before Recovery, such as disabling database operations. After Recovery script: Executes after Recovery completes, such as re-enabling database operations.
Integrity Check can be configured, with options to either interrupt recovery or continue recovery when integrity verification exceptions occur.
Advanced Strategy including Retry strategy and Overload Protection. When the network fluctuates, can reconnect to the current network by setting the number of Retry Attempts and Retry interval to reduce the factors that cause job failures due to network fluctuations.
Automatic Retry for Operation Exceptions, When enabled, if an operation excepetion occurs during job execution, it will re-execute according to the configured retry strategy This mechanism reduces task failures caused by RPC remote call exceptions.
After enabling Job Retry, if an objects exception occurs during job execution, it will re-execute according to the configured retry staategy. Reduce redundant backups caused by failed backups of some objects when retrying other successful backup objects, improving task efficiency.
Overload Protection, If resource limits are set on a backup node, tasks running on that node will be restricted. Recovery tasks are enabled by default and are not subject to resource limits.
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.
Select Start Immediately type 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.