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

# CREATE BACKUP COLLECTION

The `CREATE BACKUP COLLECTION` statement creates a [backup collection](https://ydb.tech/docs/en/concepts/datamodel/backup-collection.md).

```yql
CREATE BACKUP COLLECTION collection_name (
    TABLE table_name [, TABLE another_table_name ...]
) WITH (option = value [, ...]);
```

## Parameters

* `collection_name` — name of the backup collection to create.
* `table_name` — full path to a table to include in the collection. Multiple tables can be specified.
* Options:

  * `STORAGE` — storage backend for backups. Supported values:
    * `'cluster'` — storage within the YDB cluster.
  * `INCREMENTAL_BACKUP_ENABLED` — enable incremental backup support. Set to `'true'` to enable incremental backups, `'false'` for full backups only.

{% note info %}

When choosing a name for the backup collection, please consider the common [schema objects naming rules](https://ydb.tech/docs/en/concepts/datamodel/cluster-namespace.md#object-naming-rules)

{% endnote %}

## Examples

Creating a backup collection with a single table:

```yql
CREATE BACKUP COLLECTION daily_backups (
    TABLE orders
) WITH (
    STORAGE = 'cluster',
    INCREMENTAL_BACKUP_ENABLED = 'true'
);
```

Creating a backup collection with multiple tables:

```yql
CREATE BACKUP COLLECTION production_backups (
    TABLE orders,
    TABLE products,
    TABLE customers
) WITH (
    STORAGE = 'cluster',
    INCREMENTAL_BACKUP_ENABLED = 'true'
);
```

## See also

* [Backup collections](https://ydb.tech/docs/en/concepts/datamodel/backup-collection.md).
* [BACKUP](https://ydb.tech/docs/en/yql/reference/syntax/backup.md).
* [RESTORE](https://ydb.tech/docs/en/yql/reference/syntax/restore-backup-collection.md).
* [DROP BACKUP COLLECTION](https://ydb.tech/docs/en/yql/reference/syntax/drop-backup-collection.md).