az sql server

Manage SQL servers.

Commands

Name Description Type Status
az sql server ad-admin

Manage a server's Active Directory administrator.

Core GA
az sql server ad-admin create

Create a new server Active Directory administrator.

Core GA
az sql server ad-admin delete

Sets a server's AD admin.

Core GA
az sql server ad-admin list

Gets a list of Azure Active Directory administrators in a server.

Core GA
az sql server ad-admin update

Update an existing server Active Directory administrator.

Core GA
az sql server ad-only-auth

Manage Azure Active Directory only Authentication settings for this Server.

Core GA
az sql server ad-only-auth disable

Disable Azure Active Directory only Authentication for this Server.

Core GA
az sql server ad-only-auth enable

Enable Azure Active Directory only Authentication for this Server.

Core GA
az sql server ad-only-auth get

Get a specific Azure Active Directory only Authentication property.

Core GA
az sql server advanced-threat-protection-setting

Manage a server's advanced threat protection setting.

Core GA
az sql server advanced-threat-protection-setting show

Gets an advanced threat protection setting.

Core GA
az sql server advanced-threat-protection-setting update

Update a server's advanced threat protection setting.

Core GA
az sql server audit-policy

Manage a server's auditing policy.

Core GA
az sql server audit-policy show

Show server audit policy.

Core GA
az sql server audit-policy update

Update a server's auditing policy.

Core GA
az sql server audit-policy wait

Place the CLI in a waiting state until a condition of the server's audit policy is met.

Core GA
az sql server conn-policy

Manage a server's connection policy.

Core GA
az sql server conn-policy show

Gets a server's secure connection policy.

Core GA
az sql server conn-policy update

Updates a server's secure connection policy.

Core GA
az sql server create

Create a server.

Core GA
az sql server delete

Deletes a server.

Core GA
az sql server deleted-server

Gets details of deleted SQL servers.

Core GA
az sql server deleted-server list

List all deleted SQL servers in a specific location.

Core Preview
az sql server deleted-server show

Get the details of a deleted SQL server in a specific location.

Core Preview
az sql server dns-alias

Manage a server's DNS aliases.

Core GA
az sql server dns-alias create

Creates a server DNS alias.

Core GA
az sql server dns-alias delete

Deletes the server DNS alias with the given name.

Core GA
az sql server dns-alias list

Gets a list of server DNS aliases for a server.

Core GA
az sql server dns-alias set

Sets a server to which DNS alias should point.

Core GA
az sql server dns-alias show

Gets a server DNS alias.

Core GA
az sql server firewall-rule

Manage a server's firewall rules.

Core GA
az sql server firewall-rule create

Create a firewall rule.

Core GA
az sql server firewall-rule delete

Deletes a firewall rule.

Core GA
az sql server firewall-rule list

List a server's firewall rules.

Core GA
az sql server firewall-rule show

Shows the details for a firewall rule.

Core GA
az sql server firewall-rule update

Update a firewall rule.

Core GA
az sql server ipv6-firewall-rule

Manage a server's ipv6 firewall rules.

Core GA
az sql server ipv6-firewall-rule create

Create an ipv6 firewall rule.

Core GA
az sql server ipv6-firewall-rule delete

Deletes an IPv6 firewall rule.

Core GA
az sql server ipv6-firewall-rule list

List a server's ipv6 firewall rules.

Core GA
az sql server ipv6-firewall-rule show

Shows the details for an ipv6 firewall rule.

Core GA
az sql server ipv6-firewall-rule update

Update an ipv6 firewall rule.

Core GA
az sql server key

Manage a server's keys.

Core GA
az sql server key create

Creates a server key.

Core GA
az sql server key delete

Deletes a server key.

Core GA
az sql server key list

Gets a list of server keys.

Core GA
az sql server key show

Shows a server key.

Core GA
az sql server list

List available servers.

Core GA
az sql server list-usages

Gets server usages.

Core GA
az sql server ms-support

Manage a server's Microsoft support operations.

Core GA
az sql server ms-support audit-policy

Manage a server's Microsoft support operations auditing policy.

Core GA
az sql server ms-support audit-policy show

Show server Microsoft support operations audit policy.

Core GA
az sql server ms-support audit-policy update

Update a server's Microsoft support operations auditing policy.

Core GA
az sql server ms-support audit-policy wait

Place the CLI in a waiting state until a condition of the server's Microsoft support operations audit policy is met.

Core GA
az sql server outbound-firewall-rule

Manage a server's outbound firewall rules.

Core GA
az sql server outbound-firewall-rule create

Create a new outbound firewall rule.

Core GA
az sql server outbound-firewall-rule delete

Delete the outbound firewall rule.

Core GA
az sql server outbound-firewall-rule list

List a server's outbound firewall rules.

Core GA
az sql server outbound-firewall-rule show

Show the details for an outbound firewall rule.

Core GA
az sql server refresh-external-governance-status

Refreshes external governance status.

Core GA
az sql server restore

Restore a deleted SQL server.

Core Preview
az sql server show

Gets a server.

Core GA
az sql server tde-key

Manage a server's encryption protector.

Core GA
az sql server tde-key revalidate

Revalidate a server encryption protector.

Core GA
az sql server tde-key set

Sets the server's encryption protector. Ensure to create the key first https://learn.microsoft.com/en-us/cli/azure/sql/server/key?view=azure-cli-latest#az-sql-server-key-create.

Core GA
az sql server tde-key show

Gets a server encryption protector.

Core GA
az sql server update

Update a server.

Core GA
az sql server vnet-rule

Manage a server's virtual network rules.

Core GA
az sql server vnet-rule create

Create a virtual network rule to allows access to an Azure SQL Server.

Core GA
az sql server vnet-rule delete

Deletes the virtual network rule with the given name.

Core GA
az sql server vnet-rule list

Gets a list of virtual network rules in a server.

Core GA
az sql server vnet-rule show

Gets a virtual network rule.

Core GA
az sql server vnet-rule update

Update a virtual network rule.

Core GA
az sql server wait

Place the CLI in a waiting state until a condition of the SQL server is met.

Core