Post reply

Is bcp command logged ?

  • January 15, 2010 at 9:25 am

    #138117

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

    Thanks.

  • January 15, 2010 at 9:39 am

    #1104302

    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

  • January 15, 2010 at 10:36 am

    #1104345

    Thanks, Gail.

  • June 11, 2023 at 10:43 pm

    #4209160

    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