Unsolved
This post is more than 5 years old
10 Posts
0
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 !
No Events found!
Princeaijazbhat
41 Posts
0
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.
TMV1
10 Posts
0
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..
TMV1
10 Posts
0
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
TMV1
10 Posts
0
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.