Skip to content

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

@nosalan

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

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions