September 6, 2005 at 8:06 am
I have recently begun using a database maintenance plan one of our databases. I have noticed a strange (yet maybe normal) behavior in the transaction log backups. The .trn file will range in size for the week form 30-90MB. This changes dramatically after the backup runs. The .trn file after the database backup is always about the same size as the .bak file.
Is this normal ? And if so, why ?
Thanks.
N Hatt
September 6, 2005 at 8:36 am
It sounds like your maintenance plan is doing more than just a full backup. Is it reorganising indexes as well? If so, that can create very large transaction logs and therefore large transaction log backups.
September 6, 2005 at 8:38 am
yes it is re-organizing indexes. That makes sense now. Thanks - I appreciate the help.
N Hatt
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply