PowerProtect: How to Perform a SQL Table Restore

Summary: This article explains how to perform a SQL table restore using the SMS plug-in.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Instructions

Connect to the SQL server where the data must be restored.
  1. Open SQL management studio as administrator user:
Open SQL management studio as administrator user
Figure 1: Open SQL management studio as administrator user
  1. Open SMS plug-in:
Open SMS plugin
Figure 2: Open SMS plug-in
  1. From the Database Restore Table tab > General section, configure the restore settings:
    1. PowerProtect DD System: Select the DD where the backup is stored.
    2. SQL Server Host: Select the source SQL server where the database to be restore was protected.
    3. SQL Server Instance: Select an SQL server instance that contains the database to be restored.
    4. Database: Select the Database to be restore and backup date.
Configure the restore settings from the database restore table tab
Figure 3: Configure the restore settings from the database restore table tab.
 
  1. Under the Options page, define the following settings:
    1. Mount folder: Path where the backup must be mounted.
    2. Mount Expire: Define the number of hours to keep the mount of the database active. For big DB-s, restores can take time to read all data, so it is advisable to extend the time to the maximum.
    3. Select a debug level: Sets the debug level for troubleshooting purposes
Define the settings in the Options page
Figure 4: Define the settings in the Options page.
  1. Run the table restore operation and monitor the progress under Monitor page:
Monitor table restore operation progress
Figure 5: Monitor table restore operation progress.
  1. In Task Manager, confirm that the Mount service is running:
Confirm that Mount Service is running
Figure 6: Confirm that Mount Service is running.
 
  1. Once the mount operation is completed, Item Point software is started. Configure the data source pointing to the mount path defined in step 4:
Configure the data source pointing to the defined mount path
Figure 7: Configure the data source pointing to the defined mount path. 
  1. Select the database name from which you intend to perform the Table Restore operation:
Select the database name to perform Table Restore operation
Figure 8: Select the database name to perform Table Restore operation.
 
  1. Once the database is loaded, select the corresponding table and drag and drop the required data from the top, source database mounted from the backup. Drag it to the target database which is your current database on the SQL server:
Drag and drop the required data from top source database to target database
Figure 9: Drag and drop the required data from the top source database to the target database.

Additional Information

Refer to this video:


You can also view this video on YouTube .

Affected Products

PowerProtect Software
Article Properties
Article Number: 000218439
Article Type: How To
Last Modified: 04 Jan 2024
Version:  3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.