SQL AON backup is configured and it is known that the DB backup runs via primary node and log backup runs based on the preference settings. It was running as expected.
However, when the failover happens at DB side primary becomes secondary and vice versa. But the SQL Backup Master is still pointing to the same old primary node.
How can we make the SQL backup master services to be rolled back to the new primary node.
Best answer by Ron PottsView original