HADR

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 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…

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…