Microsoft SQL Server Restore
Last updated
Last updated
This restore mode allows the restoration of Microsoft SQL Server databases from backups created with DPX. The restore process is designed to be flexible, allowing for the recovery of selected databases to their original location or a new one. With DPX, you can also perform point-in-time restores, leveraging SQL Server's transaction logs to recover databases to a specific moment before an incident occurred.
In the main web interface view, go to Job Manager in the sidebar. Then select the New Restore Job button.
Select Application Restore and Click Next.
The Object to Restore view shows all Application nodes that you backed up. The available objects to restore can be sorted by Name, Type, associated Job Name, or the backup Date/Time. Find the Node that contains the SQL Server you want to restore and click Next.
Tip. Restoring a SQL object will include all local volumes referenced by the SQL object, potentially increasing the restore size.
Choose the appropriate recovery point from the available backups of the selected node.
In the File Browsing step, choose the specific databases you wish to restore. DPX allows for granular selection, enabling you to restore individual databases. Select all databases you want to restore and click Next.
In the Options step, specify the Job Name. The name may be up to 64 characters long and may only contain letters, digits and -
_
characters.
Specify job options. You can use the following options:
When this option is enabled, DPX will overwrite an existing database without performing the usual SQL Server pre-restore tests. This can be useful when you are certain that the restore should proceed, but it bypasses SQL Server's built-in safety checks, so use it with caution1.
This option allows you to restore the database to a different location than the original. It's essential when the original location is not available or when you want to restore the database for testing purposes.
If you're restoring the database to a new location and want to specify a different location for the transaction logs, use this option. This is particularly useful for separating data files from log files1.
This option enables you to restore the database to a specific point in time, using the transaction logs. Ensure that the necessary transaction log backups are available for the point in time you wish to restore to.
See also. To learn more about other available options, see Advanced Job Options.
Click Next. Review the summary of your job and click Save. You will see the Run Job prompt.
Click Yes to run the job immediately or No if you want to run it later from the Job Manager.
Toggle on
The restore job defined in this process will be deleted upon successful completion. If the job fails, it will not be deleted.
Toggle off
The restore job will be saved and will be accessible later in Job Manager.
Toggle on
The notification is sent as specified below the toggle (additional fields will appear – see below).
Toggle off
The notification is sent to the default e-mail address configured in the Administrator E-mail Settings section.