Sidebar navigationMain contentFooter
Jump toSuggest an edit

How to manage Database snapshots

Reviewed on 18 December 2023Published on 10 March 2021

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).

Security & Identity (IAM)

To perform certain actions described below, you must either be the Owner of the Organization in which the actions will be performed, or an IAM user with the necessary permissions.

Requirements
  • You have an account and are logged into the Scaleway console
  • You have a PostgreSQL or MySQL Database Instance

How to create snapshots

  1. Go to the Snapshots tab of your Database Instance of choice.
  2. Click + Create snapshot.
    Important

    Make sure your Instance is in READY state before creating a snapshot.

    A pop-up displays.
  3. Enter a name for your snapshot and set up the expiration date and time.
    Note

    The default retention period for snapshots is 365 days.

  4. 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.

  1. Go to the Snapshots tab of your Database Instance of choice.

  2. Click the «See more Icon» next to the name of the snapshot.

  3. Click Create Database Instance from snapshot. A pop-up appears.

  4. Enter a name for your new Instance.

  5. Choose a node type and configuration.

    Important

    It is possible to select a different (larger or smaller) node type for your new Instance. However, the block volume size will be the same as the size of the restored snapshot. All Instance settings will be restored if you chose a node type with the same or more memory size than the initial Instance. Settings will be reset to the default if your node type has less memory.

  6. 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.

  1. Go to the Snapshots tab of your Database Instance of choice.
  2. Click «See more Icon» next to the name of the snapshot.
  3. Click Delete. A pop-up displays to warn you that:
    Important

    This action is irreversible and will permanently destroy your snapshot and all its data.

  4. Type DELETE and click Delete snapshot if you wish to continue.
See also
How to manage manual backupsHow to clone a Database Instance
Cloud Products & Resources
  • Scaleway Console
  • Compute
  • Storage
  • Network
  • IoT
  • AI
Dedicated Products & Resources
  • Dedibox Console
  • Dedibox Servers
  • Network
  • Web Hosting
Scaleway
  • Scaleway.com
  • Blog
  • Careers
  • Scaleway Learning
Scaleway Docs
Follow us
FacebookTwitterSlackInstagramLinkedin
ContractsLegal NoticePrivacy PolicyCookie PolicyDocumentation license
© 1999-2024 – Scaleway SAS