SQL Server 2008 introduced a great new feature called TDE, Transparent Data Encryption. It allowed a database to be completely encrypted without having to change the applications that access it ...

There had been one exception: Transparent Data Encryption, which encrypts SQL Server data files and backups at rest so that a database or transaction log file cannot be copied to another server ...