I don't see an obvious way to do this. The BACKUP statement doesn't provide
you the renamed log file name, so you would probably be headed towards an
external function call to check the list of files in the backup directory
before doing the backup and then checking the list of files after the backup
to pick the new log file name out of the difference.

What will you be doing with the file name once you get it?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx...c?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"Kjetil Valøy" <kjetil.valoy (AT) iticket (DOT) no> wrote