To perform Microsoft SharePoint item recovery, Veeam Explorer requires a Microsoft SQL Server that will be used as a staging system. On this staging system, Veeam Explorer creates temporary Microsoft SharePoint content databases by attaching restored content database files. Below are the requirements for staging server:
- The staging Microsoft SQL Server can run on the machine where Veeam Explorer for Microsoft SharePoint is installed, or on another machine.
- The staging system must have the same or a later version of Microsoft SQL Server as the server that hosts restored Microsoft SharePoint content databases. For example, if the Microsoft SharePoint server uses Microsoft SQL Server 2008, then the staging system can run Microsoft SQL Server 2008 or later.
- SQL Server included in Microsoft SQL Server Failover Cluster cannot be used as a staging system.
- Nodes participating in AlwaysOn Availability Groups are supported. However, using Availability Group Listeners as staging servers is not recommended.
You can use Veeam Explorer for Microsoft SharePoint options to configure staging Microsoft SQL Server settings.
As a staging system, you can use the Microsoft SQL Server 2012 Express that is shipped with the Veeam Backup & Replication setup (this will be the default staging server). However, consider that content databases that exceed 10 GB cannot be attached to this SQL Server due to Express edition limitations (http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx).
To be able to work with remote BLOB stores (RBS) of the SharePoint content database, make sure that you have your remote BLOB store virtualized on the corresponding platform (VMware or Hyper-V). Also, make sure that it is either included in the SharePoint backup created by Veeam Backup & Replication (for automated discovery), or stored on the local machine running Veeam Explorer and staging SQL server (for manual discovery).
The 3rd-party RBS providers are not supported in the current version.
Make sure the staging SQL Server configuration meets the following requirements:
- FILESTREAM should be enabled on the database server, and filestream settings should be enabled at database level, as described in Microsoft documentation:
- For SQL Server 2017 for Windows: https://msdn.microsoft.com/en-us/library/cc645923(v=sql.130).aspx
- For SQL Server 2016: https://msdn.microsoft.com/en-us/library/cc645923(v=sql.130).aspx
- For SQL Server 2014: https://msdn.microsoft.com/en-us/library/cc645923(v=sql.120).aspx
- For SQL Server 2012: http://msdn.microsoft.com/en-us/library/cc645923(v=sql.110).aspx
- For SQL Server 2008R2: http://msdn.microsoft.com/en-us/library/cc645923%28v=sql.105%29.aspx
- RBS Client Library should be installed on the database server. For Microsoft SQL Server 2014 and later, the Remote Blob Store setup is included in the installation media; for other versions you can use corresponding Microsoft SQL Server Remote Blob Store setup package (RBS.msi) available at Microsoft website:
- For SQL Server 2012: http://www.microsoft.com/en-us/download/details.aspx?id=35580
- For SQL Server 2008R2: http://www.microsoft.com/en-us/download/details.aspx?id=16978