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:

Asked by user989988
(111 rep)
May 1, 2023, 10:05 PM
Last activity: May 2, 2023, 04:21 PM
Last activity: May 2, 2023, 04:21 PM