Restore encrypted SQL database on another server
Hi folks!
Recently we applied TDE (Transparent Data Encryption) on some of our SQL databases on an SQL server. Netbackup policies keep working troublefree both for Full and Incremental Backups.
Now, we need to perform a restore of one of these databases onto another SQL server where the TDE has been applied as well.
I try to make the restore but I got the error with status 2828. Can someone guide me on how to do the restore?
Thank you all in advance for the support.
I believe this is a question for Microsoft.
Have a look at this doc (Move TDE protected database without NBU):
Then there is this blog regarding SQL backup and restore:
Restore after disabling TDE:
