SAP Knowledge Base Article - Preview

2199714 - Error 4208 DUMP Transaction to a dump device is not allowed while the trunc log on chkpt option is enabled - SAP ASE

Symptom

When performing a backup operation using the command "DUMP TRAN <My_DB>" designed for an incremental strategy, the ASE server can return the following error:

DUMP TRAN My_DB TO "/tmp/My_DB_TRAN.dmp"
   
Msg 4208, Level 16, State 1:
Server 'ASE157_SP13X', Line 1:
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.

The same error can also be found in the errorlog of the ASE Server :

server Error: 4208, Severity: 16, State: 1
server DUMP TRANsaction to adump 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.


Read more...

Environment

  • SAP Adaptive Server Enterprise 15.7
  • SAP Adaptive Server Enterprise 15.5
  • SAP Adaptive Server Enterprise 15.0

Product

SAP Adaptive Server Enterprise 15.7 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

ASE, backup, dump tran , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.