problem on SQL2005 database using Networker module for MS SQL backup

Looks like there is some issue with your license for the SQL module. Check your daemon.raw on the backup server. You should find the relevant errors there.

Hari,

those error messages are come from darmon.raw. Could you show me where I could verify the license settings is correct? thanks

You could use nsrlic to identify the licenses you have and are in use.

Your original post mentioned that the errors are from nsrsqlsv.raw not daemon.raw. You would need to look at the daemon.raw file for the details of the messages related with licensing.

I have the same error in my installation, did you find any solution to your problem?

My backups has been working fine, but now they dont. I have 3 SQLmodules installed on separate servers, all are properly licensed (checked with nsrlic which reports 3 license are in use and correct hostnames), but still i get these errors in the backup logs:

Messages:
jan 21 09:44:48 ow-srvw-bcp02.ow.soyagroup.com: NetWorker server: (info) The feature "NetWorker Module for Microsoft SQL Server/9" is not properly enabled.

daemon.raw:
42506 1232531335 2 0 0 3500 3496 0 ow-srvw-bcp02 nsrd 9 %s %s: %s 3 0 6 server 0 4 info 49 101 12275 41 The feature "%s" is not properly enabled. 1 0 43 NetWorker Module for Microsoft SQL Server/9
2495 1232531338 2 0 0 3500 3496 0 ow-srvw-bcp02 nsrd 98 Impersonation was requested by: "%s", but the user does not have enough privileges to impersonate. 1 0 31 SYSTEM/ow-vmw-db01@NT AUTHORITY

on the client
xbsa.messages:
XBSA-1.0.1 LNMs_2007.Build.202 3952 Wed Jan 21 12:52:22 2009 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 12): The feature "NetWorker Module for Microsoft SQL Server/9" is not properly enabled.

nsrsqlsv.raw
4690 1232538742 1 0 0 2176 3952 0 OW-VMW-DB01 nsrsqlsv 2 %s 1 0 112 BACKUP database [BART] TO virtual_device='Legato#f834ed36-8fd6-45bb-978e-7d0d2fece830' WITH name=N'LegatoNWMSQL'
38008 1232538742 5 0 0 2176 3952 0 OW-VMW-DB01 nsrsqlsv 2 %s 1 24 92 Internal system error, please see nsr\applogs\xbsa.messages on the client system for reason.
29085 1232538742 5 0 0 2912 3952 0 OW-VMW-DB01 nsrsqlsv 36 Microsoft SQL Server Provider error: 0
38006 1232538742 5 0 0 2912 3952 0 OW-VMW-DB01 nsrsqlsv 3 %s. 1 24 161 Write on "Legato#f834ed36-8fd6-45bb-978e-7d0d2fece830" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)
38006 1232538742 5 0 0 2912 3952 0 OW-VMW-DB01 nsrsqlsv 3 %s. 1 24 190 A nonrecoverable I/O error occurred on file "Legato#f834ed36-8fd6-45bb-978e-7d0d2fece830:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
38006 1232538742 5 0 0 2912 3952 0 OW-VMW-DB01 nsrsqlsv 3 %s. 1 24 42 BACKUP DATABASE is terminating abnormally.


I really cant understand what have caused this. It has been working, and the other two sql-servers are still working fine. From all i can understand it sounds like a licenseproblem but all licenses are there.
Anyone has any ideas?

Just for documentation purpose, always check if you have the right number of license. New release of networker will enforce this, which was not the case before.

You can also put the -D9 on the save backup command nsrsqlsv and check the output under /nsr/tmp/sg/ .

In some case you will see something like:

freeing unused errinfo with msgid 0
lgto_parms fail: The feature "NetWorker Module for Microsoft SQL Server/9" is not properly enabled.
direct save returns: The feature "NetWorker Module for Microsoft SQL Server/9" is not properly enabled.
freeing unused errinfo with msgid 0

Which is a good sigh of licensing issue

I am having the same issue.

Check/renew the license for SQL module and issue rectified.

Hi,

This is problem with SQL for networker license, check the file xbsa.messages and also in the backup server runs the command nsrlic there can verify the number of licenses you have and if you have SQL available

Greetings,