Database Backup

Database Backup

In Cloudvanti Sitefinity we provide you a pipeline to backup your website database. The pipeline for the Staging and Production database is different but the process is the same.

Here is the backup database process:

1. User create new release in <subscription-name>-DB-Backup-<PRD/STG>.CD pipeline. This will run the DB Backup Pipeline.
2. The primary database will be copied to the secondary database.
3. The secondary database will be exported to Azure storage. After the database is exported, the secondary database will be deleted.
   

For the exported database to be transactionally consistent, you must ensure either that no write activity is occurring during the export, or that you are exporting from a transactionally consistent copy of your database.

You can backup the latest database from staging and production with these steps:

1. Navigate to Pipelines >> Releases.
2. For backup database from:
   Staging select: <subscription-name>-DB-Backup-STG.CD.
   Production select: <subscription-name>-DB-Backup-PRD.CD.
   
   For this example, we use the backup for the Production database.
3. Click the Create release button at the top right side.
4. Fill the form Release Description, you can fill it with the reason why you want to backup the database.
5. Your database backup stored in Azure Storage Account in System Folder as a .bacpac extension. The folder can be accessed from here.
   
   For more detail see this section.
   
6. Choose Staging or Production Folder.
   
   
7. Choose db-backup folder
   
   
8. The name of the Backup file is the same as the release name.
   
   
   
9. Click the button on the right -> download to download the backup file