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

PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

PDF

Perform backups with the Microsoft app agent for Application Direct SSMS plug-in

The Microsoft application agent supports a user interface to perform backup operations through a SQL Server Management Studio (SSMS) plug-in.

If the DD device is connected only on the backup LAN, and the SQL host is multi-homed and has an interface on the backup LAN, the backups to the DD device proceed over the backup LAN by default.

If both the DD device and the SQL host are multi-homed, and are connected to the backup LAN, ensure that the DD server name that you specify in the Microsoft app agent for Application Direct SSMS plug-in is the same as the backup LAN IP address. The backups to the DD device proceed over the backup LAN.

To back up SQL Server to a DD server over Fibre Channel (FC), you must first configure FC on the DD server.

The Script view is available in each page of the Backup tab, which generates a command prompt equivalent script. You can use the script to create a .bat file to perform scheduled backups, automation, and other tasks. The following script options are available:

  • CLI Scripts: To generate the CLI script, which you can use to run a backup from the CLI.
  • T-SQL Scripts: To generate a backup script in the T-SQL format.

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