Database backups

Sometimes you might need to have a backup of your Cloud database. This can be accomplished directly on Umbraco Cloud.

Read more about the Backup and data retention policy on Umbraco Cloud in the FAQ.

Backup on Umbraco Cloud

On Umbraco Cloud, you can utilize our point-in-time recovery to create and download a bacpac file from your project.

Only Project Administrators have access to the Backups page on Umbraco Cloud.

To create a backup follow the steps below:

  1. Open your Cloud project.

  2. Go to Backups in the Settings menu.

  3. Click Create Backup.

    1. Enter a description for your backup.

    2. Choose the Environment from the Environment dropdown you want to create the backup from.

    3. Choose the Date and Time for the backup to be created.

  4. Click Create Backup.

When you click on the Create Backup button, the system will start creating a backup file in the form of a bacpac file. Once the bacpac file is created, you can download it by clicking on the download icon. In case you want to delete any of your backups, click on the delete icon.

Restoring a Cloud backup to a SQL Server Database

Use the following steps:

  • Connect to your SQL Server using SQL Server Management Studio (SSMS).

  • Expand "Databases", right-click "Databases", then select "Import Data-tier Application...".

  • Proceed through the dialog, by browsing to the saved location of your bacpac file, and then setting the options appropriate to your configuration

  • Complete the import dialog and the database will be restored.

If a bacpac restore fails in SQL server, ensure the 'Contained Database Authentication' flag is set to true for resolution.

If it is not set the import will fail.

To Enable Contained Database Authentication, run the following SQL against your SQL server on the Master database.

sp_configure 'contained database authentication', 1;  

For reference please see the Microsoft documentation on the topic.

Last updated