Friday, March 23, 2012

Log File Size - Sudden Growth

I have a relatively small database that I use for development purposes (this
isn't the production database).
The .mdf is about 10 MB. The log file size - for over 1 year - has been
about 7MB in size. During the past couple of ws the log file has grown to
over 15 MB in size. The amount of db-related development activity has
remained roughly constant over the past year. So I'm curious as to what
could be causing the log file to suddenly grow this large (small as it is in
the relative scheme of things).
Thanks!Felipe,
A couple of guesses: 1. Importing data 2. index creation or maintanence 3.
log backup didn't occur
HTH
Jerry
"Felipe" <aye@.bee.calm> wrote in message
news:OAgDoxGxFHA.3892@.TK2MSFTNGP12.phx.gbl...
>I have a relatively small database that I use for development purposes
>(this isn't the production database).
> The .mdf is about 10 MB. The log file size - for over 1 year - has been
> about 7MB in size. During the past couple of ws the log file has grown
> to over 15 MB in size. The amount of db-related development activity has
> remained roughly constant over the past year. So I'm curious as to what
> could be causing the log file to suddenly grow this large (small as it is
> in the relative scheme of things).
> Thanks!
>sql

No comments:

Post a Comment