High Availability - Backup Secondaries

• krypto69

  SSChampion

  Points: 13604

  More actions

  May 17, 2019 at 6:33 pm

  #3644739

  Hi

  I have Enterprise 2014 with HA and also one local secondary and one remote secondary.

  I would like to backup the two secondaries locally so that if any of the three go down I would be able to restore from a full bak (& diffs & trn logs)

  But looking into it - it looks like I can setup the H/A backup preferences to 'any replica'. Will using this setting allow me to backup all three servers locally (they all have different SANs) and also do diffs/trn recovers?

   

  Also I want to do differentials on my primary. Which backup preference should I use. It's currently set at 'Prefer Secondary' and it is letting me do diffs on my primary. I didn't think it would work...but I haven't tested a restore yet.

  Any advise greatly appreciated.

  Thanks.

  • This topic was modified 5 years, 5 months ago by  krypto69.