ManagedInstance interface

An Azure SQL managed instance.

Extends

Properties

administratorLogin

Administrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation).

administratorLoginPassword

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.

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.

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.

dnsZonePartner

The resource id of another managed instance whose DNS zone this managed instance will share after creation.

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.

identity

The Azure Active Directory identity of the managed instance.

instancePoolId

The Id of the instance pool this managed server belongs to.

keyId

A CMK URI of the key to use for encryption.

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).

maintenanceConfigurationId

Specifies maintenance configuration id to apply to this managed instance.

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.

minimalTlsVersion

Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'

primaryUserAssignedIdentityId

The resource id of a user assigned identity to be used by default.

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.

provisioningState

NOTE: This property will not be serialized. It can only be populated by the server.

proxyOverride

Connection type used for connecting to the instance.

publicDataEndpointEnabled

Whether or not the public data endpoint is enabled.

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)

restorePointInTime

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.

servicePrincipal

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

sourceManagedInstanceId

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.

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.

subnetId

Subnet resource ID for the managed instance.

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".

vCores

The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80.

zoneRedundant

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

Sku

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

Resource location.

location: string

Property Value

string

Inherited From TrackedResource.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