az sql stg

Manage Server Trust Groups.

Commands

az sql stg create

Create a Server Trust Group.

az sql stg delete

Delete a Server Trust Group.

az sql stg list

Retrieve a list of Server Trust Groups.

az sql stg show

Retrieve a Server Trust Group.

az sql stg create

Create a Server Trust Group.

az sql stg create --group-member
                  --location
                  --name
                  --resource-group
                  --trust-scope
                  [--no-wait]
                  [--subscription]

Examples

Create a Server Trust Group with specified resource ids of its members.

az sql stg create -g resourcegroup -l location -n stg-name --trust-scope GlobalTransactions -m $mi1-id $mi2-id

Required Parameters

--group-member -m

Managed Instance that is to be a member of the group. Specify resource group, subscription id and the name of the instance.

--location -l

The location name of the Server Trust Group.

--name -n

The name of the Server Trust Group.

--resource-group -g

The resource group name.

--trust-scope

The trust scope of the Server Trust Group.

Optional Parameters

--no-wait

Do not wait for the long-running operation to finish.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

az sql stg delete

Delete a Server Trust Group.

az sql stg delete --location
                  --name
                  --resource-group
                  [--no-wait]
                  [--subscription]
                  [--yes]

Examples

Delete a Server Trust Group.

az sql stg delete -g resourcegroup -l location -n stg-name

Required Parameters

--location -l

The location of the Server Trust Group.

--name -n

The name of the Server Trust Group.

--resource-group -g

The resource group name.

Optional Parameters

--no-wait

Do not wait for the long-running operation to finish.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--yes -y

Do not prompt for confirmation.

az sql stg list

Retrieve a list of Server Trust Groups.

az sql stg list --resource-group
                [--instance-name]
                [--location]
                [--query-examples]
                [--subscription]

Examples

Retrieve a list of Server Trust Groups by instance.

az sql stg list -g resourcegroup --instance-name mi1-name

Retrieve a list of Server Trust Groups by location.

az sql stg list -g resourcegroup -l location

Required Parameters

--resource-group -g

The resource group name.

Optional Parameters

--instance-name

Managed Instance name.

--location -l

The location of the Server Trust Group.

--query-examples

Recommend JMESPath string for you. You can copy one of the query and paste it after --query parameter within double quotation marks to see the results. You can add one or more positional keywords so that we can give suggestions based on these key words.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

az sql stg show

Retrieve a Server Trust Group.

az sql stg show --location
                --name
                --resource-group
                [--query-examples]
                [--subscription]

Examples

Retrieve a Server Trust Group.

az sql stg show -g resourcegroup -l location -n stg-name

Required Parameters

--location -l

The location of the Server Trust Group.

--name -n

The name of the Server Trust Group.

--resource-group -g

The resource group name.

Optional Parameters

--query-examples

Recommend JMESPath string for you. You can copy one of the query and paste it after --query parameter within double quotation marks to see the results. You can add one or more positional keywords so that we can give suggestions based on these key words.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.