PowerProtect: How to Perform a SQL Table Restore

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

Questo articolo si applica a Questo articolo non si applica a Questo articolo non è legato a un prodotto specifico. Non tutte le versioni del prodotto sono identificate in questo articolo.
Scopri le altre risorse

Istruzioni

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.

Informazioni aggiuntive

Refer to this video:


You can also view this video on YouTube .

Prodotti interessati

PowerProtect Software
Proprietà dell'articolo
Numero articolo: 000218439
Tipo di articolo: How To
Ultima modifica: 04 gen 2024
Versione:  3
Trova risposta alle tue domande dagli altri utenti Dell
Support Services
Verifica che il dispositivo sia coperto dai Servizi di supporto.