problem on SQL2005 database using Networker module for MS SQL backup
Hello all,
we are using networker 7.4.3 with modules for SQL server (ver 5.2) and found that the database could not be backup with following errors. Any suggestion would be appreciated.
Message on xbsa.messages file
XBSA-1.0.1 fb_nmsql_52.Build.71 5480 Thu Dec 04 07:48:50 2008 _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.
Message on nsrsqlsv.raw file
43338 1228334877 1 0 0 5992 6040 0 silver nsrsqlsv 4 %s 1 0 146 D:\Program Files\Legato\nsr\bin\nsrsqlsv.exe -s backup.xxx.au -g crm -LL -f - -m silver.xxx.au -l full -q -W 78 -N MSSQL: MSSQL:
37693 1228334877 1 0 0 5992 6040 0 silver nsrsqlsv 57 SQL Connection to %s is created. SQL Server Version is %s 2 0 4 SILVER 0 10 09.00.3042
38008 1228334878 5 0 0 5992 6040 0 silver nsrsqlsv 2 %s 1 24 92 Internal system error, please see nsr\applogs\xbsa.messages on the client system for reason.
29085 1228334878 5 0 0 5984 6040 0 silver nsrsqlsv 36 Microsoft SQL Server Provider error: 0
38006 1228334878 5 0 0 5984 6040 0 silver nsrsqlsv 3 %s. 1 24 83 Write on "Legato#b15135f0-453e-41d8-b340-d6cf6ae17f25" failed: 995(error not found)
38006 1228334878 5 0 0 5984 6040 0 silver nsrsqlsv 3 %s. 1 24 112 A nonrecoverable I/O error occurred on file "Legato#b15135f0-453e-41d8-b340-d6cf6ae17f25:" 995(error not found).
38006 1228334878 5 0 0 5984 6040 0 silver nsrsqlsv 3 %s. 1 24 42 BACKUP DATABASE is terminating abnormally.
53084 1228334878 5 0 0 5992 6040 0 silver nsrsqlsv 47 Processing %s failed, the item will be skipped. 1 0 20 Test_G1
38008 1228334878 5 0 0 5992 6040 0 silver nsrsqlsv 2 %s 1 24 92 Internal system error, please see nsr\applogs\xbsa.messages on the client system for reason.
29085 1228334878 5 0 0 2720 6040 0 silver nsrsqlsv 36 Microsoft SQL Server Provider error: 0
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.
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
Module licensing these days is tiered based on number of processors; it may be that an upgrade of server could cause the existing license to become invalid.
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
Hari5
443 Posts
490
0
Posted December 4th, 2008 01:00