Hi All,

I'm going to post the solution to the issue we experienced here - just in case in the future anyone else hit's the same problem.

The database which we experienced the issue on had Torn Page Detection as it's Page Verification setting. Our backups are carried out with CHECKSUM. Once TDE was enabled, backups for this database completed but then could not be restored.

The resolution was to remove TDE, amend Page Verification to CHECKSUM, and to then switch TDE back on. This resolved the problem.

For more info on this, please refer to :

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/3b9ce14c-f21d-4fdb-baf2-d3dcb2bcf8c1/backup-with-checksum-against-an-encrypted-database-restore-fails?forum=sqldisasterrecovery

https://connect.microsoft.com/SQLServer/feedback/details/622922/backup-with-checksum-produces-corrupt-backups-after-enabling-checksum-page-verification-on-an-encrypted-database

Please note this issue is NOT fixed for SQL 2008 SP3 which is the version of SQL Server we experienced this problem with.

Hope that helps someone out! 😀