Backup of Azure Database
In Microsoft Azure Database, Backup happen automatically as part of the service, but the retention period of the Backup is as per the selected DB Service tier.
Retention Period of MS Azure Database
Important Points:
1. In Microsoft Azure, Backups are Geo-Replicated so that:-
a. Backups are replicated to a paired Azure region by the Service.
b. In the event of the region outage, you can restore your backup to another region.
2. All databases support point-in-time recovery with a 12 hour RTO and 5 minute RPO for the in-region backups.
3. Azure provides 2x your max storage size as included backup storage. For E.g, a Standard database has up to 500GB of backup space included.
When reaching to backup storage limit,
a. Reduce the retention period by contacting Azure support.
b. Pay for extra backup storage billed at the standard Read-Access Geographically Redundant Storage rate.
4. For Archiving Backup files,
a. Manually export the database to BACPAC and keep copies on Azure Blob Storage.
b. Use Long-Term-Retention to Azure Backup Vault
5. After deleting Backup files,
a. If you delete a database, you can restore as long as you're still inside the retention period.
b. If you delete the server, all backups are deleted with no restore capability.
your post is the very organized way and easily understandable. Doing a good job. Thank you for sharing this content.
ReplyDeleteaws training in chennai with placement | best aws training in chennai | aws certification exam centers in chennai