PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

At the end of an update of the Microsoft application agent with the installer, the wizard displays a message about running the AgentBackupDiscovery.exe tool to discover existing backups and manage them in PowerProtect Data Manager software.

To discover the existing backups by using the backup discovery tool, perform the following steps.

1. In the Microsoft application agent installation directory, C:\Program Files\DPSAPPS\MSAPPAGENT\bin, run AgentBackupDiscovery.exe as the administrator.

   The Discovery of existing backups dialog box appears.

   NOTE If the program does not start but displays the following message, an ongoing backup discovery process is running, as invoked by the PowerProtect Data Manager:

   Backup discovery is in progress. Please wait for it to complete.

   When the discovery process is complete, you can run the backup discovery tool.

2. In the DD system list in the dialog box, select the appropriate DD IP address or hostname, storage unit, and username for the existing backups that you want the PowerProtect Data Manager software to discover.

   NOTE Select only one storage unit at a time. After discovery is complete for the storage unit, you can run the backup discovery tool again to discover the backups of another storage unit.

3. In the Client hostname field, you can change the client hostname from the default local hostname as needed.

   To enable the backup discovery for an AAG or FCI, you must specify the appropriate client hostname:

   • If the host is part of an AAG, specify the Windows cluster name.
   • If the host is part of a SQL virtual server or FCI, specify the virtual server name.
4. In the Backup discovery time period field, select the number of months for the time period, as the time in the past when the backups were performed. You can select 1 month, 2 months, or 3 months for the time period.
5. In the Application field, select SQL as the application.

6. After you have specified the required field values, click Generate.

   When the PowerProtect Data Manager software completes the generation of the backup metadata or breadcrumbs, the following message appears in the dialog box. Depending on the number of old backups, the generation of breadcrumbs can take some time:

   Breadcrumbs generated successfully.

The retention time for the discovered backup is the same as the expiration time set when the backup was taken.