Restoring Granular SharePoint Data from an Application-Aware Backup

For Microsoft SharePoint, you can perform mining to recover granular data from an application-aware backup.

Restore SharePoint data from the SQL Server application client associated with the virtual machine that is running SQL Server to support SharePoint.

Before You Begin

• Review the requirements for restores from application-aware backups in Performing a Restore from an Application-Aware Backup.

• For more information about options for SharePoint restores, see Offline Mining for SharePoint Server Agent.

• To stage extents for live browse and restore operations from application-aware backups, the block-level browse feature uses a Least Recently Used (LRU)-based pseudomount cache in the job results directory. The pseudomount cache is pruned periodically to free up extents. The pseudomount cache requires up to 20 GB of free space for restore jobs of any size. For more information about block-level browse requirements, see Live Browse, Block-Level Browse, and Metadata Collection.

• The SQL Server client that you select to perform the snapshot mount for the restore operation must be able to communicate with the hypervisor (virtualization client or host).

  In addition, the client machine must have the following software installed:

  • Microsoft SQL Server

  • SQL Server Agent

  • Virtual Server Agent

  • MediaAgent

Procedure

1. From the CommCell Browser, expand the SQL Server client that contains the application backup data.

2. Under SQL Server, right-click the instance and then click All Tasks > Browse and Restore.

   The Browse and Restore Options dialog box appears.

3. On the Advanced Options tab, select SQL Granular Browse.

4. Click View Content.

   The Client tab appears.

5. Click Sharepoint Databases.

   The right pane displays SharePoint databases.

6. Select the database that contains the information to be restored, and then click Restore Granular.

   The Attach SharePoint Database dialog box appears.

7. In the New Database Name box, enter a unique name for the database that will be attached for the granular restore.

8. To specify how long to keep the recovery point, select For snap backups, dismount the image after n days, and then enter the number of days until the recovery point expires.

   Tip

   You can change the expiration date from the Recovery Points dialog box after the recovery point is created and in a Ready state.

9. From the SQL Client list, select the MediaAgent that performs the snapshot mount.

10. From the Destination Server list, select the SQL Server instance where the database is attached.

11. Click OK.

    A message displays the job ID number.

12. Click List Recovery Points.

    The Recovery Points dialog box appears.

13. In the Browse column for the database, click Browse.

    The Browse Database dialog box appears.

14. From the SharePoint Client list, select the SharePoint client to which the database should be attached.

15. Click OK.

    The Client tab displays the URL for the SharePoint client where the SharePoint database is attached.

16. Expand the tree, select the data to be recovered, and click Recover All Selected.

    The Restore Options for All Selected Items dialog box appears.

17. Select Restore All Versions.

18. Under Restore Destination, click Browse to specify the destination path for the restored data.

19. Select appropriate values for Type of Restore and When Document/Site Collection exists.

20. Click OK.