Skip to content

block-geo-redundant-backup-storage.md

Latest commit

 

History

History
55 lines (36 loc) · 3.71 KB

block-geo-redundant-backup-storage.md

File metadata and controls

55 lines (36 loc) · 3.71 KB
title Block Geo-Replication of Azure SQL Database Backups
description This article details a feature that allows Azure administrators to block geo-replication of Azure SQL Databases.
author SudhirRaparla
ms.author nvraparl
ms.reviewer nvraparl, wiassaf, mathoma
ms.date 06/13/2025
ms.service azure-sql-database
ms.subservice backup-restore
ms.topic how-to
ROBOTS NOINDEX
ms.custom sfi-image-nochange

What is Block Geo-replication of Azure SQL Database Backups feature?

[!INCLUDEappliesto-sqldb]

This feature allows Azure administrators to prevent Azure SQL Databases using geo-redundant storage options (RA-GRS, RA-GZRS) as preferred backup storage redundancy via T-SQL, Azure portal, PowerShell, Azure CLI and API. This is enforced at the subscription level to block geo-replication of Azure SQL database backups.

Overview

This feature prevents geo replication of Azure SQL Database backups by blocking all create, update database workflows that use read-access geo-redundant storage (RA-GRS) as the backup storage redundancy option. Azure SQL Database uses read-access geo-redundant storage (RA-GRS) as default backup storage redundancy when you create a new database, which automatically replicates the database backups to paired region. This feature blocks all the create and update database workflows that set backup storage redundancy to geo-redundant backup storage options like RA-GRS, RA-GZRS via T-SQL, Azure portal, PowerShell, Azure CLI and API. To create or update database successfully, users will have to manually select the backup storage redundancy based on data residency requirements.

You can register your subscription to this feature via Azure portal, PowerShell, or Azure CLI.

Permissions

In order to register or remove this feature, the Azure user must be a member of the Owner or Contributor role of the subscription.

Examples

The following section describes how you can register or unregister a preview feature with Microsoft.Sql resource provider in Azure portal:

Register Block Geo-replication of Azure SQL Database Backups

  1. Go to your subscription on Azure portal.

  2. Select the Preview Features tab.

  3. Select Azure SQL Database Block Geo-Redundant Backup Storage.

  4. After you select Azure SQL Database Block Geo-Redundant Backup Storage, a new window will open, select Register, to register this block with Microsoft.Sql resource provider.

    :::image type="content" source="media/block-geo-redundant-backup-storage/block-backup-geo-replication.png" alt-text="Screenshot of Block Geo-replication of Azure SQL Database Backups in the list of Preview features." lightbox="media/block-geo-redundant-backup-storage/block-backup-geo-replication.png":::

    :::image type="content" source="media/block-geo-redundant-backup-storage/block-backup-geo-replication-register.png" alt-text="Screenshot of Register Block Geo-replication of Azure SQL Database Backups feature." lightbox="media/block-geo-redundant-backup-storage/block-backup-geo-replication-register.png":::

Remove Block Geo-replication of Azure SQL Database Backups

To remove the block on geo-redundant backup storage from your subscription, unregister the previously registered Azure SQL Database Block Geo-Redundant Backup Storage feature.

Next step

[!div class="nextstepaction"] An overview of Azure SQL Database Backup storage redundancy