PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Restore table-level data using ItemPoint

Launch the command prompt.
Run the following command:
```
C:\Program Files (x86)\DPSAPPS\MSAPPAGENT\ItemPoint\Sql\EMCIPSQL.exe
```
The ItemPoint for Microsoft SQL Server appears.
Launch the Data Wizard.
The Data Wizard appears to the Select Source page.
On the Select Source page, select the source backup files from the mounted volume that contains the Microsoft SQL Server backup data as shown in the following figure, and then click Next.
Figure 1. ItemPoint Data Wizard: select the source files
On the Select Target Server page, specify the details and login credentials for the target Microsoft 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
NOTE:When you want to connect to a Microsoft SQL Server instance with a non-English name, you can use the workaround that connects using the port number. On the Select Target Server page, you must add a space and the port number after the name in the SQL Server Name field. The following figure shows the required type of field entry.
Figure 3. ItemPoint Data Wizard: non-English instance name
Click Finish.
The Data Wizard closes and ItemPoint loads the tables contained in the source backup files.
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.

Dismount the backups using the msagentadmin.exe command.