Sitecore customers can request to set up long-term backup retention (LTR) for SQL database in Elastic pool by providing the data described in the following section through the appropriate request using https://support.sitecore.net.
More information about LTR can be found here:
https://docs.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure
| Parameter |
Description |
Value |
| Database |
The database to set up LTR for. |
|
| LTR Time basis |
How often the backup is created. |
Weekly, Monthly, or Yearly |
| Desired Backup Retention |
Number of days to keep each single backup copy. |
Number of days |
-
- Out-of-the-box SQL databases in Azure have a set of backups configured by default:
- Full backup (every week).
- Differential backups (store differences between the last backup and the current state of the database, every 12-24 hours).
- Transaction log backups (every 5-10 minutes).
You can find more information about automated backups here: https://docs.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview?tabs=single-database
- A customer or Sitecore can trigger any backup recovery operation for the SQL databases by submitting a service request on the Sitecore Support Portal. After the backup recovery has been done, the customer is responsible to do any post configuration and/or cleanup. Therefore, the customer must ensure the integrity of the restored data. We recommend that customers regularly test restoration as a part of normal business continuity planning.
- You can find information about how to request restoring SQL DB from the backup here: KB0676487