[BUG] Provisioning of zone redundant Hyperscale database with geo backup redundancy is not supported. Zone redundant Hyperscale databases must use either zone or geo zone backup redundancy.

[kaibocai]

trafficstars

Library name and version

Azure.ResourceManager.Sql Version="1.3.0-beta.4"

Describe the bug

I use below code to create elastic pool and sql database

create elastic pool

  var data = new ElasticPoolData(new AzureLocation(location))
  {
      Sku = new SqlSku("HS_PRMS")
      {
          Tier = "Hyperscale",
          Capacity = this.sqlElasticPoolConfig.Capacity,
      },
      PerDatabaseSettings = new ElasticPoolPerDatabaseSettings()
      {
          MinCapacity = this.sqlElasticPoolConfig.PerDatabaseMinCapacity,
          MaxCapacity = this.sqlElasticPoolConfig.PerDatabaseMaxCapacity,
      },
      IsZoneRedundant = true,
  };
  var lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, elasticPoolName, data);
  var result = lro.Value;

create database

        var data = new SqlDatabaseData(new AzureLocation(location))
        {
            ElasticPoolId = new ResourceIdentifier(elasticPoolId),
            IsZoneRedundant = true,
        };
        var lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
        var result = lro.Value;

I encounter error

Provisioning of zone redundant Hyperscale database with geo backup redundancy is not supported. Zone redundant Hyperscale databases must use either zone or geo zone backup redundancy.

whereas I can create a database with zone redundant set to true successfully from portal.

Expected behavior

The database should be created successfully without error

Actual behavior

Error out:

Provisioning of zone redundant Hyperscale database with geo backup redundancy is not supported. Zone redundant Hyperscale databases must use either zone or geo zone backup redundancy.

Reproduction Steps

Create a hpersacle elasticpool and set IsZoneRedundant to true and try to create a database on it also with IsZoneRedundant set to true.

Environment

.NET SDK: Version: 8.0.302 Commit: ef14e02af8 Workload version: 8.0.300-manifests.ca8b4b2d MSBuild version: 17.10.4+10fbfbf2e

Runtime Environment: OS Name: Windows OS Version: 10.0.22631 OS Platform: Windows RID: win-x64 Base Path: C:\Program Files\dotnet\sdk\8.0.302\

.NET workloads installed: [aspire] Installation Source: VS 17.10.35004.147 Manifest Version: 8.0.0/8.0.100 Manifest Path: C:\Program Files\dotnet\sdk-manifests\8.0.100\microsoft.net.sdk.aspire\8.0.0\WorkloadManifest.json Install Type: FileBased

Host: Version: 8.0.6 Architecture: x64 Commit: 3b8b000a0e

[jsquire]

Thank you for your feedback. Tagging and routing to the team member best able to assist.

[HarveyLink]

We could get this done by the following code:

var serverData = new SqlServerData(AzureLocation.AustraliaEast)
{
    AdministratorLogin = "dummylogin",
    AdministratorLoginPassword = "Password01!!"
};
var server = (await resourceGroup.GetSqlServers().CreateOrUpdateAsync(WaitUntil.Completed, "name", serverData)).Value;

var poolData = new ElasticPoolData(AzureLocation.AustraliaEast)
{
    Sku = new SqlSku("HS_PRMS")
    {
        Tier = "Hyperscale",
        Capacity = 4,
    },
    PerDatabaseSettings = new ElasticPoolPerDatabaseSettings()
    {
        MinCapacity = 0.25,
        MaxCapacity = 2,
    },
    IsZoneRedundant = true,
};
var pool = (await server.GetElasticPools().CreateOrUpdateAsync(WaitUntil.Completed, "name", poolData)).Value;

var dbData = new SqlDatabaseData(AzureLocation.AustraliaEast)
{
    ElasticPoolId = pool.Id,
    IsZoneRedundant = true,
    RequestedBackupStorageRedundancy = SqlBackupStorageRedundancy.Zone,
};
var db = (await server.GetSqlDatabases().CreateOrUpdateAsync(WaitUntil.Completed, "name", dbData)).Value;