# RESTORE REDUNDANCY

Restore redundancy by replicating any partitions with only one instance.

## Syntax

```sql
RESTORE REDUNDANCY ON db_name

```

## Remarks

* `db_name` is the name of a SingleStore database.
* Similarly, `REBALANCE PARTITIONS` restores redundancy by replicating any partitions with only one instance. However, `REBALANCE PARTITIONS` then does the additional step of moving partitions around to ensure balance across all the leaves.
* This command causes implicit commits. Refer to [COMMIT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/commit.md) for more information.
* [Node Requirements for SingleStore Commands](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md)
* This command cannot be run on [system databases](https://docs.singlestore.com/db/v9.1/reference/system-databases.md).
* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permissions.

## Example

```sql
RESTORE REDUNDANCY on memsql_demo;

```

```output

Query OK, 1 row affected (2.89 sec)

```

***

Modified at: July 31, 2023

Source: [/db/v9.1/reference/sql-reference/cluster-management-commands/restore-redundancy/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/restore-redundancy/)

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