Archival strategy for a table with 25 million records in SQL Server 2008 R2 Enterprise
Please see this answer: SQL Server database design for &quot;archived but available&quot; data

As Remus comments, you are probably barking up the wrong tree here. 25M rows is a very small table and the INSERT really shouldn't take long. Perhaps it is worth investigating this first..