|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Log File ErrorWe 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_which_the_tlog_is_resided_on <
a_current_size_of_the_tlog * 1.2 --- Andrey Odegov avode***@yandex.ru (remove GOV to respond) Show quote "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) > > .... or an account which the sql server runs in is restricted with quota
settings of the volume --- Andrey Odegov avode***@yandex.ru (remove GOV to respond) Show quote "Andrey Odegov" <avode***@mail.ru> wrote in message news:eiUSgySDGHA.2300@TK2MSFTNGP15.phx.gbl... > maybe an_available_free_space_of_the_volume_which_the_tlog_is_resided_on < > a_current_size_of_the_tlog * 1.2 > --- > Andrey Odegov > avode***@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?
Show quote "ML" <M*@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/ NO! After you back it up, there should be free space available because the
backed-up transactions can be overwritten. -- Show quoteThis 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" <M*@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/ > >  |
|||||||||||||||||||||||
Other interesting topics