Archiving old data in sql server 2008

Question

Hi,
[SQL Server 2008 Express]
[C# 4.0]

I've developed a winforms application, I want to give the user the opportunity to archive old data at the beginning

of each year.

The user can for example connect to <myApp_db_year> to consult his <year>archive.

The real scenario happens as follows: The user is working on the <myApp_db> database, till the beginning of the

next year(2011), he clicks on <Archive Last Year Data>, I want to copy then delete all 2010 transactional data

(keeping customers, suppliers, employees, balances...) data to a new database called <myApp_db_2010>, I keep track

of all archive filenames and location in an XML file.

I'd like to know the steps to follow on both sides, SQL and C# in order to achieve this task.

I welcome any suggestion, tip, samples, links, books...

Thanks.