Skip to main content

CANCEL RESTORE

Description

This statement is used to cancel an ongoing RESTORE task.

Syntax

CANCEL RESTORE FROM <db_name>;

Parameters

1.<db_name>

The name of the database to which the recovery task belongs.

Usage Notes

  • When cancellation is around a COMMIT or later stage of recovery, the table being recovered may be rendered inaccessible. At this time, data recovery can only be performed by executing the recovery job again.

Example

  1. Cancel the RESTORE task under example_db.
CANCEL RESTORE FROM example_db;