Yes, but you would need to manually back up your certificates and private key associated with the database to ensure the backup files can be restored on other instances. Also, encrypted databases don't compress well, and would probably take longer to back up compared to a regular SQL Server backup, in addition to chewing up more CPU cycles.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software Beyond compression - SQL Backup goodies under the hood, updated for version 8
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
Geri