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

Restore table-level data using ItemPoint

After the backup images are mounted using the Microsoft application agent SSMS plug-in, complete the table-level restore using ItemPoint for Microsoft SQL Server.

Prerequisites

Configure and run the table level restore operation with the Table Restore tab in the Microsoft application agent SSMS plug-in.

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.

About this task

Once the table level restore is configured and run through the Microsoft application agent SSMS plug-in, ItemPoint launches.

If you select Do not run ItemPoint after mounting the backup images when you configure the table level restore, you must manually launch ItemPoint, and then launch the Data Wizard.

Steps

  1. On the Select Source page, select the source backup files from the mounted volume that contains the SQL backup data as shown in the following figure, and then click Next.
    Figure 1. ItemPoint Data Wizard: select the source files
    ItemPoint Data Wizard: select the source files
  2. On the Select Target Server page, specify the details and login credentials for the target SQL Server and database.

    The following figure shows the ItemPoint Data Wizard Select Target Server page:

    Figure 2. ItemPoint Data Wizard: select the target server
    ItemPoint Data Wizard: select the target server
  3. Click Finish.
    The Data Wizard closes and ItemPoint loads the tables contained in the source backup files.
  4. Use ItemPoint to browse and restore the individual tables.
    NOTE The PowerProtect ItemPoint for Microsoft SQL Server User Guide provides more information on using ItemPoint for Microsoft SQL Server to restore table-level data.
  5. To dismount the mounted backup images, exit ItemPoint for Microsoft SQL Server.
    NOTE If you select Leave backup images mounted after ItemPoint exits or Do not run ItemPoint after mounting the backup images when you configure the mount operation, the backup image remains mounted for 4 hours. To dismount the backup manually, use the msagentadmin command.

  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: <>()\