---
metadata:
  - name: generator
    content: Diplodoc Platform v5.52.0
alternate:
  - https://ydb.tech/docs/en/recipes/backup-collections/getting-started.md?version=v26.1
  - https://ydb.tech/docs/ru/recipes/backup-collections/getting-started.md?version=v26.1
  - href: en/recipes/backup-collections/getting-started.md
    type: text/markdown
    title: Markdown version
  - href: ../../llms.txt
    type: text/markdown
    title: llms.txt
sourcePath: en/core/recipes/backup-collections/getting-started.md
---
> **Documentation Index:** Fetch the complete configuration index at https://ydb.tech/docs/en/llms.txt

# Creating Your First Backup Collection

This guide walks you through creating a backup collection, taking your first backups, and monitoring backup operations.

## Creating a backup collection

A backup collection is a [schema object](https://ydb.tech/docs/en/concepts/datamodel/index.md?version=v26.1) stored in the database schema. You create and manage collections using SQL statements, and browse them using schema navigation commands (like `ydb scheme ls`) since they appear as directories in the database structure.

Create a collection that includes the tables you want to back up together:

```sql
-- Create a collection for related tables
CREATE BACKUP COLLECTION production_backups
    ( TABLE orders
    , TABLE products
    , TABLE customers
    )
WITH ( STORAGE = 'cluster', INCREMENTAL_BACKUP_ENABLED = 'true' );
```

## Taking backups

After creating the collection, take an initial full backup, then use incremental backups for subsequent operations:

```sql
-- Take initial full backup
BACKUP production_backups;

-- Make changes to your data...
-- INSERT, UPDATE, or DELETE operations on backed-up tables

-- Later, take incremental backups to capture the changes
BACKUP production_backups INCREMENTAL;
```

{% note info %}

Backup operations run asynchronously and are not idempotent — each `BACKUP` command creates a new backup. Before retrying after a timeout, check operation status with `ydb operation list incbackup`.

{% endnote %}

## Monitoring backup operations

Track backup progress and browse your backup structure:

```bash
# Check backup operation status
ydb operation list incbackup

# Get details for specific operation
ydb operation get <operation-id>

# Browse backup collections
ydb scheme ls .backups/collections/

# List backups in a collection
ydb scheme ls .backups/collections/production_backups/
```

## Next steps

- [Setting Up Backups for Multiple Environments](https://ydb.tech/docs/en/recipes/backup-collections/multi-environment-setup.md?version=v26.1)
- [Exporting Backups to External Storage](https://ydb.tech/docs/en/recipes/backup-collections/exporting-to-external-storage.md?version=v26.1)
- [Validating and Testing Backups](https://ydb.tech/docs/en/recipes/backup-collections/validation-and-testing.md?version=v26.1)
