title: SQL server cleaning up databases, transaction logs?
body: <p>I have a SQL Server 2005 database from which I'm removing several large tables to an archive database. The original database should shrink considerably.</p>
  
  <p>To make the archive database, I was going to restore a copy of the original and just remove the current tables from that.</p>
  
  <p>Is this the best way to go about it? What should I do with logs/shrinking to make sure the final sizes are as small as possible? The archive database may grow a little, but the original continues its normal growth.</p>