We seem to have encountered a problem with dbbackup.exe where it triggers the BackupEnd event (which is confusingly called Backup Completed in Sybase Central) even though the backup fails because it has run out of disk space.
This was originally encountered in ASA 9 but appears to be the case in SQLAny 12 too. The dbbackup.exe tool does correctly return a failure exit code in the command file but I have been unable to get this result in the event.
Is the fact that the event is triggered on failure a bug and/or is there any way for me to tell in the event that it has failed?
Thanks in advance
asked 11 Oct '11, 04:39
As the BackupEnd system event is defined as
I would think it is just there to inform you that a backup is finished - successfully or not. There don't seem to be event parameters that show errors or success. But's just my impression...
For better control I would suggest to run the backup as part of an user-defined event (with the BACKUP DATABASE statement instead of using dbbackup.exe). Then you can handle errors by the according SQL statements as you like.
And for ease, there's the maintenance plans facility that let you create such events in a GUI. I have used them as starting points and modify them for my own requirements.