SQL Server Data Archiving

Do you mean data from some tables when you say partial data or only some rows from a table? There are many ways to do this. Look at BCP utility for starters. This allows you to create a text/binary file with data from a table or query or result from a stored procedure.

Look at the DELETE statement in Books Online. For example, if you have a date column in the table you can do:

delete tbl

where datecol < '2005-09-07'

Note that DELETE removes the data from the table/database so you cannot retrieve it back without having a backup of the database. The command-line options for BCP utility is also present in Books Online. With that utility you can backup the data before deleting or you can use traditional database backup/recovery mechanisms.