SQL Server Availability Groups Tips

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.

SubCategoryTitleAuthor
AdministrationHow to Join a Secondary SQL Server Database to an AlwaysON Availability GroupManvendra Singh
AdministrationRemove SQL Server AlwaysOn Availability Group ConfigurationManvendra Singh
AdministrationRemove SQL Server AlwaysOn Database from Primary ReplicaManvendra Singh
AdministrationRemoving a Secondary Replica from a SQL Server AlwaysON Availability GroupManvendra Singh
AutomationAutomate refresh of a SQL Server database that is part of an Availability GroupAtul Gaikwad
BackupsBacking Up SQL Server Databases Participating In AlwaysOn Availability GroupsChad Churchwell
BackupsSQL Server AlwaysOn Availability Group Backup Preference SettingSimon Liew
CompatibilitySQL Server AlwaysOn Availability Group Endpoint Encryption Algorithm Compatibility ErrorAhmad Yaseen
ConfigurationAdd a SQL Server Database to an Existing Always On Availability GroupManvendra Singh
ConfigurationAdd secondary replica to existing SQL Server AlwaysON Availability GroupManvendra Singh
ConfigurationAdding a Database to an existing SQL Server Always ON ConfigurationManvendra Singh
ConfigurationConfigure Distributed Availability Groups for SQL Server Disaster Recovery with Failover ClusteringEdwin Sarmiento
ConfigurationConfigure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using PowerShellEdwin Sarmiento
ConfigurationConfigure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using T-SQLEdwin Sarmiento
ConfigurationConfigure SQL Server AlwaysOn Availability Group on a Multi-Subnet ClusterManvendra Singh
ConfigurationConfiguring a Dedicated Network for SQL Server Always On Availability Groups Data Replication TrafficEdwin Sarmiento
ConfigurationEnable SQL Server 2012 AlwaysOn Availability Groups Using Windows PowerShellEdwin Sarmiento
ConfigurationHow to Configure Always ON Availability Groups between Two SQL Server Failover Cluster Instances - Part 1Manvendra Singh
ConfigurationImplement a SQL Server 2016 Availability Group without Active Directory Part 1Edwin Sarmiento
ConfigurationImplement a SQL Server 2016 Availability Group without Active Directory Part 2Edwin Sarmiento
ConfigurationInstall and Configure SQL Server 2017 Availability Groups on Linux - Part 1Edwin Sarmiento
ConfigurationInstall and Configure SQL Server 2017 Availability Groups on Linux - Part 2Edwin Sarmiento
ConfigurationInstall and Configure SQL Server 2017 Availability Groups on Linux - Part 3Edwin Sarmiento
ConfigurationInstall and Configure SQL Server 2017 Availability Groups on Linux - Part 4Edwin Sarmiento
ConfigurationInstall and Configure SQL Server 2017 Availability Groups on Linux - Part 5Edwin Sarmiento
ConfigurationMaking the most out of your secondary replica for SQL Server AlwaysOn Availability GroupsCarla Abanes
ConfigurationMulti-Site Multi-Cluster SQL Server Installation with Clustering and Availability GroupsManvendra Singh
ConfigurationSetup and Implement SQL Server 2016 Always On Basic Availability GroupsEdwin Sarmiento
ConfigurationSetup and Implement SQL Server 2016 Always On Distributed Availability GroupsEdwin Sarmiento
ConfigurationSQL Server 2016 Availability Group Automatic SeedingSimon Liew
ConfigurationSQL Server AlwaysOn Availability Groups - Part 1 configurationBrady Upton
ConfigurationSQL Server AlwaysOn Availability Groups - Part 2 Availability Groups SetupBrady Upton
ConfigurationSQL Server AlwaysOn Availability Groups Using an Azure TemplateMohammed Moinudheen
ConfigurationSQL Server Availability Group Maintenance with Distributed Availability GroupsEdwin Sarmiento
ConfigurationSQL Server Distributed Availability Groups with On-Premises and Azure InstancesAyman Elnory
ConnectivityHow to resolve connectivity issues with SQL Server Availability GroupsCarla Abanes
Disaster RecoveryStep-by-step Configuration of SQL Server Read-Scale Always On Availability Group on Windows for Disaster RecoveryEdwin Sarmiento
DistributedConfiguring Distributed Availability Groups Between Failover Clusters on Different Active Directory Domains Ė Part 1Edwin Sarmiento
ErrorConnect to SQL Server Availability Group replica with SSMS when Readable Secondary is Read-intent onlyVitor Montalvao
ErrorFixing Error 19405 When Configuring SQL Server Availability GroupsManvendra Singh
ErrorSQL Server misaligned log IOs which required falling back to synchronous IOAtul Gaikwad
FailoverManual Failover of SQL Server Always On Distributed Availability Group for Disaster Recovery TestingEdwin Sarmiento
FailoverManual SQL Server Availability Group FailoverCarla Abanes
FailoverSQL Server AlwaysOn Availability Groups Fail the Initial Failover TestCarla Abanes
InstallationAdding SQL Server AlwaysOn Availability Groups to existing Failover ClustersBhaskar Sarma
LoginsDrop Login issues for logins tied to SQL Server Availability GroupsSvetlana Golovko
LoginsOrphaned User Detection for SQL Server High Availability DatabasesGraham Okely
MaintenanceRemove Database from SQL Server AlwaysON Availability Group Secondary ReplicaManvendra Singh
MonitoringCreating a SQL Server Availability Group Dashboard for All ServersTracy Boggiano
MonitoringFinding Primary Replicas for SQL Server 2012 AlwaysOn Availability Groups with PowerShellBrian P ODwyer
MonitoringMonitor SQL Server AlwaysOn Availability GroupsBen Snaidero
MonitoringMonitoring SQL Server Availability Group Direct SeedingMark Wilkinson
MonitoringMonitoring SQL Server Availability Groups with AlwaysOn Extended Events Health SessionTracy Boggiano
MonitoringPowershell Commands for SQL Server Always On Availability GroupsAlejandro Cobar
MonitoringSQL Server AlwaysOn Availability Groups Inventory and Monitoring Scripts - Part 1Alejandro Cobar
MonitoringSQL Server AlwaysOn Availability Groups Monitoring and Alerting - Part 2Alejandro Cobar
MonitoringSQL Server Monitoring for all Availability GroupsAlejandro Cobar
MonitoringUsing Extended Events to Monitor SQL Server Availability GroupsCarla Abanes
NetworkConfigure a Dedicated Network Adapter for SQL Server Always On Distributed Availability Groups Data Replication TrafficEdwin Sarmiento
NotificationsConfigure SQL Server Alerts and Notifications for AlwaysOn Availability GroupsCarla Abanes
NotificationsConfiguring Alerts for SQL Server AlwaysOn Availability GroupsDerek Colley
OverviewWhat is SQL Server AlwaysOn?Simon Liew
PerformanceQueue table issues with Availability Groups in SQL ServerAaron Bertrand
PowerShellCreate and Configure SQL Server 2016 Always On Availability Groups using Windows PowerShellEdwin Sarmiento
ReportingConfigure a Read-Scale Always On Availability Group on Windows for Offloading Reporting and Analytical WorkloadsEdwin Sarmiento
T-SQLCreate an Always On Availability Groups using TSQLAlejandro Cobar
Transparent Data EncryptionConfiguring Transparent Data Encryption with SQL Server 2012 AlwaysOn Availability GroupsEdwin Sarmiento
TroubleshootingFix SQL Server AlwaysOn Availability Group Error: 1408 Joining database on secondary replica resulted in an errorManvendra Singh
TroubleshootingFix SQL Server AlwaysOn Error: 35250 Failed to Join the Availability GroupManvendra Singh
TroubleshootingRecover WSFC using Forced Quorum for SQL Server AlwaysOn Availability GroupSimon Liew
TroubleshootingSQL Server Availability Group Error 35246 missing sqlconf.dllAlejandro Cobar
TroubleshootingSSISDB and SQL Server 2016 Availability Group Issue with Automatic SeedingAlejandro Cobar
No Records Found
CategoryGroupCategory (articles)
Analysis ServicesAnalysis Services Administration (31)
Analysis ServicesAnalysis Services Development (95)
Analysis ServicesAnalysis Services Dimensions (16)
Analysis ServicesAnalysis Services Measure Groups (7)
Analysis ServicesAnalysis Services Performance (14)
Analysis ServicesAnalysis Services Security (7)
Analysis ServicesAnalysis Services Tools (1)
Analysis ServicesAnalysis Services Tutorials (6)
Analysis ServicesCortana (5)
Analysis ServicesPerformance Point (4)
Business IntelligenceBig Data (23)
Business IntelligenceData Warehousing (4)
CloudAmazon AWS (45)
CloudApache Spark (3)
CloudAzure (187)
CloudAzure Backup and Restore (25)
CloudAzure Cosmos DB (11)
CloudAzure Data Factory (68)
CloudAzure Databricks (23)
CloudAzure Integration Services (14)
CloudAzure Synapse Analytics (33)
Data QualityData Quality Services (7)
Data QualityMaster Data Services (41)
Database AdministrationAvailability Groups (72)
Database AdministrationBackup (78)
Database AdministrationCentral Management Servers (9)
Database AdministrationClustering (73)
Database AdministrationComparison Data and Objects (14)
Database AdministrationCompression (21)
Database AdministrationContained Databases (4)
Database AdministrationContainers (12)
Database AdministrationDatabase Administration (188)
Database AdministrationDatabase Configurations (17)
Database AdministrationDatabase Console Commands DBCCs (25)
Database AdministrationDatabase Mail (18)
Database AdministrationDatabase Mirroring (33)
Database AdministrationDBA Best Practices (39)
Database AdministrationDedicated Administrator Connection (4)
Database AdministrationDeprecated Features (5)
Database AdministrationDevOps (34)
Database AdministrationDisaster Recovery (23)
Database AdministrationError Logs (10)
Database AdministrationExpress Edition (16)
Database AdministrationExtended Events (22)
Database AdministrationFILESTREAM (9)
Database AdministrationFragmentation and Index Maintenance (27)
Database AdministrationHardware (13)
Database AdministrationHigh Availability (3)
Database AdministrationIndexing (82)
Database AdministrationInstall and Uninstall (32)
Database AdministrationLicensing (4)
Database AdministrationLinked Servers (18)
Database AdministrationLocking and Blocking (38)
Database AdministrationLog Shipping (18)
Database AdministrationMaintenance (34)
Database AdministrationMonitoring (115)
Database AdministrationOther Database Platforms (66)
Database AdministrationPartitioning (14)
Database AdministrationPerformance Data Warehouse (4)
Database AdministrationPerformance Tuning (121)
Database AdministrationPolicy Based Management (29)
Database AdministrationPowerShell (126)
Database AdministrationProfiler and Trace (20)
Database AdministrationQuery Store (7)
Database AdministrationRecovery Models (4)
Database AdministrationReplication (75)
Database AdministrationResource Governor (5)
Database AdministrationRestore (40)
Database AdministrationSQL Server 2016 (100)
Database AdministrationSQL Server 2017 (44)
Database AdministrationSQL Server 2019 (19)
Database AdministrationSQL Server 2022 (2)
Database AdministrationSQL Server Configurations (75)
Database AdministrationSQL Server on Linux (76)
Database AdministrationStreamInsight (2)
Database AdministrationSystem Databases (31)
Database AdministrationUpgrades and Migrations (54)
Database AdministrationVirtualization (25)
Database AdministrationWindows Internal Database (1)
Database DevelopmentApplication Development (36)
Database DevelopmentChange Data Capture (14)
Database DevelopmentCommon Runtime Language (12)
Database DevelopmentCommon Table Expressions (3)
Database DevelopmentConstraints (20)
Database DevelopmentData Cleansing for Validation (2)
Database DevelopmentData Science (3)
Database DevelopmentData Types (17)
Database DevelopmentDatabase Design (68)
Database DevelopmentDates (47)
Database DevelopmentDebugging (4)
Database DevelopmentDynamic Management Views and Functions (33)
Database DevelopmentDynamic SQL (7)
Database DevelopmentEntity Framework (13)
Database DevelopmentError Handling (8)
Database DevelopmentFull Text Search (20)
Database DevelopmentFunctions System (64)
Database DevelopmentFunctions User Defined UDF (40)
Database DevelopmentIdentities (17)
Database DevelopmentImport and Export (73)
Database DevelopmentIn Memory OLTP (32)
Database DevelopmentJOIN Tables (21)
Database DevelopmentLanguage Integrated Query LINQ (7)
Database DevelopmentMicrosoft Access Integration (8)
Database DevelopmentMicrosoft Excel Integration (39)
Database DevelopmentMicrosoft Flow (1)
Database DevelopmentPaging (5)
Database DevelopmentPython (36)
Database DevelopmentQuery Optimization (14)
Database DevelopmentQuery Plans (20)
Database DevelopmentR Language (11)
Database DevelopmentScripts (35)
Database DevelopmentService Broker (11)
Database DevelopmentSpatial Data Storage (9)
Database DevelopmentSQL Injection (5)
Database DevelopmentSQL Server Management Objects SMO (3)
Database DevelopmentStored Procedures (27)
Database DevelopmentSynonyms (4)
Database DevelopmentTable Valued Parameters (4)
Database DevelopmentTemp Tables (9)
Database DevelopmentTemporal Tables (13)
Database DevelopmentTesting (31)
Database DevelopmentTransactions (8)
Database DevelopmentTriggers (44)
Database DevelopmentTSQL (294)
Database DevelopmentUser Defined Type UDT (3)
Database DevelopmentViews (13)
Database DevelopmentXML (14)
Integration ServicesData Transformation Services (5)
Integration ServicesIntegration Services Administration (10)
Integration ServicesIntegration Services Analysis Services Tasks (5)
Integration ServicesIntegration Services Best Practices (10)
Integration ServicesIntegration Services Configuration Options (21)
Integration ServicesIntegration Services Connection Managers (5)
Integration ServicesIntegration Services Control Flow Transformations (14)
Integration ServicesIntegration Services Data Flow Transformations (19)
Integration ServicesIntegration Services Development (106)
Integration ServicesIntegration Services Email (3)
Integration ServicesIntegration Services Error Handling (8)
Integration ServicesIntegration Services Excel (14)
Integration ServicesIntegration Services Execute Package Options (8)
Integration ServicesIntegration Services Import and Export Wizard (2)
Integration ServicesIntegration Services NULL Management (4)
Integration ServicesIntegration Services Oracle (4)
Integration ServicesIntegration Services Performance (12)
Integration ServicesIntegration Services Security (7)
Integration ServicesIntegration Services Upgrade (4)
Power PlatformPower Apps (17)
Power PlatformPower BI (128)
Power PlatformPower BI Charts (44)
Power PlatformPower BI Formatting (12)
Professional DevelopmentProfessional Development Books (3)
Professional DevelopmentProfessional Development Branding (13)
Professional DevelopmentProfessional Development Career (17)
Professional DevelopmentProfessional Development Career Planning (16)
Professional DevelopmentProfessional Development Career Transition (4)
Professional DevelopmentProfessional Development Certifications (47)
Professional DevelopmentProfessional Development Community (16)
Professional DevelopmentProfessional Development Conferences (2)
Professional DevelopmentProfessional Development Interview Questions BI (15)
Professional DevelopmentProfessional Development Interview Questions DBA (22)
Professional DevelopmentProfessional Development Interview Questions Developer (6)
Professional DevelopmentProfessional Development Interviewing (38)
Professional DevelopmentProfessional Development Job Search (17)
Professional DevelopmentProfessional Development Management (9)
Professional DevelopmentProfessional Development Recruiters (6)
Professional DevelopmentProfessional Development Resume (13)
Professional DevelopmentProfessional Development Skills Development (18)
Reporting ServicesReporting Services Administration (19)
Reporting ServicesReporting Services Analysis Services (4)
Reporting ServicesReporting Services Best Practices (6)
Reporting ServicesReporting Services Charts (25)
Reporting ServicesReporting Services Configuration (10)
Reporting ServicesReporting Services Custom Report (2)
Reporting ServicesReporting Services Dashboard (1)
Reporting ServicesReporting Services Data Sources (10)
Reporting ServicesReporting Services Development (37)
Reporting ServicesReporting Services Drill Through (4)
Reporting ServicesReporting Services Dynamic Reports (11)
Reporting ServicesReporting Services Filtering (3)
Reporting ServicesReporting Services Formatting (26)
Reporting ServicesReporting Services Functions (5)
Reporting ServicesReporting Services Images (2)
Reporting ServicesReporting Services Installation (9)
Reporting ServicesReporting Services KPI (5)
Reporting ServicesReporting Services Maps (4)
Reporting ServicesReporting Services Migration (5)
Reporting ServicesReporting Services Monitoring (5)
Reporting ServicesReporting Services Network Load Balancing (4)
Reporting ServicesReporting Services Overview (5)
Reporting ServicesReporting Services Parameters (15)
Reporting ServicesReporting Services Performance (6)
Reporting ServicesReporting Services Report Builder (9)
Reporting ServicesReporting Services Report Models (1)
Reporting ServicesReporting Services Security (8)
Reporting ServicesReporting Services SharePoint (1)
Reporting ServicesReporting Services Subreports (4)
Reporting ServicesReporting Services Tutorials (1)
SecurityAuditing and Compliance (45)
SecurityEncryption (28)
SecuritySecurity (194)
SecuritySurface Area Configuration Manager (4)
SharePointSharePoint (130)
SharePointSharePoint Administration (46)
SharePointSharePoint Configuration (27)
SharePointSharepoint Design (46)
SharePointSharePoint Document Management (20)
ToolsAzure Data Studio (10)
ToolsSQL Operations Studio (11)
ToolsSQL Server Agent (92)
ToolsSQL Server Management Studio (74)
ToolsSQL Server Management Studio Configuration (22)
ToolsSQL Server Management Studio Shortcuts (9)
ToolsTools (31)