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,657 questions
0
votes
1
answer
60
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
51
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,548
0
votes
1
answer
56
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
104
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,548
0
votes
0
answers
138
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
99
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
72
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
100
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
55
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,248
0
votes
2
answers
51
views
Maintenance Solution on Contained Availability Groups
When dealing with Contained Availability Groups are you installing Ola's Maintenance Solution while connected through the listener or separately on each replica?
2
votes
1
answer
111
views
What are the downsides of running a Physical Only Database Integrity Check job
I am unable to find an article yet, that is able to clearly help my understanding of the risks I run by running my Ola Hallengren DatabaseIntegrityCheck job with PHYSICALONLY parameter on our large ...
- 439
0
votes
1
answer
47
views
What is a "scan request" in the context of Availability Groups?
The documentation for sys.dm_hadr_database_replica_states states
1 = Synchronizing. For a primary database, indicates that the database is ready to accept a scan request from a secondary database. ...
- 1,248
0
votes
0
answers
37
views
Duration of DatabaseIntegrityCheck SQL Agent job
I am trying to estimate likely duration of the DatabaseIntegrityCheck SQL Agent job for our AG PROD environment based on its duration in the Test stand-alone environment and I would appreciate ...
- 439
3
votes
1
answer
119
views
AG DMK/SMK Issue SQL server 2022 CU20
I’m currently working on a proof of concept (POC) involving column-level encryption and key management (SMK/DMK) in a SQL Server 2019 Always On Availability Group (AG) environment (CU20). I’ve tested ...
0
votes
2
answers
102
views
Data Loss warning when trying to do failover even though Synchronized on SQL Server 2019
Data Loss warning when trying to do failover even though Synchronized on SQL Server 2019. This is a basic availability group running in a cluster-less installation.
In the dashboard I see this:
This ...
- 361