I have a primary database in the Premium service level.
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.)
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.
Thanks for your advice!