PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Configure general table restore settings

To configure Microsoft SQL Server table-level restores with the Microsoft app agent for VM Direct SSMS plug-in, you must first specify general table restore options on the Table Restore > General page.

1. Open the Microsoft app agent for VM Direct window to the Table Restore > General page.

   The General page appears as shown in the following figure.

   

2. Beside PowerProtect DD System, click ...
   The PowerProtect DD System List & Lockbox Settings window appears and lists the DD server and lockbox that is configured in the PowerProtect Data Manager protection policy. If the protection policy is configured for replication, the secondary DD server and storage unit also appear.
3. In the PowerProtect DD System List & Lockbox Settings window, select the DD server that contains the backup, and then click OK.
   The SQL Server host field is updated with the client backups that are available on the selected DD server.
4. From the SQL Server host list, select the Microsoft SQL Server host that is the source of the backup.

   If you are restoring an AAG database, you must select the Windows cluster name, which enables you to browse the list of AAGs hosted on this cluster.

   If you are restoring a clusterless AAG database, you must select the AAG group name, which enables you to browse the list of AAGs hosted on the clusterless AAG group. In the case of a clusterless AAG, the AAG name plus GUID is displayed.

5. Use the Start browsing from list to select a backup save time, and then click Show Versions.

   The SQL Server Instance field and save sets table are updated with the backups that are within the specified browse time. If no level full backups are found in the specified time range, you are prompted for confirmation to load the latest full backup.

   NOTE:If you selected a cluster name or AAG group name with GUID in the preceding step, then the list of AAGs in the cluster or the list of AAGs in the AAG group named with GUID is displayed instead of the list of Microsoft SQL Server instances.
6. From the SQL Server Instance list, select the Microsoft SQL Server instance that contains the databases that you want to restore.

   The databases located on the Microsoft SQL Server instance appear in the database table below the SQL Server Instance field.

7. From the databases table, select the database that contains the tables that you want to restore.
   The corresponding save sets appear in the save sets table.
8. In the save sets table, select the save set that contains the tables that you want to restore.