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?: stringProperty Value
string
		administratorLoginPassword
	  
	The administrator login password (required for managed instance creation).
administratorLoginPassword?: stringProperty 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?: ManagedInstanceExternalAdministratorProperty Value
collation
Collation of the managed instance.
collation?: stringProperty 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?: stringProperty 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?: stringProperty Value
string
		dnsZonePartner
	  
	The resource id of another managed instance whose DNS zone this managed instance will share after creation.
dnsZonePartner?: stringProperty 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?: stringProperty Value
string
identity
The Azure Active Directory identity of the managed instance.
identity?: ResourceIdentityProperty Value
		instancePoolId
	  
	The Id of the instance pool this managed server belongs to.
instancePoolId?: stringProperty Value
string
		keyId
	 
	A CMK URI of the key to use for encryption.
keyId?: stringProperty 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?: stringProperty Value
string
		maintenanceConfigurationId
	  
	Specifies maintenance configuration id to apply to this managed instance.
maintenanceConfigurationId?: stringProperty 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?: stringProperty Value
string
		minimalTlsVersion
	  
	Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'
minimalTlsVersion?: stringProperty Value
string
		primaryUserAssignedIdentityId
	    
	The resource id of a user assigned identity to be used by default.
primaryUserAssignedIdentityId?: stringProperty 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?: stringProperty Value
string
		proxyOverride
	 
	Connection type used for connecting to the instance.
proxyOverride?: stringProperty Value
string
		publicDataEndpointEnabled
	   
	Whether or not the public data endpoint is enabled.
publicDataEndpointEnabled?: booleanProperty 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?: stringProperty Value
string
		restorePointInTime
	  
	Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
restorePointInTime?: DateProperty Value
Date
		servicePrincipal
	 
	The managed instance's service principal.
servicePrincipal?: ServicePrincipalProperty Value
sku
Managed instance SKU. Allowed values for sku.name: GP_Gen5, GP_G8IM, GP_G8IH, BC_Gen5, BC_G8IM, BC_G8IH
sku?: SkuProperty Value
		sourceManagedInstanceId
	   
	The resource identifier of the source managed instance associated with create operation of this instance.
sourceManagedInstanceId?: stringProperty 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?: stringProperty 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?: numberProperty Value
number
		subnetId
	 
	Subnet resource ID for the managed instance.
subnetId?: stringProperty 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?: stringProperty Value
string
		vCores
	 
	The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80.
vCores?: numberProperty Value
number
		zoneRedundant
	 
	Whether or not the multi-az is enabled.
zoneRedundant?: booleanProperty Value
boolean
Inherited Property Details
id
Resource ID. NOTE: This property will not be serialized. It can only be populated by the server.
id?: stringProperty 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?: stringProperty 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?: stringProperty Value
string
Inherited From TrackedResource.type