PowerProtect: How to Perform a SQL Table Restore

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

Este artículo se aplica a Este artículo no se aplica a Este artículo no está vinculado a ningún producto específico. No se identifican todas las versiones del producto en este artículo.
Consulte estos recursos

Instrucciones

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.

Información adicional

Refer to this video:


You can also view this video on YouTube .

Productos afectados

PowerProtect Software
Propiedades del artículo
Número del artículo: 000218439
Tipo de artículo: How To
Última modificación: 04 ene 2024
Versión:  3
Encuentre respuestas a sus preguntas de otros usuarios de Dell
Servicios de soporte
Compruebe si el dispositivo está cubierto por los servicios de soporte.