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β
- Cancel the RESTORE task under example_db.
CANCEL RESTORE FROM example_db;