Skip to content

az sql db update succeeds but service objective is not updated #26665

Description

@nosalan

Describe the bug

I cannot change service objective from GP_Gen5_10 to GP_S_Gen5_2. The command succeeds but the service objective remains unchanged on the database. The database is still GP_Gen5_10 after the command is run. See command output for details.

Related command

 az sql db update --subscription $SubscriptionId `
  --resource-group $ResourceGroupName `
  --server $ServerName `
  --name $DatabaseName `
  --service-objective GP_S_Gen5_2 --debug

Errors

No errors.

Issue script & Debug output

PS C:\path> az sql db update --subscription --resource-group <redacted>
--server --name <redacted>
--service-objective GP_S_Gen5_2 --debug

Expected behavior

Service Objective is updated.

Environment Summary

{
"azure-cli": "2.49.0",
"azure-cli-core": "2.49.0",
"azure-cli-telemetry": "1.0.8",
"extensions": {
"azure-devops": "0.26.0",
"bastion": "0.2.4",
"k8s-extension": "1.4.1"
}
}

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    Auto-AssignAuto assign by botSQLaz sqlService AttentionThis issue is responsible by Azure service team.act-codegen-extensibility-squadbugThis issue requires a change to an existing behavior in the product in order to be resolved.customer-reportedIssues that are reported by GitHub users external to the Azure organization.

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions