SQL Server Maintenance Plan Backups Failing On Secondary Replica in High Availability Environment Writer #1, 2016-12-02 When a High Availability (HA) environment failed over, on the node that became Secondary, the… Continue Reading
T-SQL – Get Listener Name on AlwaysOn Cluster Writer #1, 2016-05-252024-08-31 When using AlwaysOn, you must connect using your listener name, not your node name. If you connect with the node name, it will only work until there is a failover, which would defeat the purpose of your High Availability setup, right? Continue Reading