January 29, 2007 at 7:44 am
While copying 2 tables from one database to another on the same server I receive the following error.
ErrorMessage: Error at Destination for Row number 14131. Errors encountered so far in this task: 1. Log file is full. Backup transaction logs to freeup space.
My log file is currently set to automatically grow and I have plenty of disk space. What else could be the problem?
January 29, 2007 at 9:57 am
I've found this type of DTS error message to be pretty accurate, so my only advice is to check your destination connection and make sure you're transferring to the database you think you are.
Greg
Greg
January 29, 2007 at 10:47 am
Also, make sure that there is no maximum file size for the log file.
Russel Loski, MCSE Business Intelligence, Data Platform
January 29, 2007 at 6:46 pm
If you don't have the log space ....you can change Insert batch size in the dts package properties... but it will take longer than normal to complete the process.
Values for Batch size work as follows:
If you set batch size to 0, the data is loaded in one batch, and the first row that fails will cause the entire load to be canceled and the step fails. This value is the default setting.
If you set batch size to 1, the data is loaded a single row at a time. Each row that fails is counted as a batch failure, and the value of Max error count is incremented by one. Previously loaded rows are either committed, or, if the step has joined the package transaction, retained in the transaction, subject to later commit or rollback.
If you set batch size to a value greater than 1, the data is loaded one batch at a time. The first row that fails in a batch fails that entire batch; loading stops and the step fails. Rows in previously loaded batches are either committed, or, if the step has joined the package transaction, retained in the transaction, subject to later commit or rollback.
MohammedU
Microsoft SQL Server MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply