Highlighted
ghanshu
1 Copper

The Mirror SQL DB BAckup failed with Cannot run savefs: No error

Hi We have two MSSQL NODE with Mirror DB & We have rying to take backup from networker 8.2.4 (client & server networker version same 8.2.4 with windows 2012) but the Backup is getting fail with Error

Cannot run savefs: No error

03/30/17 10:14:08.495604 RPC Authentication: error in LookupAccountSid: No such file or directory

166264:savegrp: Group TEST waiting for 1 jobs (0 awaiting restart) to complete

84078:savegrp: command 'savefs -s ig-emc-nwkr.x.com -c abc.x.com -g TEST -p -l full -R -v -F MS

SQL$PCTXCO02:' for client abc.x.com exited with return code 76

90491:savegrp: abc.x.com:savefs unexpectedly exited.

90492:savegrp: abc.x.com:savefs will retry 1 more time(s).

83647:savegrp: TEST abc.x.com:savefs See the file D:\Program Files\nsr\logs\sg\TEST\9117 for command out

put

166264:savegrp: Group TEST waiting for 1 jobs (1 awaiting restart) to complete

166264:savegrp: Group TEST waiting for 1 jobs (0 awaiting restart) to complete

84078:savegrp: command 'savefs -s ig-emc-nwkr.x.com -c abc.x.com -g TEST -p -l full -R -v -F MS

SQL$PCTXCO02:' for client abc.x.com exited with return code 76

90491:savegrp: abc.x.com:savefs unexpectedly exited.

83647:savegrp: TEST abc.x.com:savefs See the file D:\Program Files\nsr\logs\sg\TEST\9118 for command out

put

107149:savegrp: Stopped processing of the save set abc.x.com:MSSQL$PCTXCO02: because the savefs job job

terminated with an error.

77562:savegrp: job (9119) host: abc.x.com savepoint: MSSQL$PCTXCO02: had ERROR indication(s) at completi

on

90491:savegrp: abc.x.com:MSSQL$PCTXCO02: abandoned.

7241:savegrp: nsrim run recently, skipping

we also trying to take backup from client side & it was completed successful.

Tags (3)
0 Kudos
3 Replies
wlee4
2 Iron

Re: The Mirror SQL DB BAckup failed with Cannot run savefs: No error

One of the differences between using a NetWorker server initiated backup vs client initiated backup is "who" is actually running the backup.  i.e. What user account is being used when running the backup commands on the NetWorker client?


When you are on the NetWorker client and starting a backup manually, (eg: using the commands save or nsrsqlsv, savefs, etc) you are running these commands using the privileges that is assigned to the account you used to log into the host.

With server initiated backups, the NetWorker server contacts the client's nsrexecd process and tells it to run the commands on behalf of the server.  The default account credentials used is the same account that is used to start up nsrexecd.  This start up account can be determined by either going into Windows Services, and looking at the NetWorker Remote Exec properties, or from command line using:  sc qc nsrexecd | findstr /i service_start


The account used to start server initiated backups can be changed by specifying the remote user in the NetWorker client resource.


"we also trying to take backup from client side & it was completed successful."


Please elaborate on how this was done?  you mean that you ran this savefs command on the client side?

     savefs -s ig-emc-nwkr.x.com -c abc.x.com -g TEST -p -l full -R -v -F MSSQL$PCTXCO02:'

Please check the following:

  1. What is the NMM version?
  2. What is the SQL version?
  3. Are the NetWorker client and NMM software installed on all SQL nodes?
  4. The output refers to this file for additional information.  Did you look at this file? What additional information did it provide?   "D:\Program Files\nsr\logs\sg\TEST\9117"


In the NetWorker client resources for these SQL servers, what are the:

  • backup command
  • remote user
  • Application information

If you are reluctant to share the information in this public forum, then please open a service request so that NetWorker support may assist you in detail.

0 Kudos
mgennacc
1 Nickel

Re: The Mirror SQL DB BAckup failed with Cannot run savefs: No error

In a SQL Server mirror relationship, two SQL Server instances are involved where

Server 1 instance 1 has the primary database,  (think of this as "active" )

Server 2 instance 2 has the mirror database, (think of this as "standby" or the mirror copy of the primary)

You must create client resources for both server 1 and 2.  but You cannot perform backups

of the mirror databases on server 2.    You can only perform backups of  primary databases on server 1.

You can perform backups of non mirror databases on server 2 any time.  But not the mirror copy.

On the server 1 you can do level full and incremental backups of the primary database.

Lastly,

/-i.  check the service account of SQL Server service  on both SQL Servers.

Make sure the same Domain account is used.  Does not have to domain admin. 

During a scheduled backup, savefs contacts the primary SQL server, and Networker Remote exec service must be able to authenticate sql server on both nodes. The only way is to make the servce accounts of sqlserver the same.

/-ii.  check Remote user field of the client resource ; 

If any of the following is true then Remote User field needs the following permissions

--- must be a domain user with local windows administrator privileges, and SQL sysadmin rights on both SQL Servers.

• SQL Server is a clustered instance,

• SQL Server databases are involved in a mirroring relationship or replicated in SQL AlwaysOn Avail. Group

• SQL Server is version 2012 or higher (in any sense whether standalone or clustered)

0 Kudos
l.walid
1 Nickel

Re: The Mirror SQL DB BAckup failed with Cannot run savefs: No error

Hi,

One of the causes of no error is : on the client properties remove the user and password (since you already started the networker client service with the right account on the client)

0 Kudos