title: Should i use SQL Database Snapshots?
body: <p>I have a system that needs to snapshot specific tables at certain points in time.</p>
  
  <p>At present the process that takes the snapshot queries the data in the table, and puts the output into a Temp table (like a stage table not an in memory table).</p>
  
  <p>Many of these processes can be running at the same time in parallel (100+ per hour). And the tables to be copied can run into GBs worth of data.</p>
  
  <p>I am considering the use of database snapshots, so each process can take its own snapshot and work with it.</p>
  
  <p>What are the pros and cons of this approach?</p>
  
  <p>Is there a better way to approach this?</p>