What dont I see the "Convert to Standby" on a Geo Replication setup of Azure SQL

Question

I have an Azure SQL server and have setup geo-replication for the databases on that server.

Since we are only going to be using the replica for DR purposes, we want to switch it from geo-replica to standby-replica.

According to https://learn.microsoft.com/en-us/azure/azure-sql/database/standby-replica-how-to-configure?view=azuresql&tabs=azure-portal#convert-existing-replica there is a possibility to convert the replica to standby and there is apparently an option to "Convert to Standby". However I see no such option.

Does anyone know why I am not getting that option?

Answer 1

Hi Mulla, Tabrez •

I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.

Solution:

If the databases are part of an elastic pool, you do not see the option "Convert to Standby". All our databases are part of elastic pools.

If you have any other questions or are still running into more issues, please let me know. Thank you again for your time and patience throughout this issue.

Please remember to "Accept Answer" if any answer/reply helped, so that others in the community facing similar issues can easily find the solution.

Thank you!

Answer 2

Hi Mulla, Tabrez •

Welcome to Microsoft Q&A forum.

As I understand, you do not see an option "Convert to Standby" on a Geo Replication setup of Azure SQL.

Could you please let us know the Compute Tier for your Azure SQL?

Please note below Limitations:

• Only one secondary database replica can be designated for standby.
• The serverless compute tier isn't supported. Standby replica can't be enabled if the primary or secondary database is in the serverless compute tier.
• The DTU purchasing model isn't supported. You can enable a standby replica for databases using the vCore purchasing model only.
• The Hyperscale service tier isn't supported. Only databases in the General Purpose and Business Critical service tiers can be designated for standby.
• When using a failover group, standby rights are assigned at the database level, not the failover group level, and must be assigned separately for each database within the failover group.
• Designating a secondary replica for standby isn't supported when the replica is a secondary replica of a secondary replica (a process known is chaining).

Also, please share screenshot and configuration details of your Azure SQL Database so that we can help.

A primary provisioned vCore Azure SQL Database in the General Purpose or Business Critical service tier running on supported hardware is a prerequisite.

Awaiting your reply.

Thanks