I have a SQL Server AlwaysOn High Availability with Primary & Secondary Database Servers
The Availability Group Backup Preferences is set to Primary.
Maintenance Plan is on Primary and does:
- Check Database Integrity - Include Indexes, Physical Only
- Backup Databases - Full
- Backup Databases - Transaction Logs
- Rebuild Indexes - Tables and views
- Maintenance Cleanup - Delete files older than 2 weeks
No errors are reported in the plan history but I find that only databases that do not participate in the Availability Group are backed up. There seems to be scant resources on maintenance plans on High Availability environments.
Any advice how I can get maintenance plan to work on the databases in the High Availability group?