Microsoft.Sql/locations/instanceFailoverGroups - how to use

[cmptscpeacock]

Hi all,

Does anyone know how to use the bicep for Microsoft.Sql/locations/instanceFailoverGroups ?

https://learn.microsoft.com/en-us/azure/templates/microsoft.sql/locations/instancefailovergroups?pivots=deployment-language-bicep

It's looking for a parent, which I guess is Microsoft.Sql/locations but I don't know how or what Microsoft.Sql/locations is.

Any help would be great

TIA

[brwilkinson]

HI @cmptscpeacock how did you go with this one?

You can try with the following syntax

resource FG 'Microsoft.Sql/locations/instanceFailoverGroups@2022-05-01-preview' existing = {
  name: 'eastus/fg'
}

output FG object = FG

You can review the PowerShell cmdlets for more info.

https://learn.microsoft.com/en-us/powershell/module/Az.sql/new-Azsqldatabaseinstancefailovergroup?view=azps-9.6.0#example-2

e.g.

$failoverGroup = New-AzSqlDatabaseInstanceFailoverGroup -Name fgName -Location location -ResourceGroupName rg -PrimaryManagedInstanceName $managedInstance.Name -PartnerRegion $partnerRegion -PartnerManagedInstanceName $partnerManagedInstance.Name -FailoverPolicy Manual

ResourceGroupName : rg
Location : East US
Name : fg
PartnerResourceGroupName : rg
PartnerRegion : West US
PrimaryManagedInstanceName : managedInstance1
PartnerManagedInstanceName : managedInstance2
ReplicationRole : Primary
ReplicationState : CATCH_UP
ReadWriteFailoverPolicy : Manual
FailoverWithDataLossGracePeriodHours :
ReadOnlyFailoverPolicy : Disabled
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/rg/providers/Microsoft.Sql/locations/eastus/instanceFailoverGroups/fg

notice the id of the resource: Microsoft.Sql/locations/eastus/instanceFailoverGroups/fg

[brwilkinson]

Hi @cmptscpeacock please provide an update if you are able to get this working with the above notation?

[cmptscpeacock]

@brwilkinson

Thanks, yes this worked as you suggested. My module:

param name string
param sqlManagedInstanceFailoverGroupName string
param properties object

#disable-next-line BCP081
resource sqlMI 'Microsoft.Sql/locations@2022-05-01-preview' existing = {
  name: name
}

resource sqlManagedInstanceFailoverGroup 'Microsoft.Sql/locations/instanceFailoverGroups@2022-05-01-preview' = {
  name: sqlManagedInstanceFailoverGroupName
  parent: sqlMI
  properties: properties
}

output sqlManagedInstanceFailoverGroupHostNameOutput string = sqlManagedInstanceFailoverGroup.name

[brwilkinson]

@cmptscpeacock thank you for the update.