Sybase BACKUP

[johnvai]

I want to ask how can i make a small program that makes the backup of my database without doing it from Sybase central view.

Does the Sybase have this function?

I just need to create a program that's called BAKUP.EXE which backs up my database.

 

[qyllr]

hello,

if you are doing it in unix... you can write a shell script and then use CRON to schedule the job...

in windows you need to write a batch job and then schedule the job with WINAT...

hth,
q.

 

[johnvai]

Thanks for the reply, but i haven't taken any idea of what you are talking about. Can you explain to me what to write in the batch and what to run as executable (In Windows).
I don't know if there's an executable to run or a function that the sybase has to backup a specific database. (I know that i can do it from central viewer manually).

I don't know how to explain, but i want to make a program and install it on the server of the client which automatically backs up his database.

Your help is very appreciated.

 

[VDavid]

There are several ways to backup a database, it depends if the server is running or not, if you want to backup just the transaction log or also the '.db'.
Keep in mind that backup itself is just a process of coping the files in a safe place to replace the originals if something goes wrong, that means that you can make a program to just copy the files somewhere for backup, but this methods needs the server to be offline. Another way is using sybase's utilitys, for example you can create a program that uses the dbbackup, dbshrink or dbtool, the syntax and help are in the help of sybase.
Try searching the sybase web site for backups methods and tips.
It also depends on the version of sybase.

Hope this helps,

David.

 

[johnvai]

Dear David:

thanks you helped me a lot really.
I found the command.

dbbackup -c &quot;uid=dba;pwd=sql;dbf=<path to db file>&quot; c:\backup