Log File Error

Good Morning
We have a nightly DTS job, which uploads data, to a number of tables (35
tables). However the DTS job failed last night, due to the following error
returned :
****
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description:The log file for database 'G_Data' is full. Back up the
transaction log for the database to free up some log space.
****
However, on the properties of the Database (G_Data) , the option for Auto
File Growth was selected and Increase by 20 percent. So I am somewhat
puzzled that there error occured?
This isn't a recurring error, since the last time this error had happened
was about 6 months ago - Is it in connnection with the frequency of jobs
that I am runnning or is there something wrong with the settings I have
selected?
Kind Regards
Ricky
(Win2K Server/SQL2K-SP4)maybe an_available_free_space_of_the_volume_wh
ich_the_tlog_is_resided_on <
a_current_size_of_the_tlog * 1.2
--
Andrey Odegov
avodeGOV@.yandex.ru
(remove GOV to respond)
"Ricky" <MSN.MSN.com> wrote in message
news:ebu38YSDGHA.2436@.TK2MSFTNGP15.phx.gbl...
> Good Morning
> We have a nightly DTS job, which uploads data, to a number of tables (35
> tables). However the DTS job failed last night, due to the following
> error
> returned :
> ****
> Error Source: Microsoft OLE DB Provider for SQL Server
> Error Description:The log file for database 'G_Data' is full. Back up the
> transaction log for the database to free up some log space.
> ****
> However, on the properties of the Database (G_Data) , the option for Auto
> File Growth was selected and Increase by 20 percent. So I am somewhat
> puzzled that there error occured?
> This isn't a recurring error, since the last time this error had happened
> was about 6 months ago - Is it in connnection with the frequency of jobs
> that I am runnning or is there something wrong with the settings I have
> selected?
> Kind Regards
> Ricky
> (Win2K Server/SQL2K-SP4)
>|||A file will only grow until there's enough free space on the disk. More
critically - why don't you backup your transaction log?
ML
http://milambda.blogspot.com/|||After backing up, do I delete it?
"ML" <ML@.discussions.microsoft.com> wrote in message
news:19632D48-8D08-4F4D-97EE-B0F0C2F2A4E8@.microsoft.com...
> A file will only grow until there's enough free space on the disk. More
> critically - why don't you backup your transaction log?
>
> ML
> --
> http://milambda.blogspot.com/|||... or an account which the sql server runs in is restricted with quota
settings of the volume
--
Andrey Odegov
avodeGOV@.yandex.ru
(remove GOV to respond)
"Andrey Odegov" <avodeGOV@.mail.ru> wrote in message
news:eiUSgySDGHA.2300@.TK2MSFTNGP15.phx.gbl...
> maybe an_available_free_space_of_the_volume_wh
ich_the_tlog_is_resided_on <
> a_current_size_of_the_tlog * 1.2
> --
> Andrey Odegov
> avodeGOV@.yandex.ru
> (remove GOV to respond)
> "Ricky" <MSN.MSN.com> wrote in message
> news:ebu38YSDGHA.2436@.TK2MSFTNGP15.phx.gbl...
>|||NO! After you back it up, there should be free space available because the
backed-up transactions can be overwritten.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Ricky" <MSN.MSN.com> wrote in message
news:u1lVCCTDGHA.2040@.TK2MSFTNGP14.phx.gbl...
> After backing up, do I delete it?
> "ML" <ML@.discussions.microsoft.com> wrote in message
> news:19632D48-8D08-4F4D-97EE-B0F0C2F2A4E8@.microsoft.com...
>