Start a Conversation

Unsolved

This post is more than 5 years old

4357

May 28th, 2010 03:00

sybase backup fail

hi,expert

  when i congfigure sybase backup .  the following error is produced for schedule backup. why ?  pls help me !

root@sc1 # /usr/sbin/nsrsybsv -Usa -Psybase -s sc1 -l full SYBASE:/SC
Backing up database master.
24146:nsrsybsv:Error from server SC_BS: Msg 412402, Level 2, State 1
Backup Server: 4.124.2.1: Archive API error for device='bms::sc1.SC.master../nsr/tmp/sysDaaBi::00': Vendor application name=Legato, Library version=200, API routine=syb_open(), Message=unable to create environment variables.
24146:nsrsybsv:Error from server SC: Msg 8009, Level 16, State 1
Error encountered by Backup Server.  Please refer to Backup Server messages for details.
24115:nsrsybsv:Error: unable to dump database master in instance SC.
root@sc1 #

>> sybase 12.54
>>
>> networker 7.4
>>
>> module for sybase 3.0

but when i try manul backup sybase . the result is fine . the following is infor.


bash-3.00$ /usr/sbin/nsrsybsv -U sa -P sybase -s sc1 -l full SYBASE:/SC
Backing up database master.
Truncating transaction log for database "master".
Backing up database model.
Truncating transaction log for database "model".
Backing up database sybsystemdb.
Truncating transaction log for database "sybsystemdb".
Backing up database sybsystemprocs.
Truncating transaction log for database "sybsystemprocs".
24193:nsrsybsv:******** SUMMARY OF SYBASE BACKUP ********
53359:nsrsybsv:sc1: SYBASE:/SC/master Level=full, 6193 KB 00:00:10
53360:nsrsybsv:Completion time for NMS backup=1210963573
53359:nsrsybsv:sc1: SYBASE:/SC/model Level=full, 366 KB 00:00:10
53360:nsrsybsv:Completion time for NMS backup=1210963573
53359:nsrsybsv:sc1: SYBASE:/SC/sybsystemdb Level=full, 416 KB 00:00:10
53360:nsrsybsv:Completion time for NMS backup=1210963573
53359:nsrsybsv:sc1: SYBASE:/SC/sybsystemprocs Level=full, 86 MB 00:00:10
53360:nsrsybsv:Completion time for NMS backup=1210963573
24196:nsrsybsv:******* END OF SYBASE SUMMARY *********

best regards

20 Posts

May 28th, 2010 04:00

Seems to me like the user that executes the scheduled backup does not have permissions or all the right environment variables to run the backup.

Make sure all the environment variables is part of that user profile. If you prefer to execute the backup with a specific user that you know have the the right permissions change the NW client resource to reflect that by adding the username/password attributes.

Another issue could be the shell you are using for example csh on the local machine for manual backup and sh for the remote scheduled execution, again make sure that all the environment variables are set for the user in the right shell.

Regards,

Mickey

No Events found!

Top