How to Effortless Restore a SQL Backup with Dell PowerProtect Data Manager

Learn the seamless process of restoring self-service SQL backups using Dell PowerProtect Data Manager SQL Agent Software. Follow our detailed step-by-step guide to ensure a smooth recovery and safeguard your critical data.

Hello everyone.

On this video, I will explain how to perform a SQL Self-Service restore using PPDM SQL agent software. First, open Microsoft SQL Management Studio as administrator. Once connected, locate and open SMS plugin. Select Database Restore Tab and under General page, configure your restore settings.

Select the Data Domain system from where the restore will be performed. Select the SQL Source server, where database to be restored was protected and select the SQL Server instance that contains the database to be restored. Select the database to be restored and from available backups, select the version of the backup to be restored. Select to restore to SQL Server or to a different one. Under File and Filegroups page, you can define following settings.

Filegroups Options, define which Filegroups must be restored. Relocation Options, relocate all files to a different folder, if you don't want to restore to original location. Under Options page you can define optional available options for the restore to be performed. Either Overwrite existing database, Recovery state, Verify only, PowerProtect Data Domain System Boost compressed restore, enable Debug, specify a start time for Restore and other options.

On top you will see the script drop down menu, where you can build different scripts for the Restore. CLI scripts will create a command line script using PPDM SQL module syntax and T-SQL script, will create a script that can be run from SQL Server itself. Once you have configured all your settings, run the restore and monitor the progress and activity under the Monitor page.

Thank you for watching this video.