srinath.vanama (8/9/2011)
IN SQL Server 2008.1) Backup encryption is possible.
2) Data compression and Resource governor.
3) Installation improvements. Disk images and service pack uninstall options.
4) TDE(transparent Data Encryption) Ability to encrypt entire database.
There is no backup encryption in SQL Server 2008 or SQL Server 2008 R2.
The only way you can get an encrypted backup is if you are using Transparent Data Encryption.