Skip to main content
Sign Out

Welcome to Dell

My Account
  • 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
Sign In Create an Account Premier Sign In Dell Financial Services Partner Program Sign In
Contact Us

Your Dell.com Carts

PowerProtect Data Manager 19.17 Microsoft SQL Server User Guide

PDF

Microsoft application agent overview

The Microsoft application agent enables an application administrator to protect and recover the Microsoft SQL Server application data on the application host. The Microsoft application agent also supports self-service backups under a nonadministrative account. PowerProtect Data Manager integrates with the Microsoft application agent to check and monitor backup compliance against protection policies. PowerProtect Data Manager also enables central scheduling for backups.

Use PowerProtect Data Manager with the application agent to perform the following operations:

  • Automate the configuration of the application agent backup policy and protection storage settings.
  • Create a catalog of backups that the application agent creates. Then, monitor that catalog data to determine if retention policies are being adhered to.
  • Manage the life cycle of backups that the application agent creates. Ensure that the backups are marked for garbage collection, based on the rules of the retention policy.

PowerProtect Data Manager does not change the way that the application agent works. DBAs, system administrators, or backup administrators create the backups and perform the restore operations.

The Microsoft application agent also supports self-service backups under a nonadministrative account.

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

NOTE:

PowerProtect Data Manager supports the coexistence of the Microsoft application agent and the File System agent on Windows. When a volume includes any application database and log files:

  • File System agent block-based backups of the volume automatically exclude the database and log files from the file system backup.
  • File System agent file-based backups of the volume do not automatically exclude the database and log files, but you can explicitly exclude those files through the exclusion filters in the policy. It is recommended that you exclude the application database and log files from file system backups if you use the corresponding application agent to back up the files.

In both cases, File System agent backups do not involve any database writer, regardless of whether or not the database and log files are excluded. The backups do not interfere with the database backup chaining.

The PowerProtect Data Manager File System User Guide provides more details.

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 by 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: <>()\