Search code examples
azurepowershelldata-warehouse

How to disable the Geo back up policy for an Azure datawarehouse through PowerShell?


How Can I disable the Geo back up policy for an Azure datawarehouse while it's being created or after using PowerShell?


Solution

  • If your data warehouse is Gen1, try the command as below, specific the -State with Disabled.

    Set-AzureRmSqlDatabaseGeoBackupPolicy

    If your data warehouse is Gen2, you cannot, geo-backups for Gen2 as data protection is a built-in guaranteed.

    See: https://learn.microsoft.com/en-us/azure/sql-data-warehouse/backup-and-restore#geo-backups