I assume when running scheduled backup of sqlsv1 that works too... Can you tell me what window doesn't open - NW SQL window? I mean, is that "..not found" message by trying to run SQL user or by SQL user trying contact database?

Everything is configured as per the document.
The SQL servers are in cluster (MSSQL1 and MSSQL2). There are two instances: sqlvs1 running on MSSQL1 and sqlvs2 running on MSSQL2.
I am able to take the backup of sqlvs1 but not of sqlvs2.
When initiating the client backup on MSSQL1, the Networker User for SQL Module opens and I can take the backup of sqlvs1.
But when I do the same on MSSQL2, I am getting the error "the file specified is not found" and the window doesn't open.

Are you sure everything is configured by the book? Anything in xbsa.messages? What about client initiated backup?

The scheduled backup of sqlvs1 is working fine.
When I click on the networker user for SQL on MSSQL2, the error message comes " the file specified is not found". Here the NW SQL is actually trying to contact the SQL database.

Well, it could be also that link for icon is broken and can't find a SQL user too - right? (if window would open and if only after that you would get error that would be something else then)

This error is corrected in the latest build of the SQL module (build 184). As you're running on build 154, just do the upgrade.

Did you installed SQL module licenses for both sql servers?

The error which is fixed in build 184 was related to GUI only I believe - at least that is what title of that LGTpa said... If you try CLI backup does it work? Also I would assume scheduled to run then too...

I like such solutions remember I solved one problem with sql backup after upgrade from 4.0 to 4.1 or 5...
people buy licenses for software pay huge $$$ and get errors... and developers fix errors only in next version

The worst thing is that usually the latest version is not avaliable for download, and then you have to open a case about your problem to get the latest version that will fix your problem.

Hi,
I have reinstalled the SQL module 5.0 in both the servers. Then also the situation is the same. sqlvs01 is happening on MSSQL01 but when starting sqlvs02 backup on MSSQL02 gives the error :
"Error detecting SVS root path for sqlvs02.corp.exlservice.com
The system cannot find the file specified"

Then I moved sqlvs01 to MSSQL02 and sqlvs02 to MSSQL01.
The backup of sqlvs01 is working fine without any error. When I initiate the sqlvs02 backup.
it throws the same error in the starting but after that it takes the backup of databases.

(Continuation to the above mail)

The following is the nsrsqlsv.log output (when sqlvs01 on MSSQL02 and sqlvs02 on MSSQL01):
[4168] 01/30/07 01:29:06 Start time Tue Jan 30 01:29:06 2007
[4168] 01/30/07 01:29:06 Computer Name: C3W2K3X77-SQL1 User Name: CORP\animesh12441 (animesh12441)
[4168] 01/30/07 01:29:06 System Version: 5.2 Build 3790 Service Pack 1
[4168] 01/30/07 01:29:06 Microsoft Data Access Component(MDAC) version: 2.82.1830.0
[4168] 01/30/07 01:29:06 Microsoft SQL Server version (from registry) : 9.00.2047.00
[4168] 01/30/07 01:29:06 Local host has following SQL Server online:
[4168] 01/30/07 01:29:06 MSSQL server : SQLVS01\SQLVS01
[4168] 01/30/07 01:29:06 Use Legato Networker Server : c3w2k3x80-bkp.corp.exlservice.com
[4168] 01/30/07 01:29:06 Legato Networker Server Version: NetWorker nw_7_3_2_jumbo.Build.11 Network Edition/90
[4168] 01/30/07 01:29:06 nsrexecd.exe Version: nw_7_3_2_jumbo.Build.11
[4168] 01/30/07 01:29:06 nsrsqlsv.exe Version: 5.0.0.154 Supporting SQL 7.0, SQL 2000, and SQL 2005
[4168] 01/30/07 01:29:06 Command line:
[4168] 01/30/07 01:29:06 C:\Program Files\Legato\nsr\bin\nsrsqlsv.exe -s c3w2k3x80-bkp.corp.exlservice.com -g Exchange -LL -m sqlvs01 -o VSS:*=off -l full -q -W 78 -N MSSQL: MSSQL:
[4168] 01/30/07 01:29:07 SQL Connection to SQLVS01\SQLVS01 is created. SQL Server Version is 09.00.2047
[4168] 01/30/07 01:29:07 Started resource thread (Id: 2248)
[4168] 01/30/07 01:29:07 Cluster resource monitor thread running; virtual server SQL Server (SQLVS01).
NSR_BACKUP_LEVEL: full;
NSR_CLIENT: sqlvs01;
NSR_GROUP: Exchange;
NSR_SAVESET_NAME: "MSSQL:";
NSR_SERVER: c3w2k3x80-BKP;
[4168] 01/30/07 01:31:07 Backing up of master succeeded.

[4168] 01/30/07 01:31:07 The backup of master has completed successfully
[4168] 01/30/07 01:31:08 Backing up of model succeeded.

[4168] 01/30/07 01:31:08 The backup of model has completed successfully
[4168] 01/30/07 01:31:09 Backing up of msdb succeeded.

[4168] 01/30/07 01:31:09 The backup of msdb has completed successfully
[4168] 01/30/07 01:31:09 Skip building the named instance directory for clusters.
[4168] 01/30/07 01:31:12 Resource monitor thread termination status: 0x0
[4168] 01/30/07 01:31:12 Completion time Tue Jan 30 01:31:12 2007


[4372] 02/07/07 01:50:04 Start time Wed Feb 07 01:50:04 2007
[4372] 02/07/07 01:50:04 Computer Name: C3W2K3X77-SQL1 User Name: CORP\vaibhav4908 (vaibhav4908)
[4372] 02/07/07 01:50:04 System Version: 5.2 Build 3790 Service Pack 1
[4372] 02/07/07 01:50:04 Microsoft Data Access Component(MDAC) version: 2.82.1830.0
[4372] 02/07/07 01:50:04 Microsoft SQL Server version (from registry) : 9.00.2047.00
[4372] 02/07/07 01:50:04 Error detecting SVS root path for sqlvs02.corp.exlservice.com
[4372] 02/07/07 01:50:04 The system cannot find the file specified.

[4372] 02/07/07 01:50:05 Use Legato Networker Server : c3w2k3x80-bkp.corp.exlservice.com
[4372] 02/07/07 01:50:05 Legato Networker Server Version: NetWorker nw_7_3_2_jumbo.Build.11 Network Edition/90
[4372] 02/07/07 01:50:05 nsrexecd.exe Version: nw_7_3_2_jumbo.Build.11
[4372] 02/07/07 01:50:05 nsrsqlsv.exe Version: 5.0.0.154 Supporting SQL 7.0, SQL 2000, and SQL 2005
[4372] 02/07/07 01:50:05 Command line:
[4372] 02/07/07 01:50:05 C:\Program Files\Legato\nsr\bin\nsrsqlsv.exe -s c3w2k3x80-bkp.corp.exlservice.com -g FS -LL -m sqlvs02 -o VSS:*=off -l full -q -W 78 -N MSSQL: MSSQL:
[4372] 02/07/07 01:50:05 SQL Connection to SQLVS02 is created. SQL Server Version is 09.00.2047

[4372] 02/07/07 01:50:05 Started resource thread (Id: 2512)
[4372] 02/07/07 01:50:05 Cluster resource monitor thread running; virtual server SQL Server.
NSR_BACKUP_LEVEL: full;
NSR_CLIENT: sqlvs02;
NSR_GROUP: FS;
NSR_SAVESET_NAME: "MSSQL:";
NSR_SERVER: c3w2k3x80-BKP;
[4372] 02/07/07 01:52:02 Backing up of CDSV2Temp succeeded.

[4372] 02/07/07 01:52:02 The backup of CDSV2Temp has completed successfully
[4372] 02/07/07 01:52:07 Backing up of MINT succeeded.

[4372] 02/07/07 01:52:07 The backup of MINT has completed successfully
[4372] 02/07/07 01:52:10 Backing up of master succeeded.

[4372] 02/07/07 01:52:10 The backup of master has completed successfully
[4372] 02/07/07 01:52:20 Backing up of model succeeded.

[4372] 02/07/07 01:52:20 The backup of model has completed successfully
[4372] 02/07/07 01:52:23 Backing up of msdb succeeded.

[4372] 02/07/07 01:52:23 The backup of msdb has completed successfully
[4372] 02/07/07 01:52:23 Skip building the named instance directory for clusters.
[4372] 02/07/07 01:52:30 Resource monitor thread termination status: 0x0
[4372] 02/07/07 01:52:30 Completion time Wed Feb 07 01:52:30 2007

You are still using old build of module - did you speak to your support about this?

shreejesh,

Why you try to connect to same machine (C3W2K3X77-SQL1) with different users ?

Are you sure that your client configuration for database sqlv02 is ok ?

Why you use different users to backup these databases if the users are in the same domain ? It´s sounds like permission/security issue.

Are you sure the user CORP\vaibhav4908 (vaibhav4908) have the same permission on sqlv02 that CORP\animesh12441 (animesh12441) have at sqlv01 ?