PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

Restore a database with the Microsoft app agent for Application Direct plug-in

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

The Microsoft application agent caches SQL Server restore settings. The Microsoft application agent automatically loads the information from the last recovery operation and populates restore settings. Caching saves time by eliminating the need to reselect the settings each time you run a restore operation. To clear the cached settings, click Clear Cache.

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

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