Always On Availability Group and Maintenance Plan

• Barcelona10

  SSCertifiable

  Points: 5372

  More actions

  January 27, 2017 at 3:29 pm

  #317975

  Hi ,
  I am working on implementation of Always On Availability Group in our new 2014 SQL Server Enterprise  edition.Currently we have SQL Server 2008 R2 Std Edition and we have Maintenance Plan that does full(twice a day) and trn(every 2 min ) backups ,checks db integrity and more.These backups(trn) keep   transaction log file size under control.My question is how should i do the same with  2014 Always On Availability Group  where there are 2 log files:1 for Primary and 1 for secondary?.

  Thx

• Barcelona10

  SSCertifiable

  Points: 5372

  More actions

  January 27, 2017 at 5:08 pm

  #1925457

  Found nice article 

  https://blogs.msdn.microsoft.com/alwaysonpro/2013/09/27/performing-transaction-log-backups-using-alwayson-availability-group-read-only-secondary-replicas-part-1/

  Got it.

  Thank You

• Barcelona10

  SSCertifiable

  Points: 5372

  More actions

  January 27, 2017 at 5:09 pm

  #1925458

  And this
  http://info.tricoresolutions.com/blog/understanding-backups-with-sql-server-alwayson-high-availability-mirrors