Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.

PowerProtect Data Manager 19.10 Microsoft SQL Server User Guide

Introducing the Microsoft application agent

The Microsoft application agent enables an application administrator to protect and recover the Microsoft SQL Server application data on the application host. PowerProtect Data Manager integrates with the Microsoft application agent to check and monitor back up compliance against protection policies. PowerProtect Data Manager also enables central scheduling for backups.

You can install the Microsoft application agent on a Windows Microsoft SQL Server host by using the install wizard. Install and configure the application agent provides instructions.

NOTE

PowerProtect Data Manager supports the coexistence of the Microsoft application agent and the File System agent on Windows.

In the PowerProtect Data Manager UI, when you select Infrastructure > Assets > SQL Databases and click View Copies, the size of a Microsoft SQL Server database that is backed up through application-aware protection is displayed as 0 bytes. The correct size is displayed at the Microsoft SQL Server database asset level. For a transaction log backup, the correct size is displayed at the Protection Copy Set (PCS) level.

To enable the discovery and scheduling of backups with PowerProtect Data Manager, you must approve the client in the PowerProtect Data Manager UI. Manage the Microsoft application agent provides more information.

The Microsoft application agent supports two protection technologies, Application Direct backup and VM Direct backup. A Microsoft SQL Server host may only be registered to PowerProtect Data Manager with one protection technology. Once registered, it is not possible to change the protection policy for that host.

Software compatibility information for the PowerProtect Data Manager software and application agents is provided in the E-Lab Navigator.


Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  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: <>()\