y213h (7/10/2013)
why not use partition table to slide out the data?
This is how to do it is you do not have enterprise version of sql server. There are many ways to do the job. This article is concentated mostly how to establish automated archiving after the data is moved out of customer database.