Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products

PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

PDF

Table-level restore workflow

When you install the Microsoft application agent, you must install ItemPoint to perform table-level restores. Otherwise, the Table Restore tab does not appear in the Microsoft app agent for Application Direct SSMS plug-in. During the Microsoft application agent installation, you can select the provided check box to install ItemPoint.

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

To perform table-level restores, you must first mount the backup images and specify mount options by using the Microsoft app agent for Application Direct SSMS plug-in. Once the backup is mounted, use ItemPoint for Microsoft SQL Server to complete the table restore.

CAUTION In the scenario where you have large databases where a large amount of data is recently committed to the databases, a table restore may not be appropriate.

Committed data is represented as outstanding transactions when there are SQL Server full and incremental backups on the database. When you perform table-level recovery, ItemPoint must load all the outstanding transactions that are present in a backup.

To load large databases, ItemPoint requires a few hours to read the data because of poor Virtual File System performance. This problem occurs while ItemPoint loads the database and ItemPoint may appear to stop responding while reading the backup. If you observe this problem, an alternative to using SQL table-level recovery is to restore the backup as flat files to a server where you have enough space, and then use ItemPoint to restore the files on the local disk.


  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\