Using the Command Line Interface › ca_backup - Backup Manager Command › ca_backup - Database Options › ca_backup - Sybase Agent Database Options

ca_backup - Sybase Agent Database Options

The ca_backup command includes the following Sybase database options:

ca_backup [-sybase_database|-sybase_transactionlog trunc|-sybase_transactionlog no_trunc ]

Note: The ca_backup database options are described in a separate topic titled "Database Options" and can be viewed from the actual CLI by entering the following command: ca_backup allusage.

• -sybase_database

  Specifies to back up the Sybase database data.

• -sybase_transactionlog trunc

  Specifies to truncate the transaction log during backup.

  To decrease the size of a transaction log, you can specify to truncate the transaction log when you back it up. When the agent backs up a transaction log without truncating it, the agent backs up the log from the last successfully executed log backup to the current end of the log. The backup includes both the active and inactive portions of the log file. If you specify to truncate the log during backup, the agent removes the inactive portion of the log and truncates the log to the beginning of its active portion, the part that contains the oldest open transaction.

  This is the default option.

• -sybase_transactionlog no_trunc

  Specifies not to truncate the transaction log during backup.

Examples:

The following are examples of syntax for the ca_backup SYBASE database command:

• Use the following command to back up database data:

  -database SYBASE <instance> <database> -sybase_database
  

• Use the following command to truncate the transaction log during backup:

  -database SYBASE <instance> <database> -sybase_transactionlog trunc
  

• Use the following command to not truncate the transaction log during backup:

  -database SYBASE <instance> <database> -sybase_transactionlog no_trunc