PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

Configure general table restore settings

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

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

   The General page appears as shown in the following figure.

   

   The Microsoft application agent caches SQL Server restore settings. The Microsoft application agent automatically loads the information from the last recovery operation and populates restore settings. Caching saves time by eliminating the need to reselect the settings each time you run a restore operation. To clear the cached settings, click Clear Cache.

2. Use the PowerProtect DD System field to select the DD server and the storage unit to restore the data. A storage unit contains the backed-up SQL Server hosts.
   NOTE When you want to restore a replicated backup from a secondary DD server, select the relevant server. The DD user on the secondary DD server must be in the same group as the primary DD server.
3. From the SQL Server host list, select the SQL Server host that contains the backup. Select the Windows cluster name in the case of federated backups.

   To perform a redirected restore, select the SQL Server host where you want to restore the backup to.

4. From the SQL Server Instance list, select the SQL Server instance that contains the backup.
5. From the Database list, select the database that you want to restore.
   The corresponding save sets appear in the save sets table that is located below the Browse time field.
6. To select the backup that you want to restore, perform either of the following actions:
   • Select a save set in the save sets table that is located below the Browse time field. Use the backup timestamp to choose the backup.
   • To browse for a backup that is not listed, perform the following steps:
     • From the Browse time list, select a date and time, and then click Show Versions.
     • From the save sets table, select the save set with the timestamp that you want to restore.

       Click < < Older or Newer > > to browse additional save sets.

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