Data is usually categorized into levels of importance and frequency of use based on age, and older data is usually less important than recent data. While today’s data, or this week’s data, is access more frequently than older data, you usually have to keep that older data for compliance or business-specific reasons. Storing historical data that isn’t accessed very often can be more expensive if you treat that data the same way as the more recent data, because you usually store frequently accessed data on the fastest drives that you can afford. The cloud can be a good solution for storing and managing historical data, because you can selected less expensive tiers of storage because while you need the data to be available, it doesn’t have to be on fast drives.
SQL Server Stretch Database utilizes the resources in Microsoft Azure to allow you to push archival data to the cloud. Once enabled at the table level, Stretch Database will automatically migrate your historical data to Azure. Stretch Database will also use the power of Azure to run queries against that older remote data.
You can learn more about Stretch Database from Microsoft.