Therefore, the maintenance plan WILL detect the availability group's AUTOMATED_BACKUP_PREFERENCE setting when deciding to backup a database or log if that database is defined in the group. When you define a new maintenance plan, the '.Ignore Replica Priority for Backup' setting is off by default. Note the new setting 'For availability databases, ignore Replica Priority for Backup and Backup on Primary Settings.' The SQL Server maintenance plan feature is AlwaysOn availability group aware. In SQL Server Management Studio's Object Explorer, right click your maintenance plan in and click 'Modify' - in the pane that appears to the right, right-click the Database Backup task and choose Edit. If not specifically configured, the default, through T-SQL or using the New Availability Group wizard, is 'SECONDARY.' When you create an availability group, the availability group's AUTOMATED_BACKUP_PREFERENCE is set. Maintenance Plan Checks Availability Group AUTOMATED_BACKUP_PREFERENCE If you were to right-click the maintenance plan job in SQL Server Management Studio's Object Explorer, and view the job history, it would read something like this (Note, the 'Message' does not include the BACKUP command, because it was not executed):
The maintenance plan will still complete successfully, but the database or log backup will not execute and no backup file will be created. If a database is backed up using a maintenance plan, and is then defined in the primary replica of an availability group, the maintenance plan may cease to backup the database or log of that database. SQL Server maintenance plans are AlwaysOn availability group aware and special considerations must be made when defining a maintenance plan that backs up availability databases. Maintenance plans can be created in SQL Server Management Studio to schedule periodic database and log backups of critical data.
0 kommentar(er)
