SQL databases that are backed up with an application aware VM protection policy can be restored using the Microsoft application agent.
Full and transaction log backups created by a PowerProtect virtual machine application-aware protection policy can be restored using Microsoft application agent tools. The backups are restored to a SQL Server hosted on a VMware virtual machine.
When a SQL Server virtual machine asset is added to a Data Manager virtual machine application aware protection policy, the Microsoft application agent and ItemPoint are silently installed on the protected SQL Server.
The Microsoft application agent automatically stores the DD series appliance host and login information from the protection settings that are configured in the Data Manager protection policy. This automatic configuration occurs when the SQL Server virtual machine asset is added to the Data Manager protection policy.
Restore operations can be performed using the Microsoft app agent for VM Direct SQL Server Management Studio (SSMS) plug-in or the command prompt. T-SQL scripts are not supported with VM Direct.
The Microsoft application agent can perform a database restore, table-level restore, or database instant access restore to the source virtual machine or to an alternate virtual machine. To perform restores to an alternate virtual machine, the destination virtual machine must be an asset of Data Manager.
However, instance-level restores can only be performed to the original source instance.
The Microsoft application agent supports both full backups and transaction log backups for a Microsoft Always On availability group (AAG). The AAG databases are indexed against the AAG cluster name. Full backups index the AAG database for all the AAG cluster nodes for one cycle of backup. Transaction log backups occur only on the preferred node.