Our sybase database sometimes crashes at the time of a backup. It logs the following error: *** ERROR *** Assertion failed: 100910 (10.0.1.3415)
This is occurring since we changed our backup command from:
set dest='E:\\data\\database_backup\\' || db_name();
backup database directory dest TRANSACTION LOG RENAME
to:
set dest='E:\\data\\database_backup\\' || db_name();
backup database directory dest WAIT AFTER END TRANSACTION LOG TRUNCATE
Reason we changed it because we wanted to get rid off all the created logfiles in our database-directory. For us there is no use storing them, we never are going to use them. It looks like the transaction logfile cannot be deleted, but we cannot find the reason. Our viruschecker is skipping the database-directory.
Anyone ever encountered a similar problem?
Servoy support advised us to use the dbbackup.exe utility to perform the backup. Is there any difference in using this utility or executing the SQL-script?