CmdID

CmdID / az / az sql / az sql elastic-pool

az sql elastic-pool update

Update an elastic pool. Azure CLI reference

4 examples 4 options Its page in the Azure CLI reference

Opens CmdID with your command. It is read in your browser and sent nowhere.

Examples

from the Azure CLI, each command read by CmdID

Update elastic pool with zone redundancy enabled

az sql elastic-pool update -g mygroup -s myserver -n mypool -zIdentify
-gName of resource group.
-sName of the Azure SQL Server.
-nThe name of the elastic pool.
-zSpecifies whether to enable zone redundancy.

Update elastic pool with zone redundancy explicitly disabled

az sql elastic-pool update -g mygroup -s myserver -n mypool -z falseIdentify
-gName of resource group.
-sName of the Azure SQL Server.
-nThe name of the elastic pool.
-zSpecifies whether to enable zone redundancy.

Update elastic pool with 2 high availability replicas

az sql elastic-pool update -g mygroup -s myserver -n mypool --ha-replicas 2Identify
-gName of resource group.
-sName of the Azure SQL Server.
-nThe name of the elastic pool.
--ha-replicasThe number of high availability replicas to provision for the database.

Update elastic pool with VBS enclave

az sql elastic-pool update -g mygroup -s myserver -n mypool --preferred-enclave-type VBSIdentify
-gName of resource group.
-sName of the Azure SQL Server.
-nThe name of the elastic pool.
--preferred-enclave-typeType of enclave to be configured for the elastic pool.

Options

4 in the Azure CLI reference
--database-dtu-maxThe maximum DTU any one database can consume.
--database-dtu-minThe minimum DTU all databases are guaranteed.
--preferred-enclave-typeType of enclave to be configured for the elastic pool.
--storage-mbStorage limit for the elastic pool in MB.