Post reply

Does BACKUP use the transaction log?

  • May 10, 2013 at 6:14 am

    #394751

    Hi,

    I noticed several autogrowth events for the transaction log file of a database shortly after its backup job started. I've browsed around MSDN but can't find any mention of whether the transaction log is used for the backup operation.

    Not a high-priority issue, just interested to know about it.

    Thanks,

    Jeff

  • May 10, 2013 at 6:50 am

    #1614159

    The backup doesn't write to the transaction log, but while there's a backup in progress space in the log can't be reused. If you're seeing autogrow events, it suggests that maybe you need to grow the log a bit larger than what it is, leave space for cases like this.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 10, 2013 at 6:53 am

    #1614160

    Thanks for replying and the info. I'll increase the log file as you've suggested.

    ~ Jeff

  • May 15, 2013 at 12:13 am

    #1615285

    jhager, if you're interested, here is an article that explains why the transaction log is involved in full backups and how much of it is required:

    http://www.sqlskills.com/blogs/paul/debunking-a-couple-of-myths-around-full-database-backups/[/url]

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • May 15, 2013 at 6:14 am

    #1615371

    Thanks, I'm always interested to learn more about the product and its inner workings.

    ~ Jeff

Viewing 5 posts - 1 through 4 (of 4 total)

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