Home > Data Protection > PowerProtect Data Manager Appliance > Dell PowerProtect Data Manager Appliance: Protection for Existing and Modern Workloads > Restoring SQL databases
The Data Manager Appliance supports:
When Microsoft SQL Server data is backed up as part of an Application Direct protection policy in the Data Manager Appliance, you can recover the Microsoft SQL Server Application Direct backups by using the centralized restore functionality in the Data Manager Appliance UI.
You can perform the following types of centralized restores of Microsoft SQL Server Application Direct backups, depending on the type of database assets:
The Microsoft application agent for Application Direct with Microsoft SQL Server supports multiple tools to recover databases. You can recover databases using the Microsoft application agent SQL Server Management Studio plug-in (GUI), Microsoft application agent for Application Direct commands, or T-SQL scripts.
When Microsoft SQL Server data is backed up as part of a virtual machine application-aware protection policy in the Data Manager Appliance, you can restore the Microsoft SQL Server virtual machine backups by using the centralized restore functionality in the Data Manager Appliance UI.
You can perform the following types of centralized restores of Microsoft SQL Server virtual machine backups, depending on the type of database assets:
The centralized restore of an Application Direct or VM Direct backup of a single database from a Microsoft SQL Server Always On availability group (AAG) is streamlined in the Data Manager Appliance UI, starting with Data Manager Appliance version 5.13.0.0. The AAG database restore automatically removes the database from the AAG, restores the database to either a single server instance or all the nodes in the AAG, as specified in the UI, and then adds the database back to the AAG.
You can use the Microsoft application agent to restore the Microsoft SQL Server databases that are backed up with an application-aware VM protection policy.
Microsoft SQL Server table-level recovery to a virtual machine: To recover table-level data, you can use the SSMS plug-in first to mount the backup, and then use ItemPoint for Microsoft SQL Server to browse and restore the tables.
Restore Microsoft SQL Server tables with the VM Direct SSMS plug-in
Restore Microsoft SQL Server tables with the VM Direct recover command
Note: You can only mount and restore tables from the level full backups.
Instant access recovery - Instant access recovery enables you to access a live-mounted Microsoft SQL Server database from protection storage without restoring the virtual machine or Microsoft SQL Server database. Instant access recovery to a Microsoft SQL Server database is useful in many cases, including ad hoc queries, health checks, disaster recovery, and development tests.
For more details about SQL database backup and recovery with the Data Manager Appliance, see PowerProtect Data Manager Appliance Administrator Guide for DM5500.