hello all,
can someone please explain to me how sql 2000 transaction log works? our recovery model is set to full so i know why my log size is big. however what i'm trying to figure out really is how it behaves. i've been monitoring the actual physical size of the file for the last 3 weeks and i just couldn't figure out any pattern. we do nightly full backup and truncation and basically i would note the size of the file before the backup happens and after. the thing that i find most hard to understand is sometimes on a regular work day the log size will stay the same all thru out the day as if nothing is going on and then sometimes on a different day it just grows to a few gig more. then on a weekend when you would think nothing much is going on the size would grow too to a few gig. after the scheduled backup and truncation sometimes the file will shrink afterwards and then sometimes the file just stays the same. can someone explain why it's like this? is this normal? i'm not having any problem on my server and no error messages on my event log. i'm just curious about this transaction log so any help is very much appreciated.
thanks,
edwin
can someone please explain to me how sql 2000 transaction log works? our recovery model is set to full so i know why my log size is big. however what i'm trying to figure out really is how it behaves. i've been monitoring the actual physical size of the file for the last 3 weeks and i just couldn't figure out any pattern. we do nightly full backup and truncation and basically i would note the size of the file before the backup happens and after. the thing that i find most hard to understand is sometimes on a regular work day the log size will stay the same all thru out the day as if nothing is going on and then sometimes on a different day it just grows to a few gig more. then on a weekend when you would think nothing much is going on the size would grow too to a few gig. after the scheduled backup and truncation sometimes the file will shrink afterwards and then sometimes the file just stays the same. can someone explain why it's like this? is this normal? i'm not having any problem on my server and no error messages on my event log. i'm just curious about this transaction log so any help is very much appreciated.
thanks,
edwin