PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Supporting existing Microsoft application agent backups with PowerProtect Data Manager

Learn how to support the existing Microsoft application agent backups.

1. Update the Microsoft application agent on the Microsoft SQL Server host.
   Update the Microsoft application agent provides information.
2. Run the backup discovery tool, AgentBackupDiscovery.exe, to enable management of existing Microsoft application agent backups with PowerProtect Data Manager.

   Using the backup discovery tool for PowerProtect Data Manager management of existing backups provides information.

   NOTE:This step enables the discovery of old backup copies that the Microsoft application agent created during self-service backups with stand-alone deployments.
3. Register and approve the Microsoft application agent in PowerProtect Data Manager.

   Manage the Microsoft application agent provides information.

   After a few minutes of approving the Microsoft SQL Server host, older backup copies are discovered. Depending on the number of backups, the discovery and subsequent visibility of the backups in PowerProtect Data Manager can take some time. The retention time of the discovered existing backup copies equals the retention time that was set in the protection policy plus 14 days, rounded off to the next day.

4. Discover and add the credentials for the Microsoft SQL Server application host.
   Discover a Microsoft SQL Server application host provides information.
5. Create a protection policy to protect the Microsoft SQL Server host. For importing assets, only a subset of databases can be imported. It is not mandatory for all the databases on the host to be imported.

   Protection policies for Microsoft SQL Server database protection provides information.

   The first backup after importing must be a full backup:

   • The first centralized backup is automatically promoted to a full backup.
   • The first self-service backup is automatically performed as a full backup.

   NOTE:You cannot perform a backup to a secondary DD system device. You can restore only from a secondary DD system device.
6. Perform a self-service backup of the Microsoft SQL Server databases. Imported assets can be part of either a centralized or self-service protection policy.
   Performing self-service Microsoft SQL Server database backups provides information.