# SYNC BOTTOMLESS DATABASE

Synchronizes any currently committed data in the database with the remote object storage.

## Syntax

```
SYNC BOTTOMLESS DATABASE <database_name>;
```

## Remarks

* This command applies only to universal storage databases.
* You must specify the name of the database to synchronize in the command.
* You must have either the `SUPER` or `BACKUP` privilege to run this command.
* This command causes implicit commits. See [COMMIT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/commit.md) for more information.
* This command can be run on the master aggregator, or on the child aggregators provided DDL forwarding is enabled.&#x20;
* SingleStore recommends using this command to flush all the data to remote object storage before a large or critical operation.

## Example

```
SYNC BOTTOMLESS DATABASE db01;
```

***

Modified at: March 7, 2025

Source: [/db/v9.1/reference/sql-reference/operational-commands/sync-bottomless-database/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/sync-bottomless-database/)

(An index of the documentation is available at /llms.txt)
