Copying tables with DTS

• Tom-386516

  Mr or Mrs. 500

  Points: 506

  More actions

  January 29, 2007 at 7:45 am

  #153404

  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?

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  January 29, 2007 at 10:06 am

  #686200

  Please don't cross-post.  Your post in the DTS forum, http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=340467,  is in the correct location.

  Greg

• Bose C S

  SSC Rookie

  Points: 45

  More actions

  January 29, 2007 at 9:28 pm

  #686359

  u hav to clear ur log file

  by using

  BACKUP LOG DbName WITH TRUNCATE_ONLY

  DBCC SHRINKDATABASE (DbName,0)