Backing up Sybase Anywhere 7 DB

[n2nuk]

Hi there,

I need to create a backup job to create a local backup to disk that will then back up the file to tape using Backup Exec.

Reading some of the sybase material I have come a number of backup options and am considering online backups as the way to go.

I would welcome advice and suggestions on the following:

What is the preferred backup method used?
What are the downsides to performing a online backup?
Will the log files be flushed when the backup runs?

What are the command line options for setting up the job? I am planning to use scheduled tasks to run a batch file that will perform the backup.

I intend running the following command line to perform an online backup:
dbbackup -c "UID=DBA;PWD=jason;ENG=server;DBN=database" –y D:\dbbkup - will this do the job or are there any switches I may have missed?

Many thanks in advance and apologies for the many questions


I

I would appreciate any views on the best backup method to use. Also appreciate

 

[doug04]

Not sure on the commands but I use a small program called Syncback to do multiple backup locations. It will also zip up your file and ftp it for you.