Hi all

I'm working with SQL2000, i'm trying to write a table (2'000.000 registers estimated )using a DTS but every time that I try to run it i receive this error msg

Error Source: Microsoft OLE DB Provider for SQL
Error Description: The Log File for Database 'My_DataBase' is Full, Back up the transaction log for the database to free

Also i have more than 40GB free space on my disk... and the first actions in the DTS are to truncate the log file and the table that i'm writing..

Some Body can Help me to know why is this happend?

Check the size you have allocated for the log in My_Database. If it's
set to a max size, you could be running out of space for the log - not
disk space but rather the log is exceeding the size you have allocated
for it. Another possibility is that it's at a fixed size and not
allowed to grow and that you are exceeding the fixed size. And another
option is that it's not growing fast enough - sometimes autogrow
doesn't keep up with other processes.
In any case, check the sizing on the log. If it's not autogrow with
unlimited growth you can set it to that temporarily to see what size
it grows to. Then you can determine a appropriate size for the log
file from there.

-Sue

On Wed, 2 Jun 2004 13:31:10 -0700, "Luis" <jrojas (AT) igerencia (DOT) com>
wrote: