CARVIEW |
Select Language
HTTP/2 200
date: Thu, 24 Jul 2025 00:38:55 GMT
content-type: text/html; charset=utf-8
cf-ray: 963f5b80acd88a2a-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=bcc429d9-d945-4441-bba2-4722fb2399b5; expires=Fri, 24 Jul 2026 00:38:55 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: a0afc6bf-8189-42da-9fc1-cec17cdf8878
x-worker-origin-response-time: 578000000
x-dns-prefetch-control: off
set-cookie: prov=bcc429d9-d945-4441-bba2-4722fb2399b5; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=sX.CvLAHC7k2dR3GjS6jXRhC_6xJPNjcrfdC_FWLENs-1753317535-1.0.1.1-8402CCxzXSLqKd9RSgOA1vJzUeZJxa1xBJQxb7IZnQf58sC0PEmnW7Lut6N8JozVa8MotlczaLj2SCYum01Hr8Tr7t4N1nmDyW2DhtwMDrQ; path=/; expires=Thu, 24-Jul-25 01:08:55 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=PbYuGecFCLNTaMewa80Sez17Fkzpi2Lwy_sqMYw963Y-1753317535412-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'availability-groups' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack ExchangeTeams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions 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,652 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
2
votes
1
answer
57
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 ...
0
votes
1
answer
25
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. ...
0
votes
0
answers
27
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 ...
2
votes
1
answer
45
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
50
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 ...
0
votes
1
answer
26
views
Shrinking log files on AG to manage VLF's
some of our databases have excessive VLF's in their log files and I plan to shrink and then grow them to an appropriate size. I'm going to use the Tiger Team script https://github.com/microsoft/...
0
votes
1
answer
57
views
Is last_commit_time in sys.dm_hadr_database_replica_states RPO or something else?
My Question, Up Front
I've inherited some monitoring that hinges on the last_commit_time column in sys.dm_hadr_database_replica_states. My problem is that the documentation for this column is all over ...
2
votes
1
answer
86
views
Failover of of SQL Server Distributed Availability Group
Following the steps in Manual Failover of SQL Server DAG
To verify if both Availability Groups are ready for failover, use the T-SQL query below, running in SQLCMD Mode:
:CONNECT TDPRD071
SELECT ag....
1
vote
1
answer
93
views
SQL Server AlwaysOn secondary with different compatibility
I'm inquiring about SQL Server version compatibility in a primary-secondary configuration for Always-On avaiability groups.Specifically, I'd like to know if it's possible and recommended to have a ...
1
vote
0
answers
75
views
Are there exactly two possible causes of statistics updates on a readable replica?
I have a table that is modified regularly. Due to these frequent modifications, statistics update on it very frequently. To my surprise, I even see queries running on a SQL Server 2022 readable ...
0
votes
1
answer
88
views
Track AlwaysOn sync progress
Is it possible to somehow track the progress of AlwaysOn database synchronization? This is necessary in order to estimate the approximate time of the end of database synchronization.
When adding a ...
3
votes
1
answer
110
views
CHECKDB works on an Enterprise Edition readable secondary, but not CHECKCATALOG
I have an Enterprise Edition SQL Server 2022 cluster with multiple AGs.
Two of the AGs consider different instances primary. Both of these consider their secondaries readable and are correct to think ...
0
votes
1
answer
53
views
query to find the latest transactional backup for a server involved in availability group
I got a query to find the latest transactional log backup.
in this particular server it is not working for some reason.
here is the query:
SELECT
@@Servername AS [Server_Name],
B.name AS ...
1
vote
1
answer
67
views
SQL Availability Group and File Server Role Using the Same DNS Name
I'm tasked with setting up a 2 node cluster that will host a MS SQL availability group. I have the servers setup and the AG looks to be working as expected. However, there is another requirement to ...
0
votes
1
answer
51
views
Removing multiple large databases from a SQL Server Availability Group
I am planning on removing multiple large databases from an AG but do not have a suitable test environment to test my script on.I only have a test environment for databases which are much smaller in ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
sql-server × 1308
sql-server-2012 × 245
sql-server-2016 × 229
clustering × 220
sql-server-2014 × 210
high-availability × 162
failover × 118
sql-server-2017 × 105
sql-server-2019 × 78
backup × 75
listener × 58
transaction-log × 50
replication × 43
disaster-recovery × 41
windows-server × 32
hadr × 27
performance × 24
sql-server-2022 × 21
configuration × 20
restore × 20
mirroring × 19
azure-vm × 18
azure × 17
more related tags
Hot Network Questions
- TeX development in C instead of Pascal
- Sum of ranks of blocks
- Finding the value of collector resistor
- What does this "lightbulb-ish" symbol mean in figure 1 of the Diffie Hellmann paper?
- Distribution of a dot product of multinomial variables
- When is XLOOKUP() faster than VLOOKUP()?
- Why is `&self` allowed in the parameters of `&mut self` methods, but not `&mut self`?
- Render / Convert .midi / .mid to FLAC on Linux
- Guitar Intonation - Flat On Certain Frets
- In QGIS installed via OSGeo4W on Windows 11, what is the path to the command history file for the Python console?
- Pourquoi "better to use ne alone" dans ce cas, "with savoir followed by an indirect question"?
- Are birth control pills as carcinogenic as asbestos and tobacco?
- Distance of superdense color code circuits
- Praesul meorum tattoo
- Story about a room on Mars that contains God
- Do the constructible lines and circles (not merely their intersections) cover the plane?
- How can I automatically replace curly braces { and } in LaTeX macro arguments—e.g., in math formulas—for label generation?
- SOSL/SOQL isn't returning User records
- Did Webster's Dictionary define Fascism by its relationship to corporations until 1987?
- Expected Sum of Remaining Dice After Removing Complete Sets
- Can authors be blacklisted by academic publishers for multiple rejections without any ethical misconduct?
- Is there a way to move the cursor specifically to the beginning of the visually selected region (not just toggle like `o`)?
- Do standing sound waves sound different?
- How do mechanical gyros maintain rotational speed?