PowerProtect: How to perform SQL Self-Service restore

 

PowerProtect DD System: Select the DD where the backup is stored.
SQL Server Host: Select the source SQL server where the database to be restore was protected.
SQL Server Instance: Select the SQL server instance that contains the database to be restored.

Select the Database to be restore and backup date.

Restore to SQL Server: Define SQL target SQL server where the database is restored and the Database name where the data must be restored.
 

Filegroup Options: Define which file groups must be restored.
Relocation options: Define the relocation path where the database data and logs are to be restored.

Overwrite existing database: The database is overwritten only if the database name is unchanged.
Recovery State: 

● RESTORE WITH RECOVERY: To leave the database in the ready-to-use state by rolling back uncommitted transactions, and disable the ability to restore the most recent or additional transaction logs.
● RESTORE WITH NORECOVERY: Leave the database in the non-operational state by not rolling back uncommitted transactions. Enables restoring the most recent or additional transaction logs.
● RESTORE WITH STANDBY: Enable the ability to undo committed transactions, save the undo actions in a standby file that enables you to reverse the restore effects, and put the database in the read-only mode. If you select this option, specify the Standby file field. To do this, select the button to the right of the field, browse for, and then select the file.

Verify Only: Perform a verify only operation.
PowerProtect DD System Boost compressed restore: To compress the restore contents and transport them from the DD Replicator to the application host.
Select Debug level: Set the debug level for troubleshooting purposes.
Delete debug logs after: Define the number of days to maintain the debug level before been deleted.
Specify a start time for restore: Restore all the backups that were performed during or after a specified start time, and up to the time of the backup that is being restored.
Number of entries to retrieve: Edit the number of save sets or versions that the Microsoft application agent cache retrieves.
Take tail-log backup before restore: To perform a tail-log backup of the data before performing a restore operation.
Close existing connections to destination database: To ensure exclusive access to the database during the restore operation if multiple connections exist.