In the previous chapters, we’ve looked at how TDE works and how simple it is to set up. In this chapter, we’re going to look at various scenarios that are likely to come up over the lifecycle of your TDE-protected databases, such as migrating or recovering a database to another SQL Server instance. We’ll also look at some issues you should be aware of in regards to the day-to-day running of TDE, such as the impact on performance.
Migrating or Recovering a TDE-Protected Database
When encrypting a database with Transparent ...