Stack Overflow
Stack Overflow

Questions tagged [geo-replication]

44 questions
11
votes
2 answers

SQL Azure Geo Replication for non-redunancy purposes

I'm just doing a little research on how to build a large-scale, globally accessible application on Azure. There's lots of tech in there already to get your application as close to the consumer as possible. CDN Edge Servers for static content shared…
Eoin Campbell
  • 43,500
  • 17
  • 101
  • 157
10
votes
1 answer

How do I recreate a user/login on a SQL Azure Active Geo-Replication Secondary

I have a Premium P2 SQL Azure Database for my Production App, and for security reasons I've created DB Specific Schemas/Views/Roles and a specific DB User account for reading the Data from SSRS Queries. Lets just call the server PRIMARY and my…
Eoin Campbell
  • 43,500
  • 17
  • 101
  • 157
4
votes
4 answers

How should logins and users be created on a geo-redundant database in Azure?

I need to create a login and user on a geo-replicated database. The user will be granted the role of 'db_datareader' on this database. The attempted approach has been to use the SID (same identity) parameter, as follows: -- 1. PRIMARY_DATABASE: Run…
steffar
  • 379
  • 5
  • 9
3
votes
2 answers

Rename a database on Azure SQL Managed Instance that is part of geo-replication

I have an Azure SQL Managed Instance that is set up with geo-replication. I have a database on this MI that I want to swap out with another database by renaming them: ALTER DATABASE mydb MODIFY NAME = mydb_old; ALTER DATABASE mydb_new MODIFY NAME…
Brad Crandell
  • 850
  • 1
  • 8
  • 22
3
votes
1 answer

Speed and Impact of Azure SQL Geo-Replication Sync

I have a client who's Azure SQL database was accidentally created in a European datacenter (the client is in the US). I was hoping to move it to the US using Geo-Replication to minimize downtime as outlined…
Brent
  • 501
  • 3
  • 13
3
votes
1 answer

Can't Deploy to Azure SQL Database inside a Azure Failover Group using DacFX

I can't deploy to an Azure SQL Database inside an Azure Failover Group using the Read/write listener endpoint from VS2015/17 database project publish or using DACFx? I'm using a contained user with appropriate permissions and have proved it works by…
kmkelly
  • 56
  • 4
2
votes
0 answers

SQL Server Change Tracking on an Azure replicated DB

I have a requirement of a syncing set of tables (with data) to a different database from our production database. This is an Azure SQL DB. I created replicated DB (using Azure Geo Replication) and it is a read-only DB. My plan was to enable SQL…
Thilok Gunawardena
  • 924
  • 5
  • 22
  • 44
2
votes
1 answer

Geo-replicating and traffic routing an Azure hosted ASP .Net 5 site and backing SQL database across continents

I have built an ASP .Net 5 website and web API and the schema for a backing SQL database. I now want to move beyond test and deploy them to Azure. I would like to replicate the entire service (ASP and SQL) across continents so that people who use…
dumbledad
  • 16,305
  • 23
  • 120
  • 273
1
vote
0 answers

How queue trigger based Azure function failover to secondary when RA-GRS enabled storage account's primary is location down?

Enabled Azure storage account with RA-GRS replication which enables read from secondary when primary goes down. There is a queue triggered Azure function listen to the queue which is configured to primary region. Now if primary region not available,…
pingpong2020
  • 95
  • 5
1
vote
2 answers

How can i set configuration string in App Service when using Geo-Replication in Azure?

I have a SQL Database in Azure, I have geo-replicated. I am simulating a failover by using the "force failover" in Azure. One question , since the app service that connected to the primary has a connection that relies on the sql server that lives in…
Abbey
  • 153
  • 2
  • 11
1
vote
1 answer

Azure Event Hubs - Geo-Recovery: does it replicate to the Secondary region?

As per the Microsoft article - https://learn.microsoft.com/en-us/azure/event-hubs/event-hubs-geo-dr By design, Event Hubs geo-disaster recovery does not replicate data, and therefore you cannot reuse the old offset value of your primary event hub on…
One Developer
  • 99
  • 5
  • 43
  • 103
1
vote
1 answer

Azure SQL - would Geo-replication cause any performance impact?

I have an Azure SQL in WEST US and I want to setup the failover grop with EAST US. would Azure SQL Geo-replication/failover group cause any performance impact? If so, what would be the impact?
One Developer
  • 99
  • 5
  • 43
  • 103
1
vote
1 answer

Azure SQL Database Geo Replication With Large Table

We are getting ready to move our non-Azure db to Azure Sql Database and are wanting to use Geo-Replication as a failover. Our audit table has 130+ Million rows of data and so just wondering how long the seeding process will take? Also do we have to…
77Vetter
  • 209
  • 3
  • 16
1
vote
1 answer

Do I need to disable active geo-replication on Azure SQL Database prior to update

I'm using active geo-replication on a production Azure SQL Database for failover scenario's. (https://learn.microsoft.com/en-us/azure/sql-database/sql-database-geo-replication-overview) Soon we'll be performing an upgrade of our application that…
ewitkows
  • 3,528
  • 3
  • 40
  • 62
1
vote
1 answer

If I create an Geo-replicated sql database in azure, what database does the user connect to?

For example, if I have a database in North America and replicate it in Europe, will a European user automatically connect to the replicated database in Europe?
konrad
  • 11
  • 1
1
2 3