What is Enhanced Database Failover and How to Enable it for Availability Group?
As we know Always on Availability Group is the set of user databases that are combined to failover if primary…
7 years ago
AOAG
Upgrade or Patch SQL Server Failover Cluster Instance Running with Availability Group
I have explained step by step process to upgrade or patch SQL Server instance that hosts an Always on Availability…
7 years ago
How to Change Failover Mode of Availability Replica in Always On Availability Group?
Today, i will describe about the overview of failover modes in AOAG and how to Change failover mode of an…
7 years ago
How to Upgrade or Patch Alwayson Availability Group Instances?
If you are planning to upgrade your SQL Server instance that hosts an Always on Availability Group (AOAG) to a…
7 years ago
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.…
8 years ago
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…
8 years ago
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…
8 years ago
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…
8 years ago
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…
8 years ago
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…
8 years ago
Why is Secondary Replica Showing in Resolving state after AOAG Automatic failover?
Sometimes AOAG configuration stuck in resolving state and its secondary Replica does not come online. When you check the Alwayson…
8 years ago