1. Articles
  2. Platform as a Service
  3. Managed Databases
  4. General Guides

Articles in this section

See more

Cloud Databases - Restore a Backup

Avatar
Stephanie R.
  • Updated

Learn how to restore a backup of a database solution in the OVHcloud Control Panel.

Managed Databases (also called Cloud Databases) allow you to focus on building and deploying cloud applications while OVHcloud takes care of the database infrastructure and maintenance.

We continuously improve our offers. You can follow and submit ideas to add to our roadmap.

 

Requirements

 

Instructions

Step 1: Select the database service you want to restore data from

First, go to the service overview page from which you want to restore the backup.

DBaaS_restore_backup01**.png

 

Step 2: Go to the backup tab

Click on the Backups tab.

DBaaS_restore_backup02**.png

 

Step 3: Select the backup to restore from

Select the backup from which you want to restore. To help you choose, observe the dates at which the backups have been performed in the Creation date column.

Click on the more options ... button in the row of the chosen backup. Then click on Duplicate (Fork) to go to the configuration page of the new service.

DBaaS_restore_backup03*.png

 

Step 4: Configure the target service

As seen before, when restoring a backup you create a new separate database service on which the backup data will be imported. You can configure this new service as you wish.

Immutable options

For obvious reasons, you cannot change the engine, this option is not offered. The same goes for the engine version, you will be able to update it once the new service is running.

You will find a reminder of all these options in the order summary.

DBaaS_restore_backup04.png

 

Region

You can choose a different region for your new service.

DBaaS_restore_backup04.5*.png

 

Restore point

Choose a restore point from which the service will be duplicated.

Backup

The most common option is to restore from a backup.

DBaaS_restore_backup05.png

Specific date and latest

If your service supports point in time recovery (see our Cloud Databases - Automated Backups guide for more details), you will also be offered the option to restore from a specific date and time.

DBaaS_restore_backup06*.png

 

You will also be offered the ease of choosing the most recent date.

DBaaS_restore_backup07.png

 

Plan

When restoring a backup you can select another service plan.

DBaaS_restore_backup08.png

 

Nodes

You can choose to upgrade the node to a bigger flavor.

DBaaS_restore_backup09.png

The flavor downgrade will soon be offered. The limitation is that the targeted flavor must have enough storage to restore the backup.

 

Sizing

Additional storage can be ordered while forking the service.

DBaaS_restore_backup10.png

The storage reduction will soon be offered. The limitation is that the targeted total storage must be large enough to restore the backup.

 

Options

You can update the network options.

DBaaS_restore_backup11.png

Now click on Create a fork and the new service will be created. Please note that depending on the backup size it can take some time before the service is available.

 

Step 5: Wait for service creation

You now just have to wait for your service to be ready. This new service is now completely independent from the one you forked the backup from. You can safely delete the old service without impacting the new one.

NOTE: The newly created service does not duplicate IP restrictions or users that were created on the old service. You will have to recreate those before using your new service.

DBaaS_restore_backup12*.png

 

Go further

For more information and tutorials, please see our other Cloud Databases support guides or explore the guides for other OVHcloud products and services.

Related articles