This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 57.99999999999999%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
I'm trying to establish geo-replication for an Azure SQL DB but there is no geo-replication option available (see attached screen shot). All the documentation indicates it should be there. What am I doing wrong?
Hi @Rick Hollahan Thank you for posting your question on Microsoft Q&A.
Please follow the steps on how to configure active geo-replication in Azure SQL to create a geo-replication in Azure.
Hope that help
Regards,
Oury
Hi @Rick Hollahan Checking if the answer above was helpful. Please mark as accepted answer if the information was helpful. Otherwise let us know how we can better assist .
Regards,
Oury
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 14.000000000000002%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
Hi @ OuryBa-MSFT,
I do not have the Geo-Replication Option in the SQL Database Settings. When I click on the 'Create Replica' inside the Replicate option I get a form with most textboxes grey out and an error on it too.
I am the owner of the SQL instance and have got a Subscription but using my College account. Could this be the problem?
Regards,
Franz
In the screenshot you have shared above, I can see the replicas option You just need to click on that button to create a geo-replication.
Like I did below.
https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview#configuring-secondary-database
https://techcommunity.microsoft.com/t5/azure-sql-blog/active-geo-replication-for-azure-sql-hyperscale-now-in-preview/ba-p/2278570
Regards,
Oury