PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

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.

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

   

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

   

   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.

   

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.