Space Requirements for Copying

If you are copying a very large number of rows, you must have 1.2 times the amount of space needed for the data and enough space for the server to reconstruct a clustered index.

If space is
  • Available – use drop index to drop all the indexes beforehand.

  • Not available – if you do not have enough space for the server to sort the data and build the index or indexes, use slow bcp.