Microsoft introduced transparent data encryption (TDE) when it released SQL Server 2008, adding full database encryption rather than the limited cell-based encryption that debuted in SQL Server 2005.
I was looking a Red-Gate's SQL Backup program and was rather interested in the encryption options that the PRO version offered. It claims up to 256 bit encryption, but I was wondering how "secure" ...