Backing up Sybase

[Riccardino]

Hi,

is it possible to backup Sybase making a hot copy of the "database" folder located into Servoy app folder or is it a dangerous procedure?

[Riccardino]

Update:

I read in Sybase documentation that is possible to perform an online backup using:
BACKUP DATABASE DIRECTORY "path"
I tried with Interactive SQL and it works fine.

Is it possible to trigger this command from within Servoy?

[Jan Aleman]

Not directly, it is possible to trigger isql using executeProgram or even better to create a schedule to automatically backup your database. The last example in the documentation shows you how to do that. Doc path:

ASA SQL Reference
SQL Statements
BACKUP statement

[Riccardino]

Not directly, it is possible to trigger isql using executeProgram or even better to create a schedule to automatically backup your database. The last example in the documentation shows you how to do that. Doc path:

ASA SQL Reference
SQL Statements
BACKUP statement

Thanks Jan: I set an event and everything works. I also tried to attach a method to a database trigger and also this option works...:-)

[Harjo]

I also tried to attach a method to a database trigger and also this option works...

Can you explain this? or make an: HOW TO?

[Riccardino]

I also tried to attach a method to a database trigger and also this option works...

Can you explain this? or make an: HOW TO?

Sure