title: Archiving Large Table (SQL Server 2008)
body: <p>I have a very large table being filled with about 100s of million records each quarter.</p>
  
  <p>I manually move data from the existing table to another database using <a href="http://sqlserverperformance.wordpress.com/2011/08/13/gradually-deleting-data-in-sql-server/" rel="noreferrer">this script</a>, to minimize the backup size, and to off load the production database when performing queries.</p>
  
  <p>Is there any better way, for example, some scheduled script that will move data from the production database to some other database and then delete the records from the source database every day or week efficiently? </p>
  
  <p>Note that my log file is growing rapidly due to the high number of INSERTs into this table, also when I move data to the archive database, DELETEs will be logged.</p>
  
  <p>Thanks</p>