Incremental Backup error. In the binary log:
Sybase Message: 'DUMP TRANsaction to a dump device is not allowed while the trunc. log on chkpt. option is enabled.
Disable the option with sp_dboption, then use DUMP DATABASE, before trying again. '
Failed to get sybase results for command: 'DUMP TRAN xx TO "xxx::xxx#2658#xxxx#7"'
Dump of database PRD failed
If truncate log on checkpoint is enabled, then transaction logs backups cannot be performed. Sybase will not allow transaction log backup with the setting truncate log on checkpoint is enabled.
Furthermore, If truncate log on checkpoint is enabled, a log can be truncated when a backup of the log has never been taken. Which would result in sequences of backups missing logs. That is the reason why the Sybase Server enforces that transaction logs backup cannot be taken under that setting.
'Incremental Backups' will need to disable the setting truncate log on checkpoint. Then monitor how the logs are truncated, to adjust properly the frequency of backups, and or if necessary to adjust the size of the device used for the logs.
* If truncate log on checkpoint is enabled, then only Full Backup are allowed.
* On the other hand, truncate log on checkpoint can be disabled, and Full and Incremental backups can be taken. The backups will truncate the logs.
Refer to Sybase documentation on how to disable truncate log on checkpoint.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center