To configure SQL 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.
Steps
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.
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.
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.
From the
SQL Server host list, select the 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.
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 SQL Server instances.
From the
SQL Server Instance list, select the SQL Server instance that contains the databases that you want to restore.
The databases located on the SQL Server instance appear in the database table below the
SQL Server Instance field.
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.
In the save sets table, select the save set that contains the tables that you want to restore.
Next steps
Specify the
PowerProtect Data Manager server details and additional restore options on the
Options page.
Data is not available for the Topic
Please provide ratings (1-5 stars).
Please provide ratings (1-5 stars).
Please provide ratings (1-5 stars).
Please select whether the article was helpful or not.
Comments cannot contain these special characters: <>()\