Wednesday, March 21, 2012

log file issues

I am having a problem with the size of my primary filegroup. I have the
'automatically grow' option turned on. I have 7GB free disk space.But still
the log file complains that it does not have enough space to grow.Can anyone
please help me out? Thanks in advance.Can somebody pls help?
"HP" wrote:

> I am having a problem with the size of my primary filegroup. I have the
> 'automatically grow' option turned on. I have 7GB free disk space.But stil
l
> the log file complains that it does not have enough space to grow.Can anyo
ne
> please help me out? Thanks in advance.|||Do you back it up regularly ? (Assuming that you're using the FULL recovery
mode which should be the case)
Also, do you have heavy processing which could generate big T-Log ?
Chris
________________________________________
______
It's still better that if it would have been worst, isn't it ?
C'est toujours mieux que si c'etait pire !
"HP" <HP@.discussions.microsoft.com> a crit dans le message de news:
5D527A85-E4AC-4EA2-98AA-6910C81E534E@.microsoft.com...
>I am having a problem with the size of my primary filegroup. I have the
> 'automatically grow' option turned on. I have 7GB free disk space.But
> still
> the log file complains that it does not have enough space to grow.Can
> anyone
> please help me out? Thanks in advance.|||Iam getting this error when i try to change the datatype of a field in a
table which has 2 million records.
"Chris V." wrote:

> Do you back it up regularly ? (Assuming that you're using the FULL recover
y
> mode which should be the case)
> Also, do you have heavy processing which could generate big T-Log ?
> Chris
> --
> ________________________________________
______
> It's still better that if it would have been worst, isn't it ?
> C'est toujours mieux que si c'etait pire !
> "HP" <HP@.discussions.microsoft.com> a écrit dans le message de news:
> 5D527A85-E4AC-4EA2-98AA-6910C81E534E@.microsoft.com...
>
>|||You've got your winner...
To do such operation will generae a lot of writting in the transaction (to
be able to roll-back).
How look the transaction you're using for the update ?
________________________________________
______
It's still better that if it would have been worst, isn't it ?
C'est toujours mieux que si c'etait pire !
"HP" <HP@.discussions.microsoft.com> a crit dans le message de news:
2E0A42E1-8CCC-4F1F-806A-3C1EEC880FD3@.microsoft.com...
> Iam getting this error when i try to change the datatype of a field in a
> table which has 2 million records.
> "Chris V." wrote:
>|||HP
Well, sometimes autogrow is a little 'slow' and you get the error message,i
mean it could not allocate free space to grow the log.
Try change autogrow option to less percent or by 100MB.
"Chris V." <tophe_news@.hotmail.com> wrote in message
news:OAeKOgsJFHA.1040@.TK2MSFTNGP10.phx.gbl...
> You've got your winner...
> To do such operation will generae a lot of writting in the transaction (to
> be able to roll-back).
> How look the transaction you're using for the update ?
> --
> ________________________________________
______
> It's still better that if it would have been worst, isn't it ?
> C'est toujours mieux que si c'etait pire !
> "HP" <HP@.discussions.microsoft.com> a crit dans le message de news:
> 2E0A42E1-8CCC-4F1F-806A-3C1EEC880FD3@.microsoft.com...
the
>sql

No comments:

Post a Comment