Skip to main content
Added a more complete snapshot of the database configuration.
Source Link

I have a primary database in the Premium service level.

enter image description here

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

Thanks for your advice!

I have a primary database in the Premium service level.

enter image description here

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?

Thanks for your advice!

I have a primary database in the Premium service level.

enter image description here

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

Thanks for your advice!

Source Link

Why can't I create more than 1 geo replica for my primary database?

I have a primary database in the Premium service level.

enter image description here

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?

Thanks for your advice!