PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Configure optional table restore settings

When you configure Microsoft SQL Server backups with the Microsoft app agent for Application Direct SSMS plug-in, you can specify optional backup settings on the Table Restore > Options page.

1. From the left panel, click Options.

   The Options page appears as shown in the following figure.

   

   All settings on the Options page are optional.

2. In the Mount Folder field, specify the location to mount the backup images.
   NOTE:The location (folder or drive) to mount the backup images must be empty. Otherwise, the mount operation fails. To mount the backup as a drive, specify an unused drive letter. The restore operation, after completion, deletes the mount location.
3. In the Mount Expire list, specify the number of hours, after which the mounted backup image must be dismounted. The default value is 8. The valid range is between 1 and 24 hours.
4. To select the level of information recorded in the logs which can be used in troubleshooting recovery issues, select Select a debug level.

   Levels range 0-9, with 0 representing no information and 9 representing the most amount of information. The default value is 0 (zero).

5. To change the restore parallelism setting, type or select a value in the Parallelism field.

   Parallelism controls the number of recovery sessions the NWFS process uses while mounting a backup. The default and maximum value is 31.

6. To mount the backup and proceed with the table restore, click Run.