Sample Header Ad - 728x90

read only replica of azure sql database within the same server

1 vote
1 answer
786 views
I have the following bicep to create a sql server and sql database:
resource sqlServer 'Microsoft.Sql/servers@2021-02-01-preview' = {
  name: sqlServerName
  location: location
  identity: {
    type: 'SystemAssigned'
  }
  properties: {
    administratorLogin: userName
    administratorLoginPassword: password
    administrators: {}
  }

  resource sqlDataBaseOne 'databases@2021-02-01-preview' = {
    name: 'databaseone'
    location: location
    sku: {
      name: 'GP_S_Gen5'
      tier: 'GeneralPurpose'
      family: 'Gen5'
      capacity: 4
    }
  }
}
Is it possible to create read only replica of databaseone within the same server? I only see Geo-Replica option on trying to create a replica for which replica is on a different server: enter image description here
Asked by user989988 (111 rep)
May 1, 2023, 10:05 PM
Last activity: May 2, 2023, 04:21 PM