Microsoft.Sql servers/databases 2020-08-01-preview

Template format

To create a Microsoft.Sql/servers/databases resource, add the following JSON to the resources section of your template.

{
  "name": "string",
  "type": "Microsoft.Sql/servers/databases",
  "apiVersion": "2020-08-01-preview",
  "location": "string",
  "tags": {},
  "sku": {
    "name": "string",
    "tier": "string",
    "size": "string",
    "family": "string",
    "capacity": "integer"
  },
  "properties": {
    "createMode": "string",
    "collation": "string",
    "maxSizeBytes": "integer",
    "sampleName": "string",
    "elasticPoolId": "string",
    "sourceDatabaseId": "string",
    "restorePointInTime": "string",
    "sourceDatabaseDeletionDate": "string",
    "recoveryServicesRecoveryPointId": "string",
    "longTermRetentionBackupResourceId": "string",
    "recoverableDatabaseId": "string",
    "restorableDroppedDatabaseId": "string",
    "catalogCollation": "string",
    "zoneRedundant": "boolean",
    "licenseType": "string",
    "readScale": "string",
    "highAvailabilityReplicaCount": "integer",
    "secondaryType": "string",
    "autoPauseDelay": "integer",
    "storageAccountType": "string",
    "minCapacity": "number",
    "maintenanceConfigurationId": "string"
  }
}

Property values

The following tables describe the values you need to set in the schema.

Microsoft.Sql/servers/databases object

Name Type Required Value
name string Yes The name of the database.
type enum Yes databases
-or-
Microsoft.Sql/servers/databases

See Set name and type for child resources.
apiVersion enum Yes 2020-08-01-preview
location string Yes Resource location.
tags object No Resource tags.
sku object No The database SKU.

The list of SKUs may vary by region and support offer. To determine the SKUs (including the SKU name, tier/edition, family, and capacity) that are available to your subscription in an Azure region, use the Capabilities_ListByLocation REST API or one of the following commands:

az sql db list-editions -l <location> -o table<br>

Get-AzSqlServerServiceObjective -Location <location> - Sku object
properties object Yes Resource properties. - DatabaseProperties object

Sku object

Name Type Required Value
name string Yes The name of the SKU, typically, a letter + Number code, e.g. P3.
tier string No The tier or edition of the particular SKU, e.g. Basic, Premium.
size string No Size of the particular SKU
family string No If the service has different generations of hardware, for the same SKU, then that can be captured here.
capacity integer No Capacity of the particular SKU.

DatabaseProperties object

Name Type Required Value
createMode enum No Specifies the mode of database creation.

Default: regular database creation.

Copy: creates a database as a copy of an existing database. sourceDatabaseId must be specified as the resource ID of the source database.

Secondary: creates a database as a secondary replica of an existing database. sourceDatabaseId must be specified as the resource ID of the existing primary database.

PointInTimeRestore: Creates a database by restoring a point in time backup of an existing database. sourceDatabaseId must be specified as the resource ID of the existing database, and restorePointInTime must be specified.

Recovery: Creates a database by restoring a geo-replicated backup. sourceDatabaseId must be specified as the recoverable database resource ID to restore.

Restore: Creates a database by restoring a backup of a deleted database. sourceDatabaseId must be specified. If sourceDatabaseId is the database's original resource ID, then sourceDatabaseDeletionDate must be specified. Otherwise sourceDatabaseId must be the restorable dropped database resource ID and sourceDatabaseDeletionDate is ignored. restorePointInTime may also be specified to restore from an earlier point in time.

RestoreLongTermRetentionBackup: Creates a database by restoring from a long term retention vault. recoveryServicesRecoveryPointResourceId must be specified as the recovery point resource ID.

Copy, Secondary, and RestoreLongTermRetentionBackup are not supported for DataWarehouse edition. - Default, Copy, Secondary, PointInTimeRestore, Restore, Recovery, RestoreExternalBackup, RestoreExternalBackupSecondary, RestoreLongTermRetentionBackup, OnlineSecondary
collation string No The collation of the database.
maxSizeBytes integer No The max size of the database expressed in bytes.
sampleName enum No The name of the sample schema to apply when creating this database. - AdventureWorksLT, WideWorldImportersStd, WideWorldImportersFull
elasticPoolId string No The resource identifier of the elastic pool containing this database.
sourceDatabaseId string No The resource identifier of the source database associated with create operation of this database.
restorePointInTime string No Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
sourceDatabaseDeletionDate string No Specifies the time that the database was deleted.
recoveryServicesRecoveryPointId string No The resource identifier of the recovery point associated with create operation of this database.
longTermRetentionBackupResourceId string No The resource identifier of the long term retention backup associated with create operation of this database.
recoverableDatabaseId string No The resource identifier of the recoverable database associated with create operation of this database.
restorableDroppedDatabaseId string No The resource identifier of the restorable dropped database associated with create operation of this database.
catalogCollation enum No Collation of the metadata catalog. - DATABASE_DEFAULT or SQL_Latin1_General_CP1_CI_AS
zoneRedundant boolean No Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones.
licenseType enum No The license type to apply for this database. LicenseIncluded if you need a license, or BasePrice if you have a license and are eligible for the Azure Hybrid Benefit. - LicenseIncluded or BasePrice
readScale enum No The state of read-only routing. If enabled, connections that have application intent set to readonly in their connection string may be routed to a readonly secondary replica in the same region. - Enabled or Disabled
highAvailabilityReplicaCount integer No The number of secondary replicas associated with the database that are used to provide high availability.
secondaryType enum No The secondary type of the database if it is a secondary. Valid values are Geo and Named. - Geo or Named
autoPauseDelay integer No Time in minutes after which database is automatically paused. A value of -1 means that automatic pause is disabled
storageAccountType enum No The storage account type used to store backups for this database. Currently the only supported option is GRS (GeoRedundantStorage). - GRS, LRS, ZRS
minCapacity number No Minimal capacity that database will always have allocated, if not paused
maintenanceConfigurationId string No Maintenance configuration id assigned to the database. This configuration defines the period when the maintenance updates will be rolled out.

Quickstart templates

The following quickstart templates deploy this resource type.

Template Description
Migrate to Azure SQL database using Azure DMS

Deploy to Azure
The Azure Database Migration Service (DMS) is designed to streamline the process of migrating on-premises databases to Azure. DMS will simplify the migration of existing on-premises SQL Server and Oracle databases to Azure SQL Database, Azure SQL Managed Instance or Microsoft SQL Server in an Azure Virtual Machine. This template would deploy an instance of Azure Database Migration service, an Azure VM with SQL server installed on it which will act as a Source server with pre created database on it and a Target Azure SQL DB server which will have a pre-created schema of the database to be migrated from Source to Target server. The template will also deploy the required resources like NIC, vnet etc for supporting the Source VM, DMS service and Target server.
HDInsight with custom Ambari + Hive Metastore DB in VNET

Deploy to Azure
This template allows you to create an HDInsight cluster in an existing virtual network with a new SQL DB that serves as both a custom Ambari DB and Hive Metastore. You must have an exising SQL Sever, storage account, and VNET.
Deploy a HDInsight cluster and a SQL database

Deploy to Azure
This template allows you to create a HDInsight cluster and a SQL Database for testing Sqoop.
Provision a Mobile App with a SQL Database

Deploy to Azure
This template provisions a Mobile App, SQL Database, and Notification Hub. It configures a connection string in the mobile app for the database and notification hub.
Private Endpoint example

Deploy to Azure
This template shows how to create a private endpoint pointing to Azure SQL Server
Remote Desktop Services with High Availability

Deploy to Azure
This ARM Template sample code will deploy a Remote Desktop Services 2019 Session Collection lab with high availability. The goal is to deploy a fully redundant, highly available solution for Remote Desktop Services, using Windows Server 2019.
Create a SQL Server and Database

Deploy to Azure
This template allows you to create SQL Database and Server.
Deploy a new SQL Elastic Pool

Deploy to Azure
This template allows you to deploy a new SQL Elastic Pool with its new associated SQL Server and new SQL Databases to assign to it.
Create Azure SQL Servers and Database with Failover Group

Deploy to Azure
Creates two Azure SQL servers, a database, and a failover group.
Sonarqube Docker Web App on Linux with Azure SQL

Deploy to Azure
This template deploys Sonarqube in an Azure App Service web app Linux container using the official Sonarqube image and backed by an Azure SQL Server.
WebApp consuming a Azure SQL Private Endpoint

Deploy to Azure
This template shows how to create a Web app that consumes a private endpoint pointing to Azure SQL Server
Azure SQL Server with Auditing written to Event Hub

Deploy to Azure
This template allows you to deploy an Azure SQL server with Auditing enabled to write audit logs to Event Hub
Azure SQL Server with Auditing written to Log Analitics

Deploy to Azure
This template allows you to deploy an Azure SQL server with Auditing enabled to write audit logs to Log Analitics (OMS workspace)
Provision a SQL Database with TDE

Deploy to Azure
This template provisions a SQL Server with firewall opened for Azure traffic and a SQL database with Transparent Data Encryption (TDE).
SQL Server SQL Data Warehouse with Transparent Encryption.

Deploy to Azure
Creates a SQL Server and a SQL Data Warehouse with Transparent Data Encryption.
Azure SQL Server + multiple SQL DBs with Threat Detection

Deploy to Azure
This template allows you to deploy an Azure SQL Server and a user-defined number of Azure SQL Databases with Threat Detection enabled, with an email address to receive alerts for each database.
Create a Web App + Redis Cache + SQL DB with a template

Deploy to Azure
This template creates an Azure Web App with Redis cache and a SQL Database.
Provision a Web App with a SQL Database

Deploy to Azure
This template provisions a Web App, a SQL Database, AutoScale settings, Alert rules, and App Insights. It configures a connection string in the web app for the database.
Create, configure and deploy Web Application to an Azure VM

Deploy to Azure
Create and configure a Windows VM with SQL Azure database, and deploy web application to the environment using PowerShell DSC
Web App with a SQL Database, Azure Cosmos DB, Azure Search

Deploy to Azure
This template provisions a Web App, a SQL Database, Azure Cosmos DB, Azure Search and Application Insights.
Enterprise Governance-AppService, SQL DB, AD, OMS, Runbooks

Deploy to Azure
Cloud adoption for an Enterprise, small or large, require responsible and efficient governance models to derive value from their cloud deployments. CloudWise (a code-name for the solution), is a composite solution available from Azure Partner QuickStarts, is an adoption enabler for Customers, System Integrators and Partners alike, that delivers a self-serviceable, automated governance and operations solution, focused on Optimizing Your Costs, Improve Your Application(s) Reliability, Reducing Business Risk. The solution highlights the core governance pillars of Visibility and Control.
EPiserverCMS in Azure

Deploy to Azure
This template allows you to create resources required for EpiServerCMS deployment in Azure
eShop Website with ILB ASE

Deploy to Azure
An App Service Environment is a Premium service plan option of Azure App Service that provides a fully isolated and dedicated environment for securely running Azure App Service apps at high scale, including Web Apps, Mobile Apps, and API Apps.
Autoscale LANSA Windows VM ScaleSet with Azure SQL Database

Deploy to Azure
The template deploys a Windows VMSS with a desired count of VMs in the scale set and a LANSA MSI to install into each VM. Once the VM Scale Set is deployed a custom script extension is used to install the LANSA MSI)
Deploy Octopus Deploy 3.0 with a trial license.

Deploy to Azure
This template allows you to deploy a single Octopus Deploy 3.0 server with a trial license. This will deploy on a single Windows Server 2012R2 VM (Standard D2) and SQL DB (S1 tier) into the location specified for the Resource Group.
Orchard CMS Video Portal Web App

Deploy to Azure
This template provides a easy way to deploy Orchard CMS on Azure App Service Web Apps with the Azure Media Services module enabled and configured.
Django App with SQL Databases

Deploy to Azure
This template uses the Azure Linux CustomScript extension to deploy an application. This example creates an Ubuntu VM, does a silent install of Python, Django and Apache, then creates a simple Django app. The template also creates a SQL Database, with a sample table with some sample data which displayed in the web browser using a query
Scalable Umbraco CMS Web App

Deploy to Azure
This template provides a easy way to deploy umbraco CMS web app on Azure App Service Web Apps.
Simple Umbraco CMS Web App

Deploy to Azure
This template provides a easy way to deploy umbraco CMS web app on Azure App Service Web Apps.