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:

• Microsoft application agent SSMS plug-in (Microsoft application agent for Application Direct)
• Microsoft application agent for Application Direct commands
• T-SQL scripts

For table-level restore (through ItemPoint)

• Application agent will mount the image backup
• Restore the required transaction logs
• Replay logs to the selected point-in-time

Restore workflow

1. Restore databases using the SSMS plug-in.

2. Browse SQL backups using the application agent catalog stored on Data Manager.
3. DBA selects what to restore and recover.

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.

4. The application agent recovers and opens the database unless the administrator selected a different option.

Database or transaction logs restore as a flat file

• Does not restore data to the active SQL instance
• Files are restored as a flat file without impacting any active SQL server
• DBA will restore and recover data, using these flat files and SQL Server commands