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
Accepted answer
  1. ShaktiSingh-MSFT 13,751 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
Most helpful Newest Oldest