Post reply

Database Backups with AlwaysOn

  • December 7, 2012 at 8:53 am

    #393766

    I'm curious how people are handling their backups when using Availability Groups. I know one of the idea's is to offload the backups to the secondary replica. The problem I see with that is you never are able to do a full backup that truncates the transaction log?

    What am I missing?

  • December 7, 2012 at 9:02 am

    #1566652

    A full backup shouldn't truncate the tr log.


    Cursors never.
    DTS - only when needed and never to control.

  • December 7, 2012 at 9:17 am

    #1566661

    I shouldn't have said truncates the log file. Rather I want to backup the log file so it empties the contents of the .LDF, preventing it from growing out of control.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply