Is bcp command logged ?

  • Is bcp command logged or not ? In case if there are two options, how can we switch between them ?


  • Logged as in written to the transaction log?

    If so, yes. All operations are logged and there's no way to turn logging off.

    If your database is in Bulk-logged recovery, the bcp may be bulk-logged. Look up bulk operations and bulk-logged recovery in SQL's Books online for more info.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks, Gail.

  • To my disappointment, the bcp utility is logged, appears to be fully. The -h switch with "tablock" seems to greatly improve performance; full logging appears to be minimal.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply