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

Copy: creates a database as a copy of an existing database. 'DATABASE_DEFAULT' 'SQL_Latin1_General_CP1_CI_AS' A value of -1 means that automatic pause is disabled Time in minutes after which database is automatically paused.

Symbolic name for resource of type: servers For more information, see Child resource outside parent resource. You only need to add this property when the child resource is declared outside of the parent resource.

In Bicep, you can specify the parent resource for a child resource. To create a Microsoft.Sql/servers/databases resource, add the following Bicep to your template.

Resource groups - See resource group deployment commandsįor a list of changed properties in each API version, see change log.

The servers/databases resource type can be deployed to:

Database templates for mac