Creating Geo Replica is stuck at Accepted state

Saravanan Srithar 26 Reputation points Microsoft Employee
2022-10-31T03:14:54.68+00:00

Hi,
I am trying to setup a Geo-Replica for my Azure SQL Hyperscale database and its been sitting on Accepted State with Seeding 0% for about 6 hours. The database does not seem to be created in the Geo-Replica server and replication does not seem to have started. Need some help and advice to troubleshoot the issue and resolve it. Can someone please help?

Thanks!

Azure SQL Database
{count} vote

Accepted answer
  1. ShaktiSingh-MSFT 14,186 Reputation points Microsoft Employee
    2022-10-31T05:13:14.977+00:00

    Hi @Saravanan Srithar ,

    Welcome to Microsoft Q&A platform and thanks for using Azure Services.

    As I understand, Geo Replication is stuck for Azure SQL Hyperscale database with Seeding as zero percent.

    Please check below pointers:

    Geo-replicas must be created on a different logical server. The database name of a geo-replica always matches the database name of the primary.

    Geo-replication for Hyperscale database has following current limitations:

    Only one geo-replica can be created (in the same or different region).
    Point in time restore of the geo-replica is not supported.
    Secondary of a secondary (also known as "geo-replica chaining") is not supported.

    Please let us know if Geo Replica meets all criteria mentioned here for Azure SQL Hyperscale Database. Awaiting your reply.


0 additional answers

Sort by: Most helpful