Data compression in SQL Server:
Please note that this is Enterprise Only feature from SQL Server 2008 through SQL Server 2016. In SQL Server 2016 SP1, data compression is available in all editions. It is not available in versions prior to 2008.
If you are archiving data for only occasional access, clustered columnstore indexes are a good feature if you are using SQL Server 2014 Enterprise or higher. It offers the best compression ratio but is not suitable for high transactional processing speed.
You should avoid using compressed NTFS folders or drives as the performance will likely be worse.