Backup Sybase ASE

[Former Member]

Dear All Expert

I really new in sybase ASE, I need create backup for sybase but when I run comment "dump database" from dbacockpit and os level, its not working, getting error message "stripe device "/backup/sybase/SED/SED.dmp" with error number 13 (Permission denied)"

I already set device "/backup/sybase/SED/SED.dmp" with permission "nobody:nogroup" but still got same error.

please help me solving this case

Thanks

*note

os : linux suse 11 sp 3

db version : sybase 16

sap version : ehp 7

[former_member188958 · Accepted solution]

I'm not sure what you mean by "nobody:nogroup".  If, from the OS, you do

ls -l /backup/sybase/SED/SED.dmp

what does that show?

From one of my own standalone (not part of an SAP application installation) ASE servers.where I start ASE and Backupserver from my account "bret" which is part of the group "Sybase",  the permissions look like this:

-rw-r--r--   1 bret     sybase   1155072 Dec 31 13:12 db1.dmp

The backupserver needs read and write permissions on the dump file for the account that is running the backupserver.

-bret

[Former Member · Accepted solution]

Thanks Bret for your reply,

Yes that's from permission on os level, and file SED.dmp can not create in that path, error say it's because permission.

and backup already in progress right now, because I change owner of /backup/sybase/SED from "nobody:nogroup" to "sybsed:sapsys"

thanks for your help Bret...