Your Browser is Out of Date

Nytro.ai uses technology that works best in other browsers.
For a full experience use one of the browsers below
PowerProtect Data Manager: Microsoft SQL Database Backup and Recovery
Executive summary Data Manager overview Deployment requirements Security SQL database backup SQL database recovery
Database recovery overview
SQL instant access
Centralized restore of SQL Application Direct backups
Centralized restore of SQL virtual machine backups
Self-service restore of SQL virtual machine backups
Support for existing SQL agent backups with Data Manager Disaster recovery Technical support and resources

Self-service restore of SQL virtual machine backups

Self-service restore of SQL virtual machine backups

  • 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.