Post reply

Cancelling a Bulk Operation impact

  • September 5, 2013 at 6:45 am

    #395423

    Hi Experts,

    What happens if i cancel a bulk insert operation for 1 Billions rows into a table in between?

    is the effect same for queries using command BCP , BULK INSERT and INSERT INTO?

    TIA

  • September 6, 2013 at 3:54 am

    #1647989

    Can anyone please help?

  • September 6, 2013 at 1:07 pm

    #1648210

    It rolls back, same as any other data modification when stopped part way through.

    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

  • September 7, 2013 at 1:31 am

    #1648292

    Thanks a lot Gail.

  • September 9, 2013 at 7:01 am

    #1648520

    The BCP utility has a batch parameter that allows you to specify the number of records to group in a transaction. If something happens during the BCP process, only the last batch will be rolled back. If this parameter is not used the entire set will be one batch.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

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

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