Yes & No -

You are, in all likelihood, keeping transactions in the log that were applied long before the last backup started, and hence not very useful.

You probably should dump your transaction log right before each backup.

You should make sure you have your database set to the desired recovery level (which is probably not "full")

...and you should dump or overwrite your transaction log as often as appropriate.

Then, you can shrink the log file to a size representative of how large it might get between two backups, plus a safety margin (factor of 3 or 4...)

Best,

Juan Cristián

-----Original Message-----
From: James Ramos [mailto:mssqldba-ezmlmshield-
Subject: TLOGBackup.BAK file is larger than the Fullback up


I have noticed that my TLOGBackup.BAK file is larger than the Fullback
up

MS Sql Server LazyDBA home page