---
metadata:
  - name: generator
    content: Diplodoc Platform v5.50.6
alternate:
  - https://ydb.tech/docs/en/yql/reference/syntax/restore-backup-collection.md
  - https://ydb.tech/docs/ru/yql/reference/syntax/restore-backup-collection.md
sourcePath: en/core/yql/reference/syntax/restore-backup-collection.md
---
> **Documentation Index:** Fetch the complete configuration index at https://ydb.tech/docs/en/llms.txt

# RESTORE

The `RESTORE` statement restores tables from a [backup collection](https://ydb.tech/docs/en/concepts/datamodel/backup-collection.md).

```yql
RESTORE collection_name;
```

## Parameters

* `collection_name` — name of the backup collection to restore from.

## Restore behavior

The restore operation:

* Finds the **current chain** of backups in the collection (the latest full backup followed by its incremental backups).
* Restores tables to the state of the **most recent** backup in that chain: applies the full backup and all subsequent incrementals in sequence.
* Fails if any of the tables being restored already exists at the same path.

Restoring to an arbitrary point "between" two saved backups is not supported: the result is always the state captured by one of the backups in the chain.

{% note warning %}

The restore operation fails if any of the tables being restored already exists at the same path. Rename or drop the conflicting tables before restoring.

{% endnote %}

## Examples

Restoring from a backup collection:

```yql
-- Restore all tables from the collection
RESTORE production_backups;
```

## Monitoring restore operations

Restore operations run asynchronously in the background. You can monitor their progress using YDB CLI:

```bash
# List backup and restore operations
ydb operation list incbackup

# Get operation details
ydb operation get <operation-id>
```

## See also

* [Backup collections](https://ydb.tech/docs/en/concepts/datamodel/backup-collection.md)
* [CREATE BACKUP COLLECTION](https://ydb.tech/docs/en/yql/reference/syntax/create-backup-collection.md)
* [BACKUP](https://ydb.tech/docs/en/yql/reference/syntax/backup.md)
* [DROP BACKUP COLLECTION](https://ydb.tech/docs/en/yql/reference/syntax/drop-backup-collection.md)
* [Backup and recovery guide](https://ydb.tech/docs/en/devops/backup-and-recovery.md)