Why does my transaction-log fill up when I use fast-bcp?

A. A. Fast BCP and select into do not log record updates. However they DO log extent allocations. They need to do this so that if the process is terminated unexpectedly (maybe the power goes out), SQL can recover the space.

Therefore with large bcp's/select into's - when a lot of extents need allocating - the log can still fill. In which case it needs to be made larger.


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish