ManagedInstance interface
An Azure SQL managed instance.
- Extends
Properties
administrator |
Administrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation). |
administrator |
The administrator login password (required for managed instance creation). |
administrators | The Azure Active Directory administrator of the instance. This can only be used at instance create time. If used for instance update, it will be ignored or it will result in an error. For updates individual APIs will need to be used. |
collation | Collation of the managed instance. |
current |
The storage account type used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage) NOTE: This property will not be serialized. It can only be populated by the server. |
dns |
The Dns Zone that the managed instance is in. NOTE: This property will not be serialized. It can only be populated by the server. |
dns |
The resource id of another managed instance whose DNS zone this managed instance will share after creation. |
fully |
The fully qualified domain name of the managed instance. NOTE: This property will not be serialized. It can only be populated by the server. |
identity | The Azure Active Directory identity of the managed instance. |
instance |
The Id of the instance pool this managed server belongs to. |
key |
A CMK URI of the key to use for encryption. |
license |
The license type. Possible values are 'LicenseIncluded' (regular price inclusive of a new SQL license) and 'BasePrice' (discounted AHB price for bringing your own SQL licenses). |
maintenance |
Specifies maintenance configuration id to apply to this managed instance. |
managed |
Specifies the mode of database creation. Default: Regular instance creation. Restore: Creates an instance by restoring a set of backups to specific point in time. RestorePointInTime and SourceManagedInstanceId must be specified. |
minimal |
Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2' |
primary |
The resource id of a user assigned identity to be used by default. |
private |
List of private endpoint connections on a managed instance. NOTE: This property will not be serialized. It can only be populated by the server. |
provisioning |
NOTE: This property will not be serialized. It can only be populated by the server. |
proxy |
Connection type used for connecting to the instance. |
public |
Whether or not the public data endpoint is enabled. |
requested |
The storage account type to be used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage) |
restore |
Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database. |
service |
The managed instance's service principal. |
sku | Managed instance SKU. Allowed values for sku.name: GP_Gen5, GP_G8IM, GP_G8IH, BC_Gen5, BC_G8IM, BC_G8IH |
source |
The resource identifier of the source managed instance associated with create operation of this instance. |
state | The state of the managed instance. NOTE: This property will not be serialized. It can only be populated by the server. |
storage |
Storage size in GB. Minimum value: 32. Maximum value: 16384. Increments of 32 GB allowed only. Maximum value depends on the selected hardware family and number of vCores. |
subnet |
Subnet resource ID for the managed instance. |
timezone |
Id of the timezone. Allowed values are timezones supported by Windows. Windows keeps details on supported timezones, including the id, in registry under KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones. You can get those registry values via SQL Server by querying SELECT name AS timezone_id FROM sys.time_zone_info. List of Ids can also be obtained by executing [System.TimeZoneInfo]::GetSystemTimeZones() in PowerShell. An example of valid timezone id is "Pacific Standard Time" or "W. Europe Standard Time". |
v |
The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80. |
zone |
Whether or not the multi-az is enabled. |
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
administratorLogin
Administrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation).
administratorLogin?: string
Property Value
string
administratorLoginPassword
The administrator login password (required for managed instance creation).
administratorLoginPassword?: string
Property Value
string
administrators
The Azure Active Directory administrator of the instance. This can only be used at instance create time. If used for instance update, it will be ignored or it will result in an error. For updates individual APIs will need to be used.
administrators?: ManagedInstanceExternalAdministrator
Property Value
collation
Collation of the managed instance.
collation?: string
Property Value
string
currentBackupStorageRedundancy
The storage account type used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage) NOTE: This property will not be serialized. It can only be populated by the server.
currentBackupStorageRedundancy?: string
Property Value
string
dnsZone
The Dns Zone that the managed instance is in. NOTE: This property will not be serialized. It can only be populated by the server.
dnsZone?: string
Property Value
string
dnsZonePartner
The resource id of another managed instance whose DNS zone this managed instance will share after creation.
dnsZonePartner?: string
Property Value
string
fullyQualifiedDomainName
The fully qualified domain name of the managed instance. NOTE: This property will not be serialized. It can only be populated by the server.
fullyQualifiedDomainName?: string
Property Value
string
identity
The Azure Active Directory identity of the managed instance.
identity?: ResourceIdentity
Property Value
instancePoolId
The Id of the instance pool this managed server belongs to.
instancePoolId?: string
Property Value
string
keyId
A CMK URI of the key to use for encryption.
keyId?: string
Property Value
string
licenseType
The license type. Possible values are 'LicenseIncluded' (regular price inclusive of a new SQL license) and 'BasePrice' (discounted AHB price for bringing your own SQL licenses).
licenseType?: string
Property Value
string
maintenanceConfigurationId
Specifies maintenance configuration id to apply to this managed instance.
maintenanceConfigurationId?: string
Property Value
string
managedInstanceCreateMode
Specifies the mode of database creation.
Default: Regular instance creation.
Restore: Creates an instance by restoring a set of backups to specific point in time. RestorePointInTime and SourceManagedInstanceId must be specified.
managedInstanceCreateMode?: string
Property Value
string
minimalTlsVersion
Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'
minimalTlsVersion?: string
Property Value
string
primaryUserAssignedIdentityId
The resource id of a user assigned identity to be used by default.
primaryUserAssignedIdentityId?: string
Property Value
string
privateEndpointConnections
List of private endpoint connections on a managed instance. NOTE: This property will not be serialized. It can only be populated by the server.
privateEndpointConnections?: ManagedInstancePecProperty[]
Property Value
provisioningState
NOTE: This property will not be serialized. It can only be populated by the server.
provisioningState?: string
Property Value
string
proxyOverride
Connection type used for connecting to the instance.
proxyOverride?: string
Property Value
string
publicDataEndpointEnabled
Whether or not the public data endpoint is enabled.
publicDataEndpointEnabled?: boolean
Property Value
boolean
requestedBackupStorageRedundancy
The storage account type to be used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)
requestedBackupStorageRedundancy?: string
Property Value
string
restorePointInTime
Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
restorePointInTime?: Date
Property Value
Date
servicePrincipal
The managed instance's service principal.
servicePrincipal?: ServicePrincipal
Property Value
sku
Managed instance SKU. Allowed values for sku.name: GP_Gen5, GP_G8IM, GP_G8IH, BC_Gen5, BC_G8IM, BC_G8IH
sku?: Sku
Property Value
sourceManagedInstanceId
The resource identifier of the source managed instance associated with create operation of this instance.
sourceManagedInstanceId?: string
Property Value
string
state
The state of the managed instance. NOTE: This property will not be serialized. It can only be populated by the server.
state?: string
Property Value
string
storageSizeInGB
Storage size in GB. Minimum value: 32. Maximum value: 16384. Increments of 32 GB allowed only. Maximum value depends on the selected hardware family and number of vCores.
storageSizeInGB?: number
Property Value
number
subnetId
Subnet resource ID for the managed instance.
subnetId?: string
Property Value
string
timezoneId
Id of the timezone. Allowed values are timezones supported by Windows. Windows keeps details on supported timezones, including the id, in registry under KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones. You can get those registry values via SQL Server by querying SELECT name AS timezone_id FROM sys.time_zone_info. List of Ids can also be obtained by executing [System.TimeZoneInfo]::GetSystemTimeZones() in PowerShell. An example of valid timezone id is "Pacific Standard Time" or "W. Europe Standard Time".
timezoneId?: string
Property Value
string
vCores
The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80.
vCores?: number
Property Value
number
zoneRedundant
Whether or not the multi-az is enabled.
zoneRedundant?: boolean
Property Value
boolean
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