SqlVirtualMachine interface
A SQL virtual machine.
- Extends
Properties
| assessment |
SQL best practices Assessment Settings. |
| auto |
Auto backup settings for SQL Server. |
| auto |
Auto patching settings for applying critical security updates to SQL virtual machine. |
| enable |
Enable automatic upgrade of Sql IaaS extension Agent. |
| identity | Azure Active Directory identity of the server. |
| key |
Key vault credential settings. |
| least |
SQL IaaS Agent least privilege mode. |
| provisioning |
Provisioning state to track the async operation status. NOTE: This property will not be serialized. It can only be populated by the server. |
| server |
SQL Server configuration management settings. |
| sql |
SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016. |
| sql |
SQL Server edition type. |
| sql |
SQL Server Management type. |
| sql |
SQL Server license type. |
| sql |
ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of. |
| storage |
Storage Configuration Settings. |
| system |
Metadata pertaining to creation and last modification of the resource. NOTE: This property will not be serialized. It can only be populated by the server. |
| troubleshooting |
Troubleshooting status NOTE: This property will not be serialized. It can only be populated by the server. |
| virtual |
ARM Resource id of underlying virtual machine created from SQL marketplace image. |
| wsfc |
Domain credentials for setting up Windows Server Failover Cluster for SQL availability group. |
| wsfc |
Domain credentials for setting up Windows Server Failover Cluster for SQL availability group. |
Inherited Properties
| id | Resource ID. NOTE: This property will not be serialized. It can only be populated by the server. |
| location | Resource location. |
| name | Resource name. NOTE: This property will not be serialized. It can only be populated by the server. |
| tags | Resource tags. |
| type | Resource type. NOTE: This property will not be serialized. It can only be populated by the server. |
Property Details
assessmentSettings
SQL best practices Assessment Settings.
assessmentSettings?: AssessmentSettings
Property Value
autoBackupSettings
Auto backup settings for SQL Server.
autoBackupSettings?: AutoBackupSettings
Property Value
autoPatchingSettings
Auto patching settings for applying critical security updates to SQL virtual machine.
autoPatchingSettings?: AutoPatchingSettings
Property Value
enableAutomaticUpgrade
Enable automatic upgrade of Sql IaaS extension Agent.
enableAutomaticUpgrade?: boolean
Property Value
boolean
identity
Azure Active Directory identity of the server.
identity?: ResourceIdentity
Property Value
keyVaultCredentialSettings
Key vault credential settings.
keyVaultCredentialSettings?: KeyVaultCredentialSettings
Property Value
leastPrivilegeMode
SQL IaaS Agent least privilege mode.
leastPrivilegeMode?: string
Property Value
string
provisioningState
Provisioning state to track the async operation status. NOTE: This property will not be serialized. It can only be populated by the server.
provisioningState?: string
Property Value
string
serverConfigurationsManagementSettings
SQL Server configuration management settings.
serverConfigurationsManagementSettings?: ServerConfigurationsManagementSettings
Property Value
sqlImageOffer
SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
sqlImageOffer?: string
Property Value
string
sqlImageSku
SQL Server edition type.
sqlImageSku?: string
Property Value
string
sqlManagement
SQL Server Management type.
sqlManagement?: string
Property Value
string
sqlServerLicenseType
SQL Server license type.
sqlServerLicenseType?: string
Property Value
string
sqlVirtualMachineGroupResourceId
ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
sqlVirtualMachineGroupResourceId?: string
Property Value
string
storageConfigurationSettings
Storage Configuration Settings.
storageConfigurationSettings?: StorageConfigurationSettings
Property Value
systemData
Metadata pertaining to creation and last modification of the resource. NOTE: This property will not be serialized. It can only be populated by the server.
systemData?: SystemData
Property Value
troubleshootingStatus
Troubleshooting status NOTE: This property will not be serialized. It can only be populated by the server.
troubleshootingStatus?: TroubleshootingStatus
Property Value
virtualMachineResourceId
ARM Resource id of underlying virtual machine created from SQL marketplace image.
virtualMachineResourceId?: string
Property Value
string
wsfcDomainCredentials
Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
wsfcDomainCredentials?: WsfcDomainCredentials
Property Value
wsfcStaticIp
Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
wsfcStaticIp?: string
Property Value
string
Inherited Property Details
id
Resource ID. NOTE: This property will not be serialized. It can only be populated by the server.
id?: string
Property Value
string
Inherited From TrackedResource.id
location
name
Resource name. NOTE: This property will not be serialized. It can only be populated by the server.
name?: string
Property Value
string
Inherited From TrackedResource.name
tags
Resource tags.
tags?: {[propertyName: string]: string}
Property Value
{[propertyName: string]: string}
Inherited From TrackedResource.tags
type
Resource type. NOTE: This property will not be serialized. It can only be populated by the server.
type?: string
Property Value
string
Inherited From TrackedResource.type