How can we help you today? How can we help you today?

Transaction Log not truncating?

Hi,

I must be doing something wrong but doing a Transaction Log backup with "Remove inactive entries from transaction log" checked does not truncate my log file. With v5 we had been doing the log backups using SQL itself because of this but after upgrading to v6 i was hoping to get away from this. Can you please advise and let me know what to try. Thanks.

Brock
sunbaked
0

Comments

1 comment

Sort by
  • petey
    Truncating the transaction log is a logical operation, and will not affect the physical transaction log file size, unless the database has the autoshrink property set.

    Shrinking the transaction log is a physical operation, and will reduce th size of the transaction log file where it's possible to do so. See here for details.

    Setting the 'Remove inactive entries from transaction log' option causes SQL Server to truncate the transaction log after the backup, which is the 'normal' process for a transaction log backup.
    petey
    0

Add comment

Please sign in to leave a comment.