What are the challenges you face when working across database platforms? Take the survey
Options
Can the reports automatically report from Primary in an HA Group?
BrainDonor
Friend of Redgate › Posts: 55 Silver 2
When a High Availability Group is failed over, is it possible for reports to automatically point to the new Primary? Currently I have to edit the reports so that they now point to the new Primary server.
Tagged:
Best Answer
-
Options
Russell D
Posts: 1,324 Diamond 5
No this option isn't available unfortunately. You could just include all primary/failover servers on the same report which would lead to a lot of servers on the reports that aren't in use but at least avoid the manual process that you're having to do.
Other than that I'd recommend posting this on the SQL Monitor Uservoice here: https://sqlmonitor.uservoice.com/forums/91743-suggestions, as we use this to help prioritise future work.Have you visited our Help Centre?
