SQL Back-up fails 1

[ingar]

I am trying to back-up A SQL server. the OS backs-up with out any issues, however the SQL back-up completes as if it has been successful.

However, When having a closer look at the SQL back-ups. The Group details gives the following message:

tlapwfc020009.tluser.tlroot.ads

* tlapwfc020009.tluser.tlroot.ads:MSSQL: save: using `MSSQL:\' for `MSSQL:'
* tlapwfc020009.tluser.tlroot.ads:MSSQL: save: cannot stat MSSQL:\: Invalid argument
* tlapwfc020009.tluser.tlroot.ads:MSSQL: save: Could not stat MSSQL:: Invalid argument
tlapwfc020009.tluser.tlroot.ads: MSSQL: level=full, 1 KB 01:41:10 1 file
tlapwfc020009.tluser.tlroot.ads
index
succeeded:full:index
tlmawfc020001.tluser.tlroot.ads: index:tlapwfc020009.tluser.tlroot.ads level=full, 69 MB 00:00:16 220 files


Also whe I try and do a save set restore of MSSQL it gives the following message:
"There are no back-ups to restore"

Also when I look in Networker User to see which save sets are available for MSSQL, it gives the size as 0 KB

 

[TDun]

It sounds like you are usingthe wrong command
Switch tabs on the client setup in it's savegroup and ensure you are defining the sql backup command.

 

[TDun]

FYI, Manage Groups, drill down to the client, right-click, edit, click on Remote tab, enter nsrsqlsv as teh backup command.
Make sure you define a user/password combination that has SQL admin rights. RTM, page 26 on the Networker Module, SQL Installation Guide for exact setup details.

 

[605]

I think the simple problem is that you want to backup a directory and not a logical save set.

As mentioned by the log the save set should read "MSSQL:" instead of "MSSQL:\