Sitefinity Cloud provides different database operations out-of-the-box. Automated backups of the database on each environment are created every minute, .bacpac files can be used to export/import a database, and databases can be restored from one environment to another on demand. For more information about.bacpac files, see Microsoft documentation » BACPAC.
.bacpac
IMPORTANT: Sitefinity Cloud uses Azure SQL Database service. When you make a backup of your database, it is always made using the latest stable Enterprise Edition of SQL server. Keep this in mind when considering compatibility with your local version of SQL server you are restoring the database backup to.
Automated backups of the production website database are made every minute. These backups are kept for a period of 35 days, enabling you to restore your website database to a desired point in time within that period. You can request a restoration to a point in time by contacting the Sitefinity support team.
NOTE: Automated backups are not made available for development purposes. They are setup for disaster recovery and emergency data restoration purposes only. If you need a database backup for development purposes refer to the Database backups for development and On-demand database backups sections further in this article.
Automated backups of the Sitefinity Cloud environment database are made weekly. You can access these database backups and restore them locally for development and testing purposes. For further instructions on obtaining and restoring a database backup for development follow the instructions provided in the Restore a database backup locally paragraph further in this article.
A backup of the project’s database can be exported on demand. To do this, the developer triggers a pipeline to export a backup. This process creates a backup, which is used for development and testing purposes.
To create a backup of the project database, perform the following:
DB.Export
NOTE: To protect sensitive data, use an obfuscated copy of the database. For more information, see Setup PII data obfuscation.
Database backups are stored in a dedicated storage account that you can access. To restore a database backup on your local machine follow these steps:
.backpac
The Sitefinity Cloud environments have been isolated to create a safe mechanism for deploying and testing code changes, while content editing on the production environment remains uninterrupted. The environments use separate databases. Use this procedure to restore a database from one environment to another.
To make a copy of the latest Production database and restore it on Staging for testing or upgrade purposes, perform the following:
DB.RestoreBetweenEnvironments
To submit feedback, please update your cookie settings and allow the usage of Functional cookies.
Your feedback about this content is important