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

ValidateBackupCopy task

Validates a copy of one or more backups.

Syntax 1 (SQL)
CALL DBCloud.ValidateBackupCopy ( backupcopy_list=backupcopy_list [, optional-parameters ] )
Syntax 2 (Cloud Command utility)
dbcloudcmd run ValidateBackupCopy backupcopy_list [ optional-parameters ]
Parameters
  • backupcopy_list

    A list of backup copies to validate. Accepts a search query that identifies backup copies. The search query can be a list of backup copy names or IDs separated by semicolons (;), or a full search. (Required)

  • validation_type

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

    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.

Required privileges

BackupDatabase

Remarks

Validating a backup copy involves creating a temporary copy of the backup files, and validating that copy. Once the validation has completed, the temporary copy of the backup files is removed.

The backupcopy_list parameter accepts a list of backup copy IDs. To view a list of all backup copy IDs in the cloud, run the following command:

dbcloudcmd describe type:backupcopy

Example

Run the following task to run an express validation on a backup copy with the ID BC-q5v5:

dbcloudcmd run ValidateBackupCopy backupcopy_list=BC-q5v5 validation_type=X