We have a Adaptive Server Anywhere 7 running here, and I'm concerned with the backup.
What I want to do, is having a full backup every week in it's own directory, i.e. on Friday putting the .db and the .log file in the directory, and on the following days just the log files. So I'd have a directory structure like "backup_db_2004_30", "backup_db_2004_31" where 30 and 31 are the calendar weeks. I already have a perl script that handles the directories and make different system calls depending on the weekday, but I'm a bit stuck on the dbbackup.exe calls I have to do to get the results I need.
I'm not very much into the database theme at all, so I don't really understand what data is in what files, I'm just the serveradmin that shall do the backup