Questions tagged [availability-groups]
Availability Groups are a new feature of SQL Server 2012 that provide continuous data synchronization, automatic failover and secondary read access for one or many SQL Server databases.
1,663 questions
0
votes
1
answer
20
views
Can CREATE DATABASE ... FOR ATTACH be used to seed an Availability Group with a SAN snapshot?
Users of SQL Server 2022 can use SAN snapshots to seed an Availability Group, as shown here. However, this uses 2022 constructs like BACKUP DATABASE ... WITH METADATA_ONLY.
I am on SQL Server 2022, ...
- 1,394
2
votes
1
answer
66
views
After recovering from session timeout expiry, at what point does the primary start waiting on synchronous replicas to harden?
The documentation tells us what happens when session timeout for a synchronous Availability Group replica expires
"Even if a disconnected replica is configured for synchronous-commit mode, ...
- 1,394
2
votes
1
answer
87
views
Stale View Metadata on AlwaysOn Secondary Replica After Table Re-creatio
We encountered an issue with view metadata becoming stale on a readable secondary replica in an AlwaysOn Availability Group. The views on the primary replica worked fine after a fix, but the secondary ...
- 487
2
votes
1
answer
378
views
Do canary tables make sense for Availability Groups?
For all HA or DR solutions in SQL Server, I have heard that it is smart to have a table with a timestamp column in each database and to have an Agent Job run every minute to update that timestamp with ...
- 1,394
2
votes
1
answer
92
views
RDS - connect to HA Secondary without joining domain
I am attempting to connect to the secondary replica in an HA RDS cluster. Usually I do this by connecting to hostname.vpc.local with the master user SQL Auth credential. Today I restored an HA cluster ...
- 5,951
4
votes
2
answers
375
views
@@SERVERNAME Consistency in 3 node SQL Availability Group
We have a 3 node availability group running on SQL 2022.
The application which has its databases hosted on the AG queries @@SERVERNAME as part of licensing checks. If @@SERVERNAME doesn't match what ...
- 347
0
votes
1
answer
76
views
I have a question regarding SQL Always On
I have a question regarding SQL Always On.
We’re setting up a new environment for a critical 24/7 healthcare system. The setup will include three Always On clusters with a total of nine databases, ...
- 1
-1
votes
1
answer
57
views
After a failover to a DR region, the becomes "reverting/in Recovery" in the primary node
we have a 10+TB database. Whenever we failover it, the databases becomes with a session running a null command, with a HADR_DB_COMMAND wait_type.
I believe this is related to a rollback or something? ...
- 7,558
0
votes
1
answer
62
views
SQL Version Upgrade 2017 to 2019 in an unclustered read-scale availability group
We need to upgrade our production SQL servers from SQL 2017 to 2019 (both are Ent. Edition) in the near future. We have ~70 servers hosted in our DC. Each SQL Server instance consists of 2 VMs in a 2 ...
0
votes
1
answer
106
views
Why does dm_hadr_database_replica_states show a different AOAG LAG time than the GUI?
When I'm querying select * from sys.dm_hadr_database_replica_states, I see 11k seconds (3 hours).
But when I go to the AOAG dashboard and select the "Estimated Data Loss (time)" column, it ...
- 7,558
0
votes
0
answers
145
views
SQL Server 2022 Contained AGs and database mail
I have two SQL Server 2022 environments with Contained AG configured with a listener that the users are connecting too. All three have db mail configured identically. The two servers are able to ...
- 2,129
1
vote
1
answer
105
views
Matching TDE Certificates with different names across Always On Replica
I created a TDE certificate on the primary node. I then backed it up and copied the files to the secondary.
When I created the cert on the secondary from the backup files, I accidentally created it ...
- 13
0
votes
1
answer
76
views
DMK in AG: sp_control_dbmasterkey_passwords vs Remove and Re-Add via FULL+LOG Seeding Option
In my Always On AG setup, when I add a database with a Database Master Key (DMK) using auto seeding, the credentials linked to the DMK do not work on the secondary immediately after seeding completes.
...
0
votes
0
answers
153
views
In SQL Always on, Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication
Installed new SQL Always on setup, everything working fine, but when I do fail over form exsting primary to secondary and existing secondary to primary, I am unable to connect with listener name.
Both ...
0
votes
1
answer
58
views
If an Availability Group contains two FCIs, how many quorums do I have?
To have an Availability Group, I must have a Windows Server Failover Cluster. All Windows Server Failover Clusters have the ability to form exactly one quorum. This clearly means that if I have two ...
- 1,394