Cancelling a Bulk Operation impact

• VastSQL

  SSC-Dedicated

  Points: 36186

  More actions

  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

• VastSQL

  SSC-Dedicated

  Points: 36186

  More actions

  September 6, 2013 at 3:54 am

  #1647989

  Can anyone please help?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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

• VastSQL

  SSC-Dedicated

  Points: 36186

  More actions

  September 7, 2013 at 1:31 am

  #1648292

  Thanks a lot Gail.

• Sean Pearce

  SSCoach

  Points: 15999

  More actions

  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]