Availability Groups

Get up to speed on SQL Server AlwaysOn Availability with these valuable tips, tutorials, how-to’s, scripts, and more perfect for SQL Server DBAs.

Title Author Date
Troubleshoot SQL Server Always On Availability Groups with AGDiag Edwin Sarmiento2026-06-27
Correct SQL Server Always On Availability Group Not Synchronizing Vincent Jiang2026-06-22
SQL Server Contained Availability Groups Configuration Edwin Sarmiento2026-06-22
How To Build a Windows Server 2025 Failover Cluster Aleksey Vitsko2026-06-19
Enable TDE for Databases in a SQL Server AlwaysOn Availability Group Jan Potgieter2026-06-02
What is SQL Server AlwaysOn? Simon Liew2025-06-16
Troubleshoot SQL Always On Availability Groups with SQL LogScout Edwin Sarmiento2024-04-25
Failover to Always On Availability Group Replica in DR Site Muhammad Kamran2023-04-10
How to Upgrade SQL Server 2012 AG to SQL Server 2019 AG Muhammad Kamran2022-11-21
Migrate SQL Server Databases to Different Active Directory Domain Edwin Sarmiento2022-06-13
Distributed Availability Groups to Migrate SQL Server Databases – Part 2 Edwin Sarmiento2022-05-26
Distributed Availability Groups to Migrate SQL Server Databases – Part 1 Edwin Sarmiento2022-05-17
Perform Maintenance on SQL Server Availability Groups Edwin Sarmiento2021-10-19
Distributed Availability Groups for SQL Server Disaster Recovery Edwin Sarmiento2021-10-01
Read-Scale Always On Availability Group to Offloading Reporting Edwin Sarmiento2021-07-29
SQL Server Read-Scale Always On Availability Groups Edwin Sarmiento2021-07-01
Powershell Commands for SQL Server Always On Availability Groups Alejandro Cobar2021-03-31
Multi-Site SQL Server Always On Availability Groups Manvendra Singh2021-03-30
Configure Always ON Availability Groups between Two SQL Server FCIs Manvendra Singh2021-03-22
Create an Always On Availability Groups using TSQL Alejandro Cobar2021-03-19
SQL Server 2016 Availability Group Issue with Automatic Seeding Alejandro Cobar2021-03-10
SQL Server Monitoring for all Availability Groups Alejandro Cobar2020-12-24
SQL Server Availability Group Error 35246 missing sqlconf.dll Alejandro Cobar2020-12-22
Manual Failover of SQL Server Always On Distributed Availability Group for Disaster Recovery Testing Edwin Sarmiento2020-05-28
Queue table issues with Availability Groups in SQL Server Aaron Bertrand2020-01-29
SQL Server Distributed Availability Groups with On-Premises and Azure Instances Ayman Elnory2019-03-21
Misaligned log IOs which required falling back to synchronous IO Atul Gaikwad2019-02-25
Always On Availability Groups Monitoring and Alerting – Part 2 Alejandro Cobar2018-12-03
Dedicated Network for Always On Distributed Availability Groups Data Edwin Sarmiento2018-11-30
Always On Availability Group Inventory and Monitoring Scripts – Part 1 Alejandro Cobar2018-11-15
Adding a Database to an existing SQL Server Always ON Configuration Manvendra Singh2018-05-03
Install and Configure SQL Server 2017 Availability Groups on Linux – Part 5 Edwin Sarmiento2018-05-01
Install and Configure SQL Server 2017 Availability Groups on Linux – Part 4 Edwin Sarmiento2018-04-06
Orphaned User Detection for SQL Server High Availability Databases Graham Okely2018-03-15
Creating a SQL Server Availability Group Dashboard for All Servers Tracy Boggiano2018-03-14
Monitoring SQL Server Availability Group Direct Seeding Mark Wilkinson2018-02-15
Fixing Error 19405 When Configuring SQL Server Availability Groups Manvendra Singh2018-02-05
Monitoring SQL Server Availability Groups with AlwaysOn Extended Events Health Session Tracy Boggiano2018-01-30
Install and Configure SQL Server 2017 Availability Groups on Linux – Part 3 Edwin Sarmiento2018-01-17
Add a SQL Server Database to an Existing Always On Availability Group Manvendra Singh2018-01-16
Install and Configure SQL Server 2017 Availability Groups on Linux – Part 2 Edwin Sarmiento2018-01-08
Automate refresh of a SQL Server database that is part of an Availability Group Atul Gaikwad2017-12-14
Drop Login issues for logins tied to SQL Server Availability Groups Svetlana Golovko2017-12-06
Install and Configure SQL Server 2017 Availability Groups on Linux – Part 1 Edwin Sarmiento2017-11-22
Join a Secondary SQL Server Database to an AlwaysON Availability Group Manvendra Singh2017-10-24
Remove SQL Server AlwaysOn Database from Primary Replica Manvendra Singh2017-10-11
SQL Server AlwaysOn Availability Groups Using an Azure Template Mohammed Moinudheen2017-10-03
Remove Database from SQL AlwaysON Availability Group Secondary Replica Manvendra Singh2017-09-26
Configure Dedicated Network for SQL Always On Availability Groups Edwin Sarmiento2017-09-21
Setup SQL Server 2016 Always On Distributed Availability Groups Edwin Sarmiento2017-08-29
Create and Configure SQL Server 2016 Always On Availability Groups using Windows PowerShell Edwin Sarmiento2017-08-08
Setup SQL Server Always On Basic Availability Groups Edwin Sarmiento2017-08-01
Implement SQL 2016 Availability Group without Active Directory Part 2 Edwin Sarmiento2017-07-27
Implement SQL 2016 Availability Group without Active Directory Part 1 Edwin Sarmiento2017-07-19
SQL Server AlwaysOn Availability Group Backup Preference Setting Simon Liew2017-07-14
Error 1408 Joining database on secondary replica resulted in an error Manvendra Singh2017-06-28
Recover WSFC using Forced Quorum for SQL Server AlwaysOn Availability Group Simon Liew2017-06-15
Fix SQL Server AlwaysOn Error: 35250 Failed to Join the Availability Group Manvendra Singh2017-04-05
Remove SQL Server AlwaysOn Availability Group Configuration Manvendra Singh2017-03-28
Removing a Secondary Replica from a SQL Server AlwaysON Availability Group Manvendra Singh2017-01-05
Add secondary replica to existing SQL Server AlwaysON Availability Group Manvendra Singh2016-12-26
SQL Server Always On Availability Group on Multi-Subnet Cluster Manvendra Singh2016-12-16
SQL Server 2016 Availability Group Automatic Seeding Simon Liew2016-11-23
Connect to SQL Server Availability Group replica with SSMS Vitor Montalvao2016-10-14
SQL Server AlwaysOn Availability Group Endpoint Encryption Algorithm Compatibility Error Ahmad Yaseen2016-05-20
Using Extended Events to Monitor SQL Server Availability Groups Carla Abanes2015-02-25
Manual SQL Server Availability Group Failover Carla Abanes2015-02-18
SQL Server Alerts and Notifications for AlwaysOn Availability Groups Carla Abanes2015-01-20
How to resolve connectivity issues with SQL Server Availability Groups Carla Abanes2014-11-21
SQL Server AlwaysOn Availability Groups Fail the Initial Failover Test Carla Abanes2014-08-18
Making the most out of your secondary replica for SQL Server AlwaysOn Availability Groups Carla Abanes2014-06-26
Finding Primary Replicas for SQL Server 2012 AlwaysOn Availability Groups with PowerShell Brian P ODwyer2014-04-14
Add SQL Server Always On Availability Groups to Failover Cluster Bhaskar Sarma2014-02-21
Configuring TDE for SQL Server Always On Availability Groups Edwin Sarmiento2013-12-31
Configuring Alerts for SQL Server AlwaysOn Availability Groups Derek Colley2013-06-11
Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using PowerShell Edwin Sarmiento2013-03-27
Backup SQL Server Always On Availability Groups Databases Chad Churchwell2013-02-13
Configure SQL Server Always On Availability Groups Read-Only Routing Edwin Sarmiento2013-01-29
Enable SQL Server 2012 AlwaysOn Availability Groups with PowerShell Edwin Sarmiento2012-02-20
Monitor SQL Server AlwaysOn Availability Groups Ben Snaidero2012-01-04
SQL Server Always On Availability Groups Setup Brady Upton2011-11-10
SQL Server AlwaysOn Availability Groups – Part 1 configuration Brady Upton2011-11-09