Application-Aware Backups for Microsoft SharePoint
For Microsoft SharePoint, you can perform application-aware backups from a VSA subclient, then recover granular data by performing mining from a SQL Server database client that is associated with the SharePoint application.
During the first application-aware backup, application plug-ins for SQL Server are installed for virtual machines that run SQL Server to support SharePoint.
Note: The targets for application-aware backups are the SQL Server databases that support SharePoint operations, not the web servers that serve SharePoint data to users.
After a SharePoint plug-in is installed as part of an application-aware backup, set SharePoint Timer service account information in the SharePoint server properties.
Before You Begin
- Review the general requirements for application-aware backups. These requirements apply for all supported hypervisors and applications.
- In a firewalled environment with restricted network settings or where WMI ports are not open, see Remote Installation Requirements for Application-Aware Backups to enable remote installations during application-aware backups.
- Configure credentials to be used for application-aware backups.
- Configure one or more subclients for application-aware backups.
- Review general requirements for application-aware backups and restores.
- SharePoint requirements: For Windows VMs running SQL Server to support Microsoft SharePoint, ensure that the following requirements are met:
- Microsoft SharePoint 2010 or 2013.
- SQL Server 2008 R2 or 2012.
- Configure a subclient that points to a virtual machine running a SQL Server configuration database that supports SharePoint operations.
Note: Application-aware backups set up a maximum of two SharePoint web servers that provide front ends for SharePoint operations. Any additional SharePoint web servers that point to the same configuration database are ignored.
- Restore requirements:
- 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.
- 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.
To perform backups and restores for SQL Server databases that support SharePoint operations, SQL sysadmin rights are required.
For application-aware backups of Microsoft SharePoint, the subclient content must be a virtual machine running a SQL Server configuration database that supports SharePoint operations.
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.
- From the CommCell Browser, expand the SQL Server client that contains the application backup data.
- Under SQL Server, right-click the instance and then click All Tasks > Browse and Restore.
The Browse and Restore Options dialog box appears.
- On the Advanced Options tab, select SQL Granular Browse.
- Click View Content.
The Client tab appears.
- Click Sharepoint Databases.
The right pane displays SharePoint databases.
- Select the database that contains the information to be restored, and then click Restore Granular.
The Attach SharePoint Database dialog box appears.
- In the New Database Name box, enter a unique name for the database that will be attached for the granular restore.
- From the SharePoint Client list, select the SharePoint client to which the database should be attached.
- Click OK.
The Client tab displays the URL for the SharePoint client where the SharePoint database is attached.
- Expand the tree, select the data to be recovered, and click Recover All Selected.
The Restore Options for All Selected Items dialog box appears.
- Select Restore All Versions.
- Under Restore Destination, click Browse to specify the destination path for the restored data.
- Select appropriate values for Type of Restore and When Document/Site Collection exists.
- Click OK.