secondary replica

SQL Server Maintenance Plan Backups Failing On Secondary Replica in High Availability Environment

ben himself's picture

When a High Availability (HA) environment failed over, on the node that became Secondary, the backup jobs did not gracefully handle the change. The Maintenance Plans are supposed to intelligently determine whether each database is Primary or Secondary in an HA environment, and skip the backup if it is not Primary.  This check actually fails (practically speaking) if you have "Verify backup integrity" checked.

Tags: 

Pages

Subscribe to RSS - secondary replica