PowerProtect: How to Perform a SQL Table Restore

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

Ten artykuł dotyczy Ten artykuł nie dotyczy Ten artykuł nie jest powiązany z żadnym konkretnym produktem. Nie wszystkie wersje produktu zostały zidentyfikowane w tym artykule.
Sprawdź inne zasoby

Instrukcje

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.

Dodatkowe informacje

Refer to this video:


You can also view this video on YouTube .

Produkty, których dotyczy problem

PowerProtect Software
Właściwości artykułu
Numer artykułu: 000218439
Typ artykułu: How To
Ostatnia modyfikacja: 04 sty 2024
Wersja:  3
Znajdź odpowiedzi na swoje pytania u innych użytkowników produktów Dell
Usługi pomocy technicznej
Sprawdź, czy Twoje urządzenie jest objęte usługą pomocy technicznej.