Efficient way to move 170 GB table from production to another server
I would use: 

1) backup (copy-only) &amp; restore the database on the same server to make this db available locally -> copy records into the other database. No option if the database itself is too large.

2) use bcp out/in. Use QueryOut if  you want to specify the records to be exported yourself (partition on PK value)