Start a Conversation

Unsolved

This post is more than 5 years old

2001

July 21st, 2018 03:00

Sharepoint 2016 backup failure

Hi, i got the initial setup configured by referring to NMM for sharepoint using VSS 9.2 guide. For each server in SP farm, I can see the saveset listed when I execute nsrnmmsv -P but  the primary WFE  backup fails with an error "Failed to send large saveset to SQL server" ..Any suggestions related to troubleshooting in the right direction  is appreciated as I could not find any relevant information in networker or OS event logs.  thanks !

July 23rd, 2018 13:00

Ensure that the following prerequisites are taken care of before performing

SharePoint Server scheduled backups:

•The NetWorker client and NMM must be installed on hosts with data that

needs to be backed up.

•The SharePoint services Writer must be registered, so that the save sets

can be browsed and backed up successfully. Use the command:

–STSADM -o registerwsswriter

•The nsrsnap_vss_save command must run under the security context of SYSTEM

user.

•Provide the required permission to the SYSTEM user to run SharePoint

PowerShell using the command:

Add-SPShellAdmin -UserName "$"

•Grant Windows logon account the SQL Server system dbcreator, public, and

sysadmin permissions

•Ensure that all SharePoint databases are mounted before backing up the

application server. Unmounted databases are not backed up.

•Do not move or change Admin component of Search inside the same SharePoint

Server after installation.

•Any major change made to the SharePoint configuration or database

structure requires a fresh backup.

•Configure the SharePoint farm with the SQL Server using FQDN or shortname

of the SQL Server .

We ideally use one of the Web Front system to start the wizard.It will show

up Content, configuration databases. It detects the entire farm.

We always need to add administarors and SYSTEM users to user group for all

the systems of farm .We need to add all servers in the form to this list.

10 Posts

July 24th, 2018 11:00

Thanks,  I believe all that you mentioned is covered because I can add web front end server without issues which also adds the remaining servers in the Shareapoint Farm as dummy clients as part of the configuration.   I see you've mentioned nsrsnap_vss_save but I find nsrnmmsv in the attributes so am not sure, if am missing something here..

10 Posts

August 3rd, 2018 21:00

Thanks, The error is exactly the same mentioned in the following link and I am pretty sure nothing is blocking port 135  https://support.emc.com/kb/500655

10 Posts

August 12th, 2018 09:00

My problems around setting up sharepoint backup is fixed now. I had to open WMI dynamic ports across all servers in Sharepoint Farm.

No Events found!

Top