Protection for stand-alone SQL Server and SQL Server clustered environments, including Always On availability groups and failover cluster instances
Ability to restore a single SQL database or multiple databases to the original or an alternate location and restore Always On availability Groups
Option to set the parallelism for each backup type as a value 1 through 32 in the full, differential, and log fields
Option to modify the stripe level of a backup at the individual database level
Improved performance and scaling for virtual machine SQL protection policies
Centralized restore support for SQL application aware SQL backups and SQL Application Direct backups
Install MSAPPAGENT agent manually for Windows VM from Data Manager UI
DD compressed restore option for SQL Application Direct backups
SQL Application Direct and VM Direct (application aware) support enables performing table-level restores of encrypted databases. ItemPoint 8.6.1 as integrated with the Microsoft application agent now supports the Microsoft SQL Server Transparent Data Encryption (TDE). However, only the AES_128, AES_192, and AES_256 encryption algorithms are supported.
Dynamic protection and AAG selection options during SQL policy creation in Data Manager UI
Option to exclude simple recovery model database and system database in protection policy
Notification for the assets that are skipped from backup when the assets are offline or in a restoring, recovery pending, or suspect state
Option to configure Windows firewall during the application agent installation (open port 7000 by adding firewall rule during agent installation)
Dynamic protection rule to ensure that the protection policy dynamically protects all the selected assets within the selected host or instance container
Exclude unprotectable database - An advanced option in the Data Manager UI Add Policy wizard to skip the SQL databases that cannot be backed up
Option to set up the sysadmin privilege for a database OS account for a host with application agent release 19.11 or later installed
Improved Microsoft SQL Server backup promotion logic when transaction log backup chains span across full backups - When Microsoft SQL Server transaction log backup chains span across full backups, the transaction log backups and full backups can run concurrently. The transaction log backups are not promoted to full backups.
Starting with version 19.12, PowerProtect Data Manager supports SQL protection on virtual machines with UAC enabled
Table-level recovery of Microsoft SQL Server backups with ItemPoint on Windows Server 2022 using Microsoft application agent version 19.12.
Microsoft SQL Server 2022 support – Starting with version 19.13, PowerProtect Data Manager supports both centralized and self-service Application Direct operations to protect Microsoft SQL Server 2022 databases. PowerProtect Data Manager supports the backups and restores of Microsoft SQL Server 2022 databases through the Microsoft application agent, including table-level restores that use ItemPoint.
Streamlined restore of Always On Availability (AAG) groups in PowerProtect Data Manager UI - 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.
Enhanced restore wizard - PowerProtect Data Manager UI screens are enhanced for the Microsoft SQL Server restore workflows, to improve restore wizard usability. The PowerProtect Data Manager UI includes new options for restore to an original or alternate database. It also provides both hierarchical and list views for the restore to an alternate database, where the hierarchical view displays the databases for each instance on the available Microsoft SQL Server hosts.
