Depends on what you mean by archive. SQL Server has no archive function. But you could copy the data from a table to a flat file using DTS, and the delete the table. To restore just DTS the data base. I suppose you might even be able to build some replication process to support archiving a table to another data source.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples