> ## Documentation Index
> Fetch the complete documentation index at: https://clickhouse.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# Review and restore backups
> Provides an overview of backups in ClickHouse Cloud
export const Image = ({img, alt, size = "lg"}) => {
const normalizedSize = ["sm", "md", "lg"].includes(size) ? size : "lg";
return
;
};
This guide covers how backups work in ClickHouse Cloud, what options you have to configure backups for your service, and how to restore from a backup.
**Prerequisites**
* You have read ["How backups work in ClickHouse Cloud"](/docs/products/cloud/features/backups/overview#how-backups-work-in-clickhouse-cloud) (Feature overview page)
Backup status list
Your service will be backed up based on the set schedule, whether it is the default daily schedule or a [custom schedule](/docs/products/cloud/guides/backups/configurable-backups) picked by you. All available backups can be viewed from the **Backups** tab of the service. From here, you can see the status of the backup, the duration, as well as the size of the backup. You can also restore a specific backup using the **Actions** column.
Understanding backup cost
Per the default policy, ClickHouse Cloud mandates a backup every day, with a 24 hour retention. Choosing a schedule that requires retaining more data, or causes more frequent backups can cause additional storage charges for backups.
To understand the backup cost, you can view the backup cost per service from the usage screen (as shown below). Once you have backups running for a few days with a customized schedule, you can get an idea of the cost and extrapolate to get the monthly cost for backups.
Estimating the total cost for your backups requires you to set a schedule. Before setting a schedule, you can use the [pricing calculator](https://clickhouse.com/pricing) to obtain a monthly cost estimate by providing the following inputs:
* Size of the full and incremental backups
* Desired backup frequency
* Desired backup retention
* Cloud provider and region
Keep in mind that the estimated cost for backups will change as the size of the data in the service grows over time.
Restore a backup
Backups are restored to a new ClickHouse Cloud service, not to the existing service from which the backup was taken.
After clicking on the **Restore** backup icon, you can specify the service name of the new service that will be created, and then restore this backup:
The new service will show in the services list as `Provisioning` until it is ready:
Working with your restored service
After a backup has been restored, you will now have two similar services: the **original service** that needed to be restored, and a new **restored service** that has been restored from a backup of the original.
Once the backup restore is complete, you should do one of the following:
* Use the new restored service and remove the original service.
* Migrate data from the new restored service back to the original service and remove the new restored service.
Use the **new restored service**
To use the new service, perform these steps:
1. Verify that the new service has the IP Access List entries required for your use case.
2. Verify that the new service contains the data that you need.
3. Remove the original service.
Migrate data from the **newly restored service** back to the **original service**
Suppose you can't work with the newly restored service for some reason, for example, if you still have users or applications that connect to the existing service. You may decide to migrate the newly restored data into the original service. The migration can be accomplished by following these steps:
**Allow remote access to the newly restored service**
The new service should be restored from a backup with the same IP Allow List as the original service. This is required as connections won't be allowed to other ClickHouse Cloud services unless you had allowed access from **Anywhere**. Modify the allow list and allow access from **Anywhere** temporarily. See the [IP Access List](/docs/products/cloud/guides/security/connectivity/setting-ip-filters) docs for details.
**On the newly restored ClickHouse service (the system that hosts the restored data)**
You will need to reset the password for the new service in order to access it. You can do that from the service list **Settings** tab.
Add a read only user that can read the source table (`db.table` in this example):
```sql theme={null}
CREATE USER exporter
IDENTIFIED WITH SHA256_PASSWORD BY 'password-here'
SETTINGS readonly = 1;
```
```sql theme={null}
GRANT SELECT ON db.table TO exporter;
```
Copy the table definition:
```sql theme={null}
SELECT create_table_query
FROM system.tables
WHERE database = 'db' AND table = 'table'
```
**On the destination ClickHouse Cloud system (the one that had the damaged table):**
Create the destination database:
```sql theme={null}
CREATE DATABASE db
```
Using the `CREATE TABLE` statement from the source, create the destination:
Change the `ENGINE` to `ReplicatedMergeTree` without any parameters when you run the `CREATE` statement. ClickHouse Cloud always replicates tables and provides the correct parameters.
```sql theme={null}
CREATE TABLE db.table ...
ENGINE = ReplicatedMergeTree
ORDER BY ...
```
Use the `remoteSecure` function to pull the data from the newly restored ClickHouse Cloud service into your original service:
```sql theme={null}
INSERT INTO db.table
SELECT *
FROM remoteSecure('source-hostname', db, table, 'exporter', 'password-here')
```
After you have successfully inserted the data into your original service, make sure to verify the data in the service. You should also delete the new service once the data is verified.
Undeleting or undropping tables
The `UNDROP` command is supported in ClickHouse Cloud through [Shared Catalog](/docs/products/cloud/features/infrastructure/shared-catalog).
To prevent users from accidentally dropping tables, you can use [`GRANT` statements](/docs/reference/statements/grant) to revoke permissions for the [`DROP TABLE` command](/docs/reference/statements/drop#drop-table) for a specific user or role.
To prevent accidental deletion of data, please note that by default it isn't possible to drop tables >`1TB` in size in ClickHouse Cloud.
Should you wish to drop tables greater than this threshold you can use setting `max_table_size_to_drop` to do so:
```sql theme={null}
DROP TABLE IF EXISTS table_to_drop
SYNC SETTINGS max_table_size_to_drop=2000000000000 -- increases the limit to 2TB
```
Legacy Plans: For customers on legacy plans, default daily backups retained for 24 hours, are included in the storage cost.
Backup durations
Backup and restore durations depend on several factors such as the size of the database as well as the schema and the number of tables in the database.
Incremental backups will usually complete much faster than a full backup as less data is being backed up.
Restoring from an incremental backup will be slightly slower than restoring from a full backup as all incremental backups and the last full backup in the chain are included in the restore as explained above.
In our testing, we have seen that smaller backups of \~1 TB could take around 10-15 minutes or longer to back up.
Backups less than 20 TB should complete within an hour, and backing up 50 TB of data should take about 2-3 hours.
Backups get economies of scale at larger sizes, and we have seen backups of up to 1 PB for some internal services complete in about 10 hours.
Backups to external buckets may be slower than backups to ClickHouse buckets
Restore durations are about the same as the backup durations.
We recommend testing with your own database or sample data to get better estimates as the actual duration depends on several factors as outlined above.
Configurable backups
If you want to set up a backups schedule different from the default backup schedule, take a look at [Configurable Backups](/docs/products/cloud/guides/backups/configurable-backups).
Export backups to your own cloud account
For users wanting to export backups to their own cloud account, see [here](/docs/products/cloud/guides/backups/bring-your-own-backup/export-backups-to-own-cloud-account).