2026.8.26.3

Overview
Name azureelasticsql
Tag 2026.8.26.3
FullName br:bicepacrdevwcom.azurecr.io/bicep/modules/azuresql/elasticpool/azureelasticsql:2026.8.26.3
Last updated 2026-08-26 07:41:13:+00:00
Created 2026-08-26 07:41:13:+00:00
Digest sha256:7540bced621a3960f0b8c0c0358e4c0df0925c0286ab3f32e8ceab4e2b827836

Parameters

Name Type Required Description
env string Yes The environment to be created.
system string Yes System/project name
tags object Yes Tags to add to the resources
location string No
resourceGroup().location
 Location for all resources.
sqladminGroupName string Yes
sqladminGroupId string Yes
sqlSubnets array No
[
]
firewallRules array No
[
]
sqlDBs array No
[
]
 Array of databases and collation. If not specified, default collation is Finnish_Swedish_CI_AS. Example:
var sqlDatabases = [
{
name: 'databaseName'
collation: 'Finnish_Swedish_CI_AS'
backupLongTermRetentionPoliciesWeeklyRetention: 'P12W'
backupLongTermRetentionPoliciesMonthlyRetention: 'P24M'
backupLongTermRetentionPoliciesYealyRetention: 'P10Y'
backupLongTermRetentionPoliciesWeekOfYear: 2
backupShortTermRetentionPoliciesDays: 20
}
]
defaultCollation string No
'Finnish_Swedish_CI_AS'
elasticSku string No
'StandardPool'
elasticCapacity int No
50
serverNamePrefix string Yes
elasticPoolNamePrefix string Yes
zoneRedundant bool No
false
sqlRbacPrincipalIds array No
[
]
roleDefinitionResourceId string No
'6d8ee4ec-f05a-4a1d-8b00-a9b17e38b437'
highAvailabilityReplicaCount int No
0
azureADOnlyAuthentication bool No
true
serverName string No
format('{0}-{1}-sql-{2}', serverNamePrefix, system, env)
elasticPoolName string No
format('{0}-{1}-elasticpool-{2}', elasticPoolNamePrefix, system, env)
defaultBackupShortTermRetentionPoliciesDays int No
if(or(equals(env, 'prd'), equals(env, 'prod')), 15, 7)
defaultBackupLongTermRetentionPoliciesWeeklyRetention string No
if(or(equals(env, 'prd'), equals(env, 'prod')), 'P8W', 'PT0S')
defaultBackupLongTermRetentionPoliciesMonthlyRetention string No
if(or(equals(env, 'prd'), equals(env, 'prod')), 'P12M', 'PT0S')
defaultBackupLongTermRetentionPoliciesYearlyRetention string No
if(or(equals(env, 'prd'), equals(env, 'prod')), 'P10Y', 'PT0S')
excludedRetentionPolicyDatabases array No
[
]

Outputs

Name Type Description
name string
connectionStrings array

Example

@description('The target environment.')
param env string

@description('The deployment version.')
param version string = '1.0.0.0'

@description('System/project name')
param system string

@description('Tags to add to the resources')
param tags object

param sqladminGroupName string

param sqladminGroupId string

param serverNamePrefix string

param elasticPoolNamePrefix string


module azureelasticsql 'br:bicepacrdevwcom.azurecr.io/bicep/modules/azuresql/elasticpool/azureelasticsql:2026.8.26.3' = {
    name: 'azureelasticsql${env}${version}'
    params: {
      env: env
      system: system
      tags: tags
      sqladminGroupName: sqladminGroupName
      sqladminGroupId: sqladminGroupId
      serverNamePrefix: serverNamePrefix
      elasticPoolNamePrefix: elasticPoolNamePrefix
    }
}