Azure / Azure/azure-cli

az sql db update doesn't work if --edition Basic --service-objective Basic

Open
#31,456 3 comments 0 reactions 0 assignees View on GitHub
act-codegen-extensibility-squad needs-triage Service Attention SQL
Dominant language
Python
Stars
4.6k
Forks
3.5k
Avg merge
3d 2h
Merged PRs (30d)
60

Description

### Type of issue

Code doesn't work

### Reference command name

I use `az sql db update` quite a lot as I have a script that scale databases.

I have no problem running it and scale Azure SQL Database to whatever tier like:

`az sql db update -s MyServer -g MyResourceGroup -n MyDatabase --edition Standard --service-objective S2 --subscription "MySubscription"`

Problems arrive when I run something like:

`az sql db update -s MyServer -g MyResourceGroup -n MyDatabase --edition Basic --service-objective Basic --subscription "MySubscription"`

In that case the database won't scale and returns the error:

`Error | ERROR: (InvalidMaxSizeTierCombination) The tier 'Basic' does not support the database max size '268435456000'.`

But then I scale from `S0` to `Basic` form the Portal and everything works fine.

You don't believe it?

Look at this picture

![Image](https://github.com/user-attachments/assets/779ca784-752b-4ab4-8c99-bcc47db55f0b)

### Feedback

There is a bug in the AZ SQL module when scaling to Basic.
For all other edition and tier there is no problem

### Page URL

https://learn.microsoft.com/en-us/cli/azure/sql/db?view=azure-cli-latest#az-sql-db-update

### Content source URL

https://github.com/MicrosoftDocs/azure-docs-cli/blob/main/docs-ref-autogen/Latest-version/latest/sql/db.yml

### Author

@mikefrobbins

### Document Id

4c91220f-45c6-84de-2473-07c1cd296beb

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.