Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP SQL Anywhere, on-demand edition 1.0 SP 6 » Task syntax

CreateBackupCopy task

Creates a copy of a backup (or backup set).

Syntax 1 (SQL)
CALL DBCloud.CreateBackupCopy ( backup=backup, host=host [, optional-parameters ] )
Syntax 2 (Cloud Command utility)
dbcloudcmd run CreateBackupCopy backup host [ optional-parameters ]
  • backupcopy

    An output parameter. Internal use only.

  • backup

    The backup to make a copy of. Accepts a search query that identifies one backup. The search query can be a backup name or ID, or a full search. (Required)

  • host

    The target host. (Required)

  • validation_type

    The type of validation. The default is 'X'.

    The following values are supported:

    • D

      Validate that all pages in the database belong to the correct object, perform a checksum validation, and validate the correctness of indexes.

    • F

      Perform a full validation.

    • S

      Perform a checksum validation.

    • X

      Perform an express validation.

    • N

      Do not perform validation.

  • expiration_date

    The date that the backup expires (i.e. the earliest date it can be automatically deleted). Not specifying this parameter means the date will be calculated based on the database's maintenance plan, while specifying NULL means that there will be no expiry date. The default is to use the date calculated using the maintenance plan.

Required privileges



This task creates a copy of an existing backup on a different host. If the backup being copied (the source backup) is an incremental backup, a copy of the full backup and any prior incremental backups (in the same backup set) must already exist on the target host. If not, these backups are copied along with the source backup.

If any form of validation is requested, there must be a cloud server capable of running the database on the target host. If no validation is requested, no running cloud server is required.


Run the following task to create a copy of the backup with ID BP-m8f3 to host myhost.

dbcloudcmd run CreateBackupCopy backup=BP-m8f3 host=myhost