Log file for database "xxx" is full

I seen the error message "Log file for database xxx is full. backup the
transaction log for the database to free up some log space.",
but I already checked the automatically grow file and unrestricted file
growth, and the server has still near 2GB free space, why the error still
pop-up? I have set the By percent property of the File growth to 15, but in
fact what is the number means?
By percent property means that the file will grow by 15% each time it needs.
As to why it doesnt grow, did you check the windows side of things? Policies
and such limitations to file size.
MC
"kei" <kei@.discussions.microsoft.com> wrote in message
news:E36B16A3-2EB2-4D64-B7B2-E56F79CA9C2D@.microsoft.com...
>I seen the error message "Log file for database xxx is full. backup the
> transaction log for the database to free up some log space.",
> but I already checked the automatically grow file and unrestricted file
> growth, and the server has still near 2GB free space, why the error still
> pop-up? I have set the By percent property of the File growth to 15, but
> in
> fact what is the number means?
|||grow by 15%, but I don't know the x in x = x + 15%! what is the x come from?
I see the space allocated column is 110, is this means the file will grow by
110 * 15% each time?
"MC" wrote:

> By percent property means that the file will grow by 15% each time it needs.
> As to why it doesnt grow, did you check the windows side of things? Policies
> and such limitations to file size.
>
> MC
>
> "kei" <kei@.discussions.microsoft.com> wrote in message
> news:E36B16A3-2EB2-4D64-B7B2-E56F79CA9C2D@.microsoft.com...
>
>
|||No.
It will grow by x * 0.15 each time. So if you have 100, next value is 115,
after that is 115 + (115* 0.15)
MC
"kei" <kei@.discussions.microsoft.com> wrote in message
news:E0606C35-1C61-4509-98E7-6423BA79C173@.microsoft.com...[vbcol=seagreen]
> grow by 15%, but I don't know the x in x = x + 15%! what is the x come
> from?
> I see the space allocated column is 110, is this means the file will grow
> by
> 110 * 15% each time?
> "MC" wrote:
|||Oh, it was my question here, where is the value 100 come from? the value from
column "space allocated"?
"MC" wrote:

> No.
> It will grow by x * 0.15 each time. So if you have 100, next value is 115,
> after that is 115 + (115* 0.15)
> MC
> "kei" <kei@.discussions.microsoft.com> wrote in message
> news:E0606C35-1C61-4509-98E7-6423BA79C173@.microsoft.com...
>
>
|||Yes.
MC
"kei" <kei@.discussions.microsoft.com> wrote in message
news:AB9DCC9A-B2F1-40DF-8E4F-CC54F0736456@.microsoft.com...[vbcol=seagreen]
> Oh, it was my question here, where is the value 100 come from? the value
> from
> column "space allocated"?
> "MC" wrote:
|||kei wrote:[vbcol=seagreen]
> grow by 15%, but I don't know the x in x = x + 15%! what is the x come from?
> I see the space allocated column is 110, is this means the file will grow by
> 110 * 15% each time?
> "MC" wrote:
The problem can actually also occur if you server doesn't grow the log
file fast enough. If it happens quite often, I'd consider increasing the
log size manually and then expanding it with e.g. 50% or 100 %. By doing
this it will take a while before it has to grow again. You could also
try to set the "auto grow" option to grow e.g. 100 MB at the time rather
than a percentage.
You don't mention anything about your backup strategy, but it could be
that you need to backup you log file in order to re-use the space
already claimed by the log file.
Regards
Steen