PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

Discover a SQL application host

After you register an application host with PowerProtect Data Manager, the host appears in the Asset Sources window. Then you can select the host, perform discovery, and modify the application host credentials. For application hosts, discovery is required if you want to schedule a backup. Assets must also be discovered for the centralized copy management of self-service backups.

1. Select Infrastructure > Asset Sources.
   The Asset Sources window appears.
2. Select the App/File System Host tab.
3. If you are adding a SQL database, select the host entry and click Edit Credentials.

   The Edit Credentials dialog appears.

   NOTE The supported syntax for credentials is <user>@<host> or <user>@<domain>. The syntax <host>\<user> or <domain>\<user> is not supported.
4. If you are adding credentials for a SQL database, ensure that you specify the OS credentials for the SQL host. Ensure that these credentials have the rights to perform the Microsoft SQL Server backup and restore operations.
5. Click Save.
6. On the App/File System Host tab, select the application host and click Discover to perform discovery.
   The Discover dialog appears with an option to set the discovery schedule.
7. From the Discovery Schedule list, select the time of day to initiate the discovery, or select Manual to disable scheduled discovery. You can also select the Discover Now check box to perform the discovery upon completion of this procedure.
   NOTE On the App/File System Host tab, you can click Discover at any time if any additions or other changes to your Asset Sources have taken place outside of the PowerProtect Data Manager environment. Asset discovery is also initiated by default after registration of the host to PowerProtect Data Manager and at hourly intervals. Discovery time is based on networking bandwidth. Each time you initiate a discovery process, the resources that are discovered and those that are handling the discovery impact the system performance.
8. Click Save.