1/ In SQL server 2008, there is a new whole database encryption option (TDE). I suspect that using this option will make the backups incompatible with SQL 2005.

Dubbed SQL Server 2016, the forthcoming iteration brings a focus on analytics, cloud capabilities, data encryption and security, as well as the usual raft of features database vendors typically market ...