no option to create Named Replica

[lipalath-ms]

I don't see an option to create Named Replica in Sql Database in Azure:

---

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

• ID: a0a72cbf-eebe-648a-8144-f32af0f73540
• Version Independent ID: ab547073-72b2-5cd5-e699-c94adb969a9a
• Content: Hyperscale secondary replicas - Azure SQL Database
• Content Source: azure-sql/database/service-tier-hyperscale-replicas.md
• Service: sql-database
• Sub-service: service-overview
• GitHub Login: @yorek
• Microsoft Alias: damauri

[ManoharLakkoju-MSFT]

@ilantom Thanks for your feedback! We will investigate and update as appropriate.

[shaktisingh-msft]

Hi @ilantom ,

Thanks for sharing the feedback.

I have checked the question about Named Replica of Azure SQL Database Hyperscale, where I am able to create it:

Could you please let us know the configuration you have used for DB creation and Region in use?

Thank you.

[lipalath-ms]

I don't see Replica Configuration when trying to create replica. By default it shows geo replica. Location is west us 2.

Here is the bicep I tried:

resource sqlServer 'Microsoft.Sql/servers@2021-02-01-preview' = {
  name: sqlServerName
  location: location
  identity: {
    type: 'SystemAssigned'
  }
  properties: {
    administratorLogin: sqlAdminUserName
    administratorLoginPassword: sqlAdminPassword
    administrators: {
      administratorType: 'ActiveDirectory'
      principalType: 'Group'
      login: sqlAdministratorsGroupName
      sid: sqlAdministratorsGroupId
      tenantId: tenantId
    }
  }

  resource sqlServerFirewall 'firewallRules@2021-02-01-preview' = {
    name: 'AllowAllWindowsAzureIps'
    properties: {
      startIpAddress: '0.0.0.0'
      endIpAddress: '0.0.0.0'
    }
  }

  resource masterDataBase 'databases@2021-02-01-preview' = {
    location: location
    name: 'master'
    properties: {}
  }

  resource auditingSettings 'auditingSettings@2017-03-01-preview' = {
    name: 'default'
    properties: {
      state: 'Enabled'
      isAzureMonitorTargetEnabled: true
    }
  }
}

resource primaryDatabase 'Microsoft.Sql/servers/databases@2021-02-01-preview' = {
  name: 'jobs'
  parent: sqlServer
  location: location
  sku: {
    name: 'GP_S_Gen5'
    tier: 'GeneralPurpose'
    family: 'Gen5'
    capacity: 4
  }
}

resource readReplicaDb 'Microsoft.Sql/servers/databases@2021-11-01-preview' = {
  name: '${primaryDatabase.name}_R'    
  parent: sqlServer
  location: location   
  tags: {
    tagName1: 'tagValue1'
    tagName2: 'tagValue2'
  }
  sku: {
    name: 'GP_S_Gen5'
    tier: 'GeneralPurpose'
    family: 'Gen5'
    capacity: 4
  }
   properties: {        
      createMode: 'OnlineSecondary'
      maxSizeBytes: -1
      collation: 'SQL_Latin1_General_CP1_CI_AS'
      catalogCollation: 'SQL_Latin1_General_CP1_CI_AS'
      zoneRedundant: false
      licenseType: 'LicenseIncluded'
      readScale: 'Disabled'
      secondaryType: 'Named'
      isLedgerOn: false  
      sourceDatabaseId: primaryDatabase.id
    }    
}

---

From: shaktisingh-msft @.> Sent: Monday, May 1, 2023 11:04 PM To: MicrosoftDocs/azure-docs @.> Cc: Lisa Palathingal @.>; Mention @.> Subject: Re: [MicrosoftDocs/azure-docs] no option to create Named Replica (Issue #108955)

Hi @ilantomhttps://github.com/ilantom ,

Thanks for sharing the feedback.

I have checked the question about Named Replica of Azure SQL Database Hyperscale, where I am able to create it:

[image]https://user-images.githubusercontent.com/110027638/235590821-a171d0f0-03ab-4fe4-bba5-877fb9087f05.png

Could you please let us know the configuration you have used for DB creation and Region in use?

Thank you.

— Reply to this email directly, view it on GitHubhttps://github.com/MicrosoftDocs/azure-docs/issues/108955#issuecomment-1530929058, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ABRXZOFPK53BUCOU3KSZFKDXECPUZANCNFSM6AAAAAAXSHIJ7E. You are receiving this because you were mentioned.Message ID: @.***>

[yorek]

You're using the "GeneralPurpose" SKU. Named Replicas are supported only on the Hyperscale SKU

[lipalath-ms]

Could you please confirm if this is correct?

For Geo Replicas,

• both primary & secondary databases should be on different servers.
• can use "GeneralPurpose" SKU

For Named Replicas,

• both primary & secondary databases can be on the same server
• should use "Hyperscale SKU"

[yorek]

for Named Replicas:

• must use "Hyperscale SKU"

[lipalath-ms]

Is it possible to create "Hyperscale - Serverless" SKU?

[yorek]

Yes, it is in public preview: "https://azure.microsoft.com/en-us/updates/public-preview-serverless-hyperscale-in-azure-sql-database/"

[lipalath-ms]

Thank you! How do I update the SKU for server and database?

This is what I use now:

sku: { name: 'GP_S_Gen5' tier: 'GeneralPurpose' family: 'Gen5' capacity: 4 }

[shaktisingh-msft]

Hi @ilantom ,

This forum is for documentation related feedbacks. If you are facing any issue or need help in functionality of Azure Services, please submit your question on Microsoft Q&A portal.

https://learn.microsoft.com/en-us/answers/questions/ask/

please-close