isql with Sybase IQ Backups

[Former Member]

Hey,

Wanted to check if its possible to backup a remote Sybase IQ server running on Linux using isql. Local database backup succeeds without issues however when we try and backup a remote db we are getting :

Msg 13720, Level 21, State 0 :

SQL Anywhere Error -697: Error during backup/restore: unable to determine disk freespace on /<device_name>/backup.dmp1 (no such file or directory).

Permissions are ok since we granted full permissions and as mentioned tested a backup from the local db.

Appreciate any help & many thanks!

Etienne.

[former_member194571 · Accepted solution]

Backup is executed within the IQ server, so it should be independent of the SQL client used. Unless you're trying to back up to a client side destination (which doesn't work), my top suspect is some string literal metacharacter if your command works with one front- end and doesn't work with another.

Can you post

- the precise statement

- which front- end executes it correctly

HTH

Volker

[Former Member]

Hi Etienne,

the archive_device should be found/mounted on IQ server host machine with full physical path,

it does not matter the utility (isql or dbisql) you used.

HTH, thanks.

Best Regards,

Robert

[Gisung]

Hi,

The path of backup command is absolute path?

And is it same when you execute a backup command with dbisql?

And target destination is network driver(remote)??

Please check to "mount" the NTFS drive instead of mapping the drive.

Best Regards,

Gi-Sung Jang

[Sriram2009]

Hi Etienne

Msg 13720, Level 21, State 0 :
SQL Anywhere Error -697: Error during backup/restore: unable to determine disk freespace on /<device_name>/backup.dmp1 (no such file or directory).

Error Message clear check the free disk space?

BR

SS