2016-12-02
SQL Server Maintenance Plan Backups Failing On Secondary Replica in High Availability Environment
When a High Availability (HA) environment failed over, on the node that became Secondary, the backup...
When a High Availability (HA) environment failed over, on the node that became Secondary, the backup...
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?