CmdID

CmdID / az / az sql

az sql vm

Manage SQL virtual machines. Azure CLI reference

9 commands 38 options Its page in the Azure CLI reference

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

Commands

9, each with its page
add-to-groupAdds SQL virtual machine to a SQL virtual machine group.createCreates a SQL virtual machine.enable-azure-ad-authEnable Azure AD authentication of a SQL virtual machine.groupManage SQL virtual machine groups.listLists all SQL virtual machines in a resource group or subscription.remove-from-groupRemove SQL virtual machine from its current SQL virtual machine group.start-assessmentStarts SQL best practice assessment on SQL virtual machineupdateUpdates the properties of a SQL virtual machine.validate-azure-ad-authValidate Azure AD authentication of a SQL virtual machine at the client side without enabling it.

Options

38 in the Azure CLI reference
Show its 38 options
--backup-pwdPassword for encryption on backup.
--backup-schedule-typeBackup schedule type.
--backup-system-dbsInclude system databases on backup.
--connectivity-typeSQL Server connectivity option.
--credential-nameCredential name
--day-of-weekDay of week to apply the patch on.
--disk-configuration-typeDisk configuration to apply to SQL Server.
--disk-countVirtual machine disk count.
--enable-auto-backupEnable or disable autobackup on SQL virtual machine.
--enable-auto-patchingEnable or disable autopatching on SQL virtual machine.
--enable-encryptionEnable encryption for backup on SQL virtual machine.
--enable-key-vault-credentialEnable or disable key vault credential setting.
--enable-r-servicesEnable or disable R services (SQL 2016 onwards).
--expandGet the SQLIaaSExtension configuration settings.
--full-backup-durationDuration of the time window of a given day during which full backups can take place.
--full-backup-frequencyFrequency of full backups.
--full-backup-start-hourStart time of a given day during which full backups can take place.
--image-offerSQL image offer.
--image-skuSQL image sku.
--key-vaultAzure Key Vault url.
--least-privilege-modeSQL IaaS Agent Least Privilege Mode.
--license-type, -iSQL Server license type.
--location, -lLocation.
--log-backup-frequencyFrequency of log backups.
--maintenance-window-durationDuration of patching.
--maintenance-window-start-hourHour of the day when patching is initiated.
--name, -nName of the SQL virtual machine.
--portSQL Server port.
--retention-periodRetention period of backup.
--sa-keyStorage account key where backup will be taken to.
--sp-nameService principal name to access key vault.
--sp-secretService principal name secret to access key vault.
--sql-auth-update-pwdSQL Server sysadmin login password.
--sql-auth-update-usernameSQL Server sysadmin login to create.
--sql-mgmt-typeSQL Server management type.
--sql-workload-typeSQL Server workload type.
--storage-accountStorage account url where backup will be taken to.
--tagsspace-separated tags: key[=value] [key[=value] ...].