How to manage Database snapshots
Snapshots allow you to restore data in a new Database Instance, instead of creating individual automated database backups. It is only available for Database Instances that use Block Storage volumes.
When you set up autobackups for Database Instances that use Block Storage, the automatic backups are created in snapshot format.
You can have up to 100 snapshots per Instance and Project (depending on quotas).
Before you start
To complete the actions presented below, you must have:
- A Scaleway account logged into the console
- Owner status or IAM permissions allowing you to perform actions in the intended Organization
- A PostgreSQL or MySQL Database Instance
How to create snapshots
- Go to the Snapshots tab of your Database Instance of choice.
- Click + Create snapshot. A pop-up displays.
- Enter a name for your snapshot and set up the expiration date and time.
- Click Create snapshot to confirm.
How to create a Database Instance from a snapshot
You can restore the data contained in a snapshot to a Database Instance. When you do so, a new Database Instance is created and billed to your account.
-
Go to the Snapshots tab of your Database Instance of choice.
-
Click the more icon next to the name of the snapshot.
-
Click Create Database Instance from snapshot. A pop-up appears.
-
Enter a name for your new Instance.
-
Choose a node type and configuration.
-
Click Create Database Instance to confirm.
You can see the new Instance in your Database Instances list.
How to delete snapshots
When you delete an Instance, its associated snapshots are not deleted. Snapshots can be manually deleted or will be deleted after the retention period defined.
If you do not wish to wait for the snapshot to expire, you can delete it manually.
- Go to the Snapshots tab of your Database Instance of choice.
- Click more icon next to the name of the snapshot.
- Click Delete. A pop-up displays to warn you that:
- Type DELETE and click Delete snapshot if you wish to continue.