I want to know how to back up and restore the database data of Pleasanter installed on Azure.
Answer¶
The "Backup" of Azure SQL Database is performed automatically on Azure, so manual backup is not required.
Overview¶
The backup of Azure SQL Database is performed automatically on Azure, so manual backup is not required. For details, please refer to the Microsoft documentation below.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automated-backups
For DB restoration procedures, please refer to the Microsoft documentation below.
・How to restore from Azure Portal
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-recovery-using-backups
・How to restore using SQL Server Management Studio
https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-database-backup-using-ssms?view=sql-server-ver16#examples
Also, if the version of Pleasanter is different when the backup is taken and after the restore, you may need to upgrade Pleasanter.
Please refer to "Pleasanter Version Upgrade Procedure (Azure App Service)" for the upgrade procedure.