Here's the code that I use to create a backup event...
CREATE EVENT DailyBackup
Does anyone have code which will backup the database and validate the backed-up database?
asked 04 Nov '11, 22:49
Besides Breck's many articles on that, you may also have a look at the maintenance plans facility that let you create events to backup and validate databases in the Sybase Central GUI. After they have been created by the GUI, you can have a look at the SYSEVENT table to study the created event handlers.
I have used them as starting points for own events and modify them for my own requirements.
Note that some folks (apparently including Breck, cf. this discussion) would not use events to backup a database but prefer an automatically executed external batch that calls DBBACKUP. (That's not my opinion, FWIW...)
Some more discussions are available here, e.g. this one - or simply look for the "backup", "validation" or "maintenance-plan" tags...
answered 05 Nov '11, 18:32