UNSOLVED

TMV1

updated

8 years ago

T

TMV1

10 Posts

0

2189

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 !
  • 1692

    0

    Posted 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

    1692

    0

    Posted 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

    1692

    0

    Posted 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

    1692

    0

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