CANCEL RESTORE

Cancels an ongoing RESTORE task in a specified database.

CAUTION

If a RESTORE task is canceled during the COMMIT phase, the restored data will be corrupted and inaccessible. In this case, you can only perform the RESTORE operation again and wait for the job to complete.

Syntax

SQL

CANCEL RESTORE { FROM <db_name> | FOR EXTERNAL CATALOG }

Parameters

Parameter	Description
db_name	Name of the database that the RESTORE task belongs to.
FOR EXTERNAL CATALOG	Cancels the ongoing RESTORE task for the external catalog metadata.

Examples

Example 1: Cancels the RESTORE task under the database example_db.

SQL

CANCEL RESTORE FROM example_db;