There's no offline storage capabilities native to SQL Server. EMC has a product called database extender which can help with this archiving to offline storage. With storage being as cheep as it is these days, most people will setup some sort of partitioning (either using the native table partitioning if they have SQL 2005+ Enterprise Edition, or some sort of manual archiving process) to handle this with the current data on fast expensive storage, and the older data on slower much less expensive storage.

There's no offline storage capabilities native to SQL Server. EMC has a product called database extender which can help with this archiving to offline storage. With storage being as cheep as it is these days, most people will setup some sort of partitioning (either using the native table partitioning if they have SQL 2005+ Enterprise Edition, or some sort of manual archiving process) to handle this with the current data on fast expensive storage, and the older data on slower much less expensive storage.