Database backups are an essential part of any business continuity and disaster recovery strategy, because they protect your data from corruption or deletion. In Azure SQL there are two types of automated backups that customers can use for restoring their databases:
To protect backup data from planned and unplanned events, including transient hardware failures, network or power outages, and massive natural disasters, backup storage is being replicated to another storage. By default, storage is geo-replicated to a paired region using RA-GRS strategy.
As many applications have regulatory, compliance, or other business requirements for data residency control, geo-redundancy is not good fit for every customer. To overcome this, option for configuring backup storage redundancy has been introduced to Azure SQL Managed Instance (coming soon to Azure SQL DB). It allows customers to choose replication strategy for their backup storages and define if geo-redundancy (RA-GRS), zone-redundancy (ZRS), or local-redundancy (LRS) will be used.
Backup storage redundancy relies on Azure Storage redundancy:
While LRS and GRS are available in all regions, ZRS is available only in specified regions. Detailed pricing information can be found on Azure SQL Managed Instance pricing page and Azure SQL DB pricing page.
Backup storage redundancy option is in Preview phase. Main capabilities are following:
Managed instance limitations:
Backup storage redundancy can be configured during creation when request is submitted using REST API, PowerShell, Azure CLI, ARM template or Azure Portal. In official documentation page, you can find instructions on how to select backup storage redundancy.
It is not possible to update backup storage redundancy for existing instances. However, there is workaround which relies on process of creating new managed instance with different redundancy and moving your databases from old to the new instance.
Backups are kept until retention period set for each database expires + 7 days. For more details visit Backup storage consumption on Managed Instance explained. If you have need for immediate removal of backup data stored on old instance before deleting it you can:
These two actions will ensure that all your data is removed from the old managed instance in up to 8 days.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.