SQL Server Managed Instance

This table represents the SQL Server Managed Instance resource from Microsoft Azure.

azure.sql_server_managed_instance

Fields

TitleIDTypeData TypeDescription
_keycorestring
administrator_logincorestringAdministrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation).
administratorscorejsonThe Azure Active Directory administrator of the server.
collationcorestringCollation of the managed instance.
current_backup_storage_redundancycorestringThe storage account type used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)
dns_zonecorestringThe Dns Zone that the managed instance is in.
dns_zone_partnercorestringThe resource id of another managed instance whose DNS zone this managed instance will share after creation.
fully_qualified_domain_namecorestringThe fully qualified domain name of the managed instance.
idcorestringResource ID.
identitycorejsonThe Azure Active Directory identity of the managed instance.
instance_pool_idcorestringThe Id of the instance pool this managed server belongs to.
key_idcorestringA CMK URI of the key to use for encryption.
license_typecorestringThe 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).
locationcorestringResource location.
maintenance_configuration_idcorestringSpecifies maintenance configuration id to apply to this managed instance.
managed_instance_create_modecorestringSpecifies 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_tls_versioncorestringMinimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'
namecorestringResource name.
primary_user_assigned_identity_idcorestringThe resource id of a user assigned identity to be used by default.
private_endpoint_connectionscorejsonList of private endpoint connections on a managed instance.
provisioning_statecorestring
proxy_overridecorestringConnection type used for connecting to the instance.
public_data_endpoint_enabledcoreboolWhether or not the public data endpoint is enabled.
requested_backup_storage_redundancycorestringThe storage account type to be used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)
resource_groupcorestring
restore_point_in_timecorestringSpecifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
service_principalcorejsonThe managed instance's service principal.
skucorejsonManaged instance SKU. Allowed values for sku.name: GP_Gen5, GP_G8IM, GP_G8IH, BC_Gen5, BC_G8IM, BC_G8IH
source_managed_instance_idcorestringThe resource identifier of the source managed instance associated with create operation of this instance.
statecorestringThe state of the managed instance.
storage_size_in_gbcoreint64Storage 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_idcorestringSubnet resource ID for the managed instance.
subscription_idcorestring
subscription_namecorestring
tagscorehstore
timezone_idcorestringId of the timezone. Allowed values are timezones supported by Windows.Windows keeps details on supported timezones, including the id, in registry underKEY_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".
typecorestringResource type.
v_corescoreint64The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80.
zone_redundantcoreboolWhether or not the multi-az is enabled.