PowerProtect Data Manager Appliance 5.15.0.0 Microsoft SQL Server User Guide

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 Microsoft SQL Server 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 Microsoft SQL Server 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 Microsoft 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.