Tagged: HADR

Get preferred backup replica 0

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 Group has very good capability to offload SQL Server backups and read operations from primary replica to reduce such workloads...

error 19471 3

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 configuring Always On Availability Group again on this database server. We followed all processes but Listener was failed to create...