title: Backup specific tables from production into a .bak file (not BCP) in SQL Server
body: <p>I need to backup a couple of tables from my prod database.</p>
  
  <p>Each table has 250 million rows.</p>
  
  <p>The complete backup is almost 1TB</p>
  
  <p>I don't want the full backup due to space (Needs double space for backup &amp; restore)</p>
  
  <p>I can't use <code>BCP</code> due to volume and heavy inserts involved.</p>