When node1 active, and created maintenance plan at node1 backup works but if cluster failed over to node2 schedule backup will fail. How can I set schedule auto backup active node? Do user needs to create maintenance plan for all node?
See the Installation or Upgrade guide for the topic "Back Up SQL Server 2012 AlwaysOn Availability Groups".
Create the maintenance plan on all nodes and set the AlwaysOn Availability Group option as needed. But Microsoft doesn't use the terms active and passive for AlwaysOn as the functionality works differently. Each replica in the group is active at all times. The groups themselves are considered primary and secondary, where secondaries that are used for backup or querying are called active secondaries. In any case, set the option as needed to let LiteSpeed know where the backups are running. A LiteSpeed license is required for each instance.
Alwayson groups are not clustered SQL instances…they run on a cluster, but each SQL instance in the group is a standalone SQL instance running on separate nodes within the cluster (but again they themselves are not clustered Instances).
Setup or installed Litespeed as user would in any other standalone SQL instance. Here’s additional readings from Microsoft:
