Loading...

Recovering SQL Tables from a Recovery Point

Applies to: SQL block-level backups, Application-Aware backups, and IntelliSnap backups. SQL Server must be the 64-bit version installed on a 64-bit Windows operating system.

After you create a recovery point, you can restore the SQL tables to the same instance where the recovery point was created.

When you restore from a recovery point, you save time because the snap mount is complete and the database is already attached. Table restore is not allowed to the database created from the recovery point job.

SQL Server table-level recovery is not supported using cloud snapshot engines.

Restriction:

Unless otherwise noted for a particular feature, block-level browse is not supported from backups to tape libraries or virtual tape libraries. If you want to restore from a recovery point by using a secondary copy on tape libraries or virtual tape libraries, move the copy to disk storage before performing the restore.

Before You Begin

Create a recovery point.

Procedure

  1. From the CommCell Console, expand Client Computers > client > SQL Server.
  2. Right-click the instance, and then click All Tasks > List Recovery Points.

    The Recovery Points dialog box appears.

  3. Select the recovery point that contains the data that you want to restore, and then click Browse.

    The Browse Database dialog box appears.

  4. Select the SQL tables that you want to restore, and then click Recover All Selected.

    The SQL Restore Options dialog box appears.

  5. From the Database Name list, select a database to which you want to restore the selected SQL tables.
  6. Click OK.

Last modified: 12/9/2020 9:12:03 PM