V11 SP8
Loading...

Restoring Individual Tables from a SQL Database

You can perform a granular recovery operation to restore one or more tables from SQL database backups.

Performing a granular recovery on the backed up data depends on how you performed the backup job. If data was backed up using one of the following backup methods, you can perform granular restore without restoring the entire database first.

Limitations for Restoring Individual Tables

  • You cannot restore tables to the source database. Instead, restore the tables to an instance on the destination client.
  • All tables are restored to the dbo schema. You cannot restore a table to a custom schema.

Before You Begin

  1. To perform a granular restore operation, you must have a MediaAgent installed on the destination client.
  2. Install Java Runtime Environment (JRE) on the destination client.
  3. Verify that the path where you installed Java is defined in the Windows default PATH environment variable.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SQL Server.
  2. Right-click the SQL database instance that contains the subclient from which you want to restore individual tables, and then click All Tasks > Browse and Restore.

    The Browse and Restore Options dialog box appears.

  3. On the Advanced Options tab, select the SQL Granular Browse check box, and then click View Content.
  4. On the Client tab, expand the SQL database instance.
  5. From the SQL Databases node, on the right side of the window, select the database that contains the tables that you want to restore, and then click Restore Granular.

    The Attach SQL Database dialog box appears.

  6. To attach the database to an instance on the SQL server, complete the following steps:
    1. In the New Database Name box, type a name for the database.
    2. In the SQL Proxy Client box, select the proxy client where you want to attach the database.
    3. In the Destination Server box, select the proxy instance where you want to attach the database.
    4. Type the SQL administrator account login credentials for the database instance that contains the tables that you are restoring.
    5. Click OK.
  7. From the schema list, select the tables that you want to restore, and then click Recover All Selected.

    The SQL Restore Options dialog box appears.

  8. To finalize the selection for restore operation, complete the following steps :
    1. In the Destination client box, select the client server to which you want to restore the tables.
    2. In the Instance Name box, select the instance to which you want to restore the tables.
    3. In the Database Name box, select the database to which you want to restore the tables.
    4. Type the SQL administrator account login credentials for the database instance to which you want to restore the tables.
    5. Click OK.