locked
Backup strategy on Availability groups RRS feed

  • Question

  • Hi :

    I have a SQL 2014 Enveronment with Always On availibility group setup. I want tosetup a backup strategy.

    I know that the preferred backup database would be the secondart replica.

    My backup strategy is something like this.

    daily 12am : full backup

    daily Transaction Log backups : every 10 min.

    My question is.. If I setup up this backup stategy on the secondary database, how would the Transaction logs on the primary database truncate as I am not backing up the primary replica.

    What should be the ideal backup strategy for databases in an availability group.

    Thank you ..

    Sunday, October 19, 2014 9:24 AM

Answers

  • https://www.simple-talk.com/sql/database-administration/sql-server-2012-alwayson/

    T-SQL Articles
    T-SQL e-book by TechNet Wiki Community
    T-SQL blog

    Sunday, October 19, 2014 9:40 AM
  • My question is.. If I setup up this backup stategy on the secondary database, how would the Transaction logs on the primary database truncate as I am not backing up the primary replica.

    With AlwaysON AG databases, transaction log backup can be performed on any of the replicas and SQL Server will maintain a consistent log chain across log backups taken on any of the replicas. So, performing log backup on secondary will allow the truncation on primary database as if the log backup was performed on primary database.

    http://msdn.microsoft.com/en-us/library/hh245119.aspx

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


    Keerthi Deep | Blog SQLServerF1 | Facebook

    Monday, October 20, 2014 4:37 AM

All replies