title: SQL Server Data Archive Solution
body: <p>I'm looking for a solution to archive data that exists in my database. My database is SQL Server 2008 and have approximately 250 tables. I search web and find the below link :
  <a href="http://www.dbazine.com/sql/sql-articles/charran13/" rel="noreferrer">http://www.dbazine.com/sql/sql-articles/charran13/</a></p>
  
  <p>but this solution is not clear</p>
  
  <p>I don't know that is there a direct way for doing this in sql server. please give me a solution.</p>