AlwaysOn

How to Add a New Database to Always On Availability Group?

Adding or Removing databases from availability group is not day to day task but we need to perform such activities…

How to Remove Database from Always On Availability Group?

This article describes how to remove availability database(s) from an Always on Availability Group by using SQL Server Management Studio…

SQL Server Alwayson Error 35250: Joining database on Secondary Replica resulted in an error

We got this Microsoft SQL Server error 35250 while configuring Alwayson Availability Group on one of the SQL Server Instance.…

Fix AOAG Listener Error 19471: Kerberos Status is Showing The handle is Invalid

I was configuring AlwaysOn Availability Group between two replicas. Everything was configured successfully but Listener was failed to create with…

Understanding Backup Preferences for AlwaysOn Availability Group Databases

We know SQL Server Backups are resource intensive operation that strain on I/O and CPU (with backup compression). AlwaysOn Availability…

Fix SQL Server Error 976: Cannot connect to Secondary Replica of AlwaysON Availability Group

Today an application user has reported that he is not able to connect to the secondary replica of AlwaysOn Availability…

Fix SQL Server Error 19471: Listener issue that came during Configuring SQL Server AlwaysOn Availability Group

I had an AOAG configuration between two replicas that i have deleted in order to perform some activities. I was…

Fixing SAP Connectivity issue after AOAG Automatic failover

We have Alwayson Availability Group configuration for our SAP systems. We faced SAP connectivity issue when application team tried to…

Fix SQL Server Error 15141: The server principal owns one or more endpoint(s) and cannot be dropped

I got Microsoft SQL Server error 15141 while removing a SQL Server domain login on one of instance where AlwaysOn…

What is AlwaysOn Availability Group

SQL Server Always On is just a term given by Microsoft for Availability Group & Failover Cluster Instances that are…