Unsolved

77 Posts

1676

February 3rd, 2021 07:00

Problem with NetWorker SQL client

Hello Everyone,

I'm adding a discussion here in order to see if anyone has ever seen the following behavior while trying to backup some SQL client with NMM.

Some environnement informations: NetWorker server, client and NMM version are 19.2.1.2 Built 118

Description of the problem: About some weeks ago, some SQL client started hung when the backup started.  It starts doing the basic first command "savefs", but the "nsrsqlsv" command is never built and clients keep staying in the box "Currently running" of the monitoring tab of NMC showing :savefs

The SQL backup will never start and will be in hung state like that until the workflow is aborted manually or using a HARD LIMIT configured at the action level.

Observations: We observed that we cannot run filesystem of those client either, from NMC or from the client.  However, something very strange, SQL DBA can run the SQL backup (FULL and LOGS) and send the DATA in NetWorker infrastructure by running them using the NMM GUI from SQL client itself.

N.B: Out of 18 SQL clients, only 5 are doing this issue.

Actions taken to try and solved so far:Reboot NW server and clear "tmp" folder and "jobsdb".  Deleting client than re-creating.  Check to to make sure all SQL clients were configured the same way as others working.  Look at logs, some "nsr_peer_information" which were cleared.

If anyone has an idea, it would be much appreciated.

Thank you and have a nice day ahead,

Chris

No Responses!

0 events found

No Events found!

Top