Microsoft.Sql managedInstances/databases

  • Article
  • 2 minutes to read

The managedInstances/databases resource type can be deployed to: Resource groups.

To learn about resource group deployments, see Bicep or ARM template.

Template format

To create a Microsoft.Sql/managedInstances/databases resource, add the following Bicep or JSON to your template.

resource symbolicname 'Microsoft.Sql/managedInstances/databases@2021-11-01-preview' = {
  name: 'string'
  location: 'string'
  tags: {
    tagName1: 'tagValue1'
    tagName2: 'tagValue2'
  }
  parent: resourceSymbolicName
  properties: {
    autoCompleteRestore: bool
    catalogCollation: 'string'
    collation: 'string'
    createMode: 'string'
    lastBackupName: 'string'
    longTermRetentionBackupResourceId: 'string'
    recoverableDatabaseId: 'string'
    restorableDroppedDatabaseId: 'string'
    restorePointInTime: 'string'
    sourceDatabaseId: 'string'
    storageContainerSasToken: 'string'
    storageContainerUri: 'string'
  }
}

Property values

managedInstances/databases

Name Description Value
type The resource type

For Bicep, set this value in the resource declaration.		 'Microsoft.Sql/managedInstances/databases'
apiVersion The resource api version

For Bicep, set this value in the resource declaration.		 '2021-11-01-preview'
name The resource name

See how to set names and types for child resources in Bicep or JSON ARM templates.		 string (required)
location Resource location. string (required)
tags Resource tags. Dictionary of tag names and values. See Tags in templates
parent In Bicep, you can specify the parent resource for a child resource. You only need to add this property when the child resource is declared outside of the parent resource.

For more information, see Child resource outside parent resource.		 Symbolic name for resource of type: managedInstances
properties The managed database's properties. ManagedDatabaseProperties

ManagedDatabaseProperties

Name Description Value
autoCompleteRestore Whether to auto complete restore of this managed database. bool
catalogCollation Collation of the metadata catalog. 'DATABASE_DEFAULT'
'SQL_Latin1_General_CP1_CI_AS'
collation Collation of the managed database. string
createMode Managed database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. SourceDatabaseName, SourceManagedInstanceName and PointInTime must be specified. RestoreExternalBackup: Create a database by restoring from external backup files. Collation, StorageContainerUri and StorageContainerSasToken must be specified. Recovery: Creates a database by restoring a geo-replicated backup. RecoverableDatabaseId must be specified as the recoverable database resource ID to restore. RestoreLongTermRetentionBackup: Create a database by restoring from a long term retention backup (longTermRetentionBackupResourceId required). 'Default'
'PointInTimeRestore'
'Recovery'
'RestoreExternalBackup'
'RestoreLongTermRetentionBackup'
lastBackupName Last backup file name for restore of this managed database. string
longTermRetentionBackupResourceId The name of the Long Term Retention backup to be used for restore of this managed database. string
recoverableDatabaseId The resource identifier of the recoverable database associated with create operation of this database. string
restorableDroppedDatabaseId The restorable dropped database resource id to restore when creating this database. string
restorePointInTime Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database. string
sourceDatabaseId The resource identifier of the source database associated with create operation of this database. string
storageContainerSasToken Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the storage container sas token. string
storageContainerUri Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored. string