PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

PDF

Restore table-level data using ItemPoint

Steps

  1. Launch the command prompt.
  2. Run the following command: 
    C:\Program Files (x86)\DPSAPPS\MSAPPAGENT\ItemPoint\Sql\EMCIPSQL.exe
    The ItemPoint for Microsoft SQL Server appears.
  3. Launch the Data Wizard.
    The Data Wizard appears to the Select Source page.
  4. 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
  5. 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
  6. Click Finish.
    The Data Wizard closes and ItemPoint loads the tables contained in the source backup files.
  7. 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.

Next steps

Dismount the backups using the msagentadmin.exe 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: <>()\