PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Configure table restore options

When you configure Microsoft SQL Server table-level restores with the Microsoft app agent for VM Direct SSMS plug-in, you can specify additional restore options on the Table Restore > Options page.

1. From the left panel, click Options.

   The Options page appears as shown in the following figure.

   

2. Under Mount, specify the following fields as required:
   • The Mount Folder field specifies the location where backup images are mounted. You cannot edit the value in this field.
   • In the Mount Timeout list, specify the number of hours, after which the mounted backup image must be dismounted. The default value is 4, and the value cannot be more than 24 hours.
   • To prevent ItemPoint from launching after you run the mount operation, select Do not run ItemPoint after mounting the backup images.

     Selecting this option disables the Leave backup images mounted after ItemPoint exits option, and enables you to perform manual table-level restores.

   • To leave the backup images in the mounted state after you close ItemPoint, select Leave backup images mounted after ItemPoint exits.

     This option is enabled only if you have not selected the Do not run ItemPoint after mounting the backup images option.

3. To generate detailed logs, which you can use to troubleshoot the restore issues, select Select a debug level, and then specify a value of 1 through 9. The default value is 0 (zero).
4. To delete debug logs older than a certain number of days, select Delete debug logs after, and then specify the number of days with a number between 1 and 32767 days. The default value is 0 and does not delete any debug logs.
   NOTE:This option only deletes debug logs named in the default format and located in the logs folder at <installation_path>\MSAPPAGENT\logs.
   Regularly deleting debug logs prevents the log folder on the installation drive from becoming too large.
5. To limit the backup history of the databases on the General page to a set number of days, type or select a number in the Days of backup history field. The default value is 7 days.
   If no level full backups are found in the specified time range, you are prompted for confirmation to load the latest full backup.
6. Exclude client name resolution is selected by default, as required to use the client name that is provided as is without converting it to the fully qualified domain name (FQDN).

   Use this option when you restore to a virtual machine in a different domain that does not have name resolution for the source client.

   Unselect the option to resolve the source FQDN during restore.

7. To specify the PowerProtect Data Manager server, perform the following steps:
   1. Beside Appliance Host, click ...
      The PowerProtect Data Manager List & Lockbox Settings window appears.

      When you restore a backup to the original virtual machine, the details for the PowerProtect Data Manager server that protects the Microsoft SQL Server in a protection policy automatically appear.

   2. If you do not see the PowerProtect Data Manager server that you want to use for the restore operation, click Add, and then in the Add PowerProtect Data Manager details dialog box, perform one of the following actions:
      • To add a PowerProtect Data Manager with credential-based authentication, specify the server hostname and the login credentials.

        Contact the PowerProtect Data Manager administrator to retrieve the PowerProtect Data Manager server host and login details.

      • To add a PowerProtect Data Manager with certificate-based authentication, specify only the server hostname. Do not specify the username and password fields.

        To use certificate-based authentication, the PowerProtect Data Manager administrator must approve the target Microsoft application agent.

        When you add a virtual machine to a protection policy, that virtual machine is approved with a certificate that expires after one day. If you are restoring to an alternate virtual machine that is an asset of PowerProtect Data Manager but not a member of a protection policy, the PowerProtect Data Manager administrator must approve the target virtual machine.

        The PowerProtect Data Manager administrator can approve the target Microsoft application agent on the PowerProtect Data ManagerInfrastructure > Application Agents page.

   3. Select the PowerProtect Data Manager server that will mount the backup, and then click OK.
8. To mount the backup and proceed with the table restore, click Run.