Staging Microsoft SQL Server

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.

You can use Veeam Explorer for Microsoft SharePoint options to configure staging Microsoft SQL Server settings.

Staging Microsoft SQL Server Note:

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).

Remote BLOB Stores Support

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).

Staging Microsoft SQL Server Important!

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 2014: http://msdn.microsoft.com/en-us/library/cc645923.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, 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