title: Cutting a database down to size
body: <p>Say you have a database that has served a company for 10 years. It is 500GB in size, it has myriad tables, stored procedures and triggers.</p>
  
  <p>Now say you wish to create a cut down version of the database to use as a test bed for use in integration testing and for individual testers and developers to spin up instances of to play around with. </p>
  
  <p>In broad terms how would you set about this task?</p>
  
  <p>In case it matters, the database I have in mind is SQL Server 2008.</p>
  
  <p>Edit: removed "unit testing" because of course unit tests should not test db integration</p>