Hello Community !
 

I am sharing these steps because, when dealing with SharePoint recovery, I encountered several issues that need to be considered, and the online guide is not very clear.

First, you need to consider what permissions are required to use the Veeam Explorer for SharePoint tool:

https://helpcenter.veeam.com/docs/backup/explorers/vesp_permissions.html?ver=120

First, let's start with the necessary environment:

VBR: Veeam Server in workgroup

VM_MSSQL: Server MSSQL, on AD domain, with the same version of Microsoft SQL Server installed on which SharePoint is hosted and which will act as  “staging server”.

Server backup jobs must have Application-Aware correctly configured:

Install the Veeam console on the VM_MSSQL server of the same version as the one on the VBR.

Check the name of the instance on the DB Server running SharePoint and add a registry key on the VBR server and on the VM_MSSQL server.

In our example, we have:

SRVSHAREPOINT: SharePoint server

SRVDB: MSSQL server with SharePoint DB

SP2012: SharePoint MSSQL instance

Registry key needed:

[HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\SPSToSQLMap]

"SRVSHAREPOINT.mydomain"="SRVDB\\SP2012"

Once these installations and configurations have been completed, our environment for restoring from SharePoint on-premises is ready.

Start to restore items from backup:

Open Veeam console from VM_MSSQL and connect to VBR server with user right “Veeam Backup Administrator” or “Veeam Restore Operator”.

Select SHAREPOINT server and Restore Application Item, Sharepoint:

The procedure opens and I select the site I want to restore:

Now it will connect to the DB server that we configured in the registry key…

If we have not configured the registry key correctly, we will get this error:

Now choose the restore point:

After procedure open Veeam SharePoint Explorer:

The first time we run it, it configures the “staging server” we are working on:

Enter the required data for the local VM_MSSQL server:

• Account to connect to Windows server: User with administrative rights on the server and on SharePoint
• Account to SQL Server Instance: “sa” user configured on VM_MSSQL server

The procedure begins with recovering the DB from the backup and mounting it on the staging VM_MSSQL server:

Once the DB has been loaded (the time varies greatly depending on the size of the DB), we obtain the SharePoint site:

…and restore:

I can save library on files or zip:

Or export it:

For everything that can be restored with Veeam Explorer for SharePoint, I recommend following the online guide:

https://helpcenter.veeam.com/docs/backup/explorers/vesp_user_guide.html?ver=120

Good work to all !