The Microsoft application agent provides a user interface (Microsoft application agent for Application Direct) that enables the Microsoft SQL database administrator to perform backup and restore operation of an SQL database through the SSMS plug-in.
For database or table-level restores directly from a SQL host using the SSMS plug-in with Data Manager, the Microsoft application agent supports multiple tools to recover Microsoft SQL databases.
The Microsoft SQL database administrator can use the following tools to configure and perform a SQL database recovery:
For table-level restore (through ItemPoint)
The application agent creates and executes the recovery plan.
The application agent also restores the transaction logs using DD Boost and applies the transaction logs on the restored database files accordingly.