Post reply

Does a full database backup truncate the transaction log?

  • April 25, 2007 at 5:21 am

    #68616

    I know this is a basic question, but I've got myself confused and I'd be grateful if someone could just confirm how this works.

    Am I right in thinking that :

    A full database backup does not truncate the transaction log.

    The normal way to truncate a transaction log (assuming Full Recovery Mode) is to run a full db backup followed by a transaction log backup.

    cheers

    Ian

  • April 25, 2007 at 6:47 am

    #702351

    You're correct a full database backup will not truncate the log you do have to run a seperate transaction log backup to so this.

     

    David

  • April 25, 2007 at 7:00 am

    #702358

    I my testing of restores, I found it better to backup the transaction log PRIOR to doing the full backup. I can't explain it, but using the way you propose resulted in a couple of restore failures (fortunately in testing), but I never had issues the other way.

  • April 25, 2007 at 7:00 am

    #702357

    Thanks David

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

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