az sql vm group
Manage SQL virtual machine groups.
Commands
Name | Description | Type | Status |
---|---|---|---|
az sql vm group ag-listener |
Manage SQL availability group listeners. |
Core | GA |
az sql vm group ag-listener create |
Creates an availability group listener. |
Core | GA |
az sql vm group ag-listener delete |
Deletes an availability group listener. |
Core | GA |
az sql vm group ag-listener list |
Lists all availability group listeners in a SQL virtual machine group. |
Core | GA |
az sql vm group ag-listener show |
Gets an availability group listener. |
Core | GA |
az sql vm group ag-listener update |
Updates an availability group listener. |
Core | GA |
az sql vm group create |
Creates a SQL virtual machine group. |
Core | GA |
az sql vm group delete |
Deletes a SQL virtual machine group. |
Core | GA |
az sql vm group list |
Lists all SQL virtual machine groups in a resource group or subscription. |
Core | GA |
az sql vm group show |
Gets a SQL virtual machine group. |
Core | GA |
az sql vm group update |
Updates a SQL virtual machine group if there are not SQL virtual machines attached to the group. |
Core | GA |
az sql vm group create
Creates a SQL virtual machine group.
az sql vm group create --domain-fqdn
--image-offer
--image-sku {Developer, Enterprise}
--name
--operator-acc
--resource-group
--service-acc
--storage-account
[--bootstrap-acc]
[--cluster-subnet-type {MultiSubnet, SingleSubnet}]
[--fsw-path]
[--location]
[--ou-path]
[--sa-key]
[--tags]
Examples
Create a SQL virtual machine group for SQL2016-WS2016 Enterprise virtual machines.
az sql vm group create -n sqlvmgroup -l eastus -g myresourcegroup --image-offer SQL2016-WS2016 --image-sku Enterprise --domain-fqdn Domain.com --operator-acc testop --service-acc testservice --sa-key {PublicKey} --storage-account 'https://storacc.blob.core.windows.net/'
Create a SQL virtual machine group for SQL2019-WS2022 Enterprise virtual machines with MultiSubnet.
az sql vm group create -n sqlvmgroup -l eastus -g myresourcegroup --image-offer SQL2019-WS2022 --image-sku Enterprise --cluster-subnet-type MultiSubnet --domain-fqdn Domain.com --operator-acc testop --service-acc testservice --sa-key {PublicKey} --storage-account 'https://storacc.blob.core.windows.net/'
Required Parameters
Fully qualified name of the domain.
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
SQL image offer. Examples may include SQL2016-WS2016, SQL2017-WS2016.
Property | Value |
---|---|
Parameter group: | SQL Server License Arguments |
SQL image sku.
Property | Value |
---|---|
Parameter group: | SQL Server License Arguments |
Accepted values: | Developer, Enterprise |
Name of the SQL virtual machine group.
Account name used for operating cluster i.e. will be part of administrators group on all the participating virtual machines in the cluster.
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Account name under which SQL service will run on all participating SQL virtual machines in the cluster.
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
Storage account url of the witness storage account.
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
Optional Parameters
The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.
Account name used for creating cluster (at minimum needs permissions to 'Create Computer Objects' in domain).
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
Cluster subnet type.
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
Default value: | SingleSubnet |
Accepted values: | MultiSubnet, SingleSubnet |
Optional path for fileshare witness.
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
Location. If not provided, group will be created in the same reosurce group location.You can configure the default location using az configure --defaults location=<location>
.
Organizational Unit path in which the nodes and cluster will be present. Example: OU=WSCluster,DC=testdomain,DC=com.
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
Primary key of the witness storage account.
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
Space-separated tags: key[=value] [key[=value] ...]. Use "" to clear existing tags.
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |
az sql vm group delete
Deletes a SQL virtual machine group.
az sql vm group delete [--ids]
[--name]
[--resource-group]
[--subscription]
[--yes]
Optional Parameters
The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.
One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Name of the SQL virtual machine group.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Do not prompt for confirmation.
Property | Value |
---|---|
Default value: | False |
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |
az sql vm group list
Lists all SQL virtual machine groups in a resource group or subscription.
az sql vm group list [--resource-group]
Optional Parameters
The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |
az sql vm group show
Gets a SQL virtual machine group.
az sql vm group show [--ids]
[--name]
[--resource-group]
[--subscription]
Optional Parameters
The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.
One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Name of the SQL virtual machine group.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |
az sql vm group update
Updates a SQL virtual machine group if there are not SQL virtual machines attached to the group.
az sql vm group update [--add]
[--bootstrap-acc]
[--cluster-subnet-type {MultiSubnet, SingleSubnet}]
[--domain-fqdn]
[--force-string]
[--fsw-path]
[--ids]
[--name]
[--operator-acc]
[--ou-path]
[--remove]
[--resource-group]
[--sa-key]
[--service-acc]
[--set]
[--storage-account]
[--subscription]
[--tags]
Examples
Update an empty SQL virtual machine group operator account.
az sql vm group update -n sqlvmgroup -g myresourcegroup --operator-acc testop
Update an empty SQL virtual machine group storage account and key.
az sql vm group update -n sqlvmgroup -g myresourcegroup --sa-key {PublicKey} --storage-account 'https://newstoracc.blob.core.windows.net/'
Optional Parameters
The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.
Add an object to a list of objects by specifying a path and key value pairs. Example: --add property.listProperty <key=value, string or JSON string>
.
Property | Value |
---|---|
Parameter group: | Generic Update Arguments |
Default value: | [] |
Account name used for creating cluster (at minimum needs permissions to 'Create Computer Objects' in domain).
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
Cluster subnet type.
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
Accepted values: | MultiSubnet, SingleSubnet |
Fully qualified name of the domain.
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
When using 'set' or 'add', preserve string literals instead of attempting to convert to JSON.
Property | Value |
---|---|
Parameter group: | Generic Update Arguments |
Default value: | False |
Optional path for fileshare witness.
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Name of the SQL virtual machine group.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Account name used for operating cluster i.e. will be part of administrators group on all the participating virtual machines in the cluster.
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
Organizational Unit path in which the nodes and cluster will be present. Example: OU=WSCluster,DC=testdomain,DC=com.
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
Remove a property or an element from a list. Example: --remove property.list <indexToRemove>
OR --remove propertyToRemove
.
Property | Value |
---|---|
Parameter group: | Generic Update Arguments |
Default value: | [] |
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Primary key of the witness storage account.
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
Account name under which SQL service will run on all participating SQL virtual machines in the cluster.
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
Update an object by specifying a property path and value to set. Example: --set property1.property2=<value>
.
Property | Value |
---|---|
Parameter group: | Generic Update Arguments |
Default value: | [] |
Storage account url of the witness storage account.
Property | Value |
---|---|
Parameter group: | WSFC Domain Profile Arguments |
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Space-separated tags: key[=value] [key[=value] ...]. Use "" to clear existing tags.
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |