DTS/BCP transaction log full error

• David Bonanni

  SSC-Addicted

  Points: 416

  More actions

  March 22, 2007 at 7:54 am

  #153491

  Hi,

  We are running SQL server 2005, SP2 and whenever we try very simple BCP or DTS commands (copying less than 100,000 rows) we are getting transaction log full errors.  We are running the BCP command through on OLE DB connection written in our application.

  When we run the BCP command directly from Query Analyzer, it runs w/o getting the transaction log full error. 

  Our transaction log is set to autogrow.

  Any ideas?

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  March 22, 2007 at 8:10 am

  #696372

  What is the recovery model that is been set in that particular database?

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  March 22, 2007 at 9:06 am

  #696398

  David

  What are the exact commands you are using in your application and in Query Analyzer?

  John