High-Availability and Disaster Recovery functionality, for SQL Server 2012 and later. A primary read/write database and up to 4 secondary database for reporting or disaster recover. There are several fail over and configuration options
Questions tagged [alwayson]
196 questions
0
votes
1 answer
SQL Server Availability Groups Usecase - 2 AGs on 1 machine
My knowledge about AG is very limited and I'm not a DBA.
We have 4 machines - each of them is hosting two databases, say DB1 and DB2. DB1 is has its own AG (say AG1) which is replicated to other 3 machines, and DB2 also has its own AG (say AG2)…
Sanjeev Dhiman
- 1,169
- 1
- 11
- 20
0
votes
1 answer
High response duration on first request for .net core api on Azure
I have deployed a .Net Core API to Azure as an App Service.
I have set the Always on feature to true.
When I log the requests, I see that Azure Always on requests are coming every 5 minutes.
My usage with API is HTTPS but Always on requests are…
Kubilay Bayraktar
- 51
- 4
0
votes
2 answers
SQL Server Distributed Availability Group (DAG) Failover
I have a distributed SQL Server (Always On) High Availability Group, using SQL Server 2016, with the purpose of disaster recovery. The servers exist in different datacenters, and the primary is doing async commits to the Distributed AG. I want to…
0
votes
1 answer
I want to export my AlwaysOn configuration by T-SQL
I am curently testing an AlwaysOn SQL Server 2019 environment and I want to check some things before we go live.
For example, I want to drop/recreate the listener. After this, I want to revert the settings to the one our provider used. So I searched…
Wilfred van Dijk
- 89
- 4
0
votes
1 answer
Always On: could a slow replication connection affect the client overall performance?
I have read in this blog article:
https://www.sqlservercentral.com/blogs/alwayson-data-synchronization-in-synchronous-and-asynchronous-mode
the following:
If the secondary replica is configured to run in synchronous mode, it will send an…
IgnacioJ
- 105
- 11
0
votes
1 answer
Always On: Could select queries in a synchronous secondary replica affect queries in the primary replica?
It is a usual piece of advice to redirect select queries to a secondary replica by declaring the connections as read-only. But I have a doubt regarding this.
I know two facts:
Transactions created in the primary replica must be commited first in…
IgnacioJ
- 105
- 11
0
votes
1 answer
SQL Server Always on configuration without backup restore
The secondary server is very far from the primary server. The database size is too huge to copy over the internet. Physically copying the file to an external device and then taking it over to the secondary site, copying it back in a drive to the new…
Kasim Husaini
- 392
- 3
- 14
0
votes
1 answer
about always on database replication
I added database in sql server always on structure , and database still restoring in secondary replica.
How can I find out percentage of replication ? Is there any query etc?
Thanks.
0
votes
1 answer
Pacemaker configuration for SQL Server Always-on
Recently, I have installed and configured a Cent-OS 7 Linux cluster using pacemaker for making SQL Server 2019 high available. I have changed SQL Server default TCP Port 1433 to something else, and then realized that Pacemaker daemon couldn't bring…
Farshid
- 1
- 1
0
votes
2 answers
Transaction log backup does not shrink after removing from Always on - log_reuse_wait_desc "availability replica"
Transaction log keeps growing and cannot be shrunk after taking the database out of availability group. when I check the log_reuse_wait_desc, it says “availability replica”. but the Database has been removed from AG. I am confused and not sure what…
Bala
- 1
- 1
0
votes
0 answers
How to deploy SQL schema changes to Always On Availability group via Azure pipeline?
We have the following setup - 2 SQL servers(01 & 02) configured as AlwaysOn with a listener node/alias (LT) pointing to which server is currently primary(01/02).
What would be the best way to configure an Azure DevOps pipeline to deploy changes to…
BDZ
- 43
- 8
0
votes
1 answer
I have problem when I config a distributed always on availability group
I have 4 virtual machines with SQL Server 2017
Two machines IP are x.x.190.5 and x.x.190.6; these machine have first always on availability group (AVG01)
And the other machines IP x.x.189.1 and x.x.189.2; these machine have second always on…
Mahdi Rahimi
- 564
- 4
- 22
0
votes
0 answers
AlwaysOn secondary replica unable to switch as primary replica SQL Server
Problem: we have a 2 node SQL Server AlwaysOn Basic AG setup, where we're unable to failover the AG groups to the current secondary replica and make it the primary replica.
Right now all the databases are in sync across 2 nodes with zero latency. If…
Rykin
- 1
0
votes
1 answer
Dedicated Backup only replica in AlwaysOn SQL Server
I have an availability group with 3 replicas, as below:
Node1: Sync Commit, Automatic Failover
Node2: Sync Commit, Automatic Failover
Node3: (Sync or Async) Commit, <===================I do not want this node to become Primary replica
In the…
Vahid Farahmandian
- 6,081
- 7
- 42
- 62
0
votes
0 answers
Windows Failover cluster error on (SQL Server 2012 Always On)
We have configured AG in SQL Server 2012. AG has 3 nodes, one node (for example server 1) is primary replica with manual failover, and one node (server 2) is configured for secondary replica with automatic failover, one node(server 3) is configured…
Sumit Kumar Majhi
- 11
- 2