I have a primary database in the Premium service level.

[![enter image description here][1]][1]

I am trying to create a second geo replica to a different region. The primary is in the East Coast, The first replica is in South Central, and now I'm trying to create a second replica in West 2.

The literature states that I can create up to four replicas for a single primary. (I've seen references to the fact that this requires Premium service level so I've boosted the database into the Premium tier.)

https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview?view=azuresql#configuring-secondary-database

> Up to four geo-secondaries can be created for a primary. If there's
> only one secondary, and it fails, the application is exposed to higher
> risk until a new secondary is created. If multiple secondaries exist,
> the application remains protected even if one of the secondaries
> fails. Additional secondaries can also be used to scale out read-only
> workloads.

I've created my first replica and now I'm trying to create the second replica in a different region of course. I'm consistently receiving the same error:

> Replication limit reached. The database 'test' cannot have more than 1
> replication relationships. (Code: GeoReplicaLimitReached)

Can't have more than one replication relationship? But the literature says I should be able to have up to four?

Here is a more complete snapshot of the database configuration.

[![enter image description here][2]][2]

Thanks for your advice!


  [1]: https://i.sstatic.net/LqbuIOdr.png
  [2]: https://i.sstatic.net/DQ8P3y4E.png