Pro Encryption in SQL Server 2022: Provide the Highest Level of Protection for Your Data

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

M. McGiffenPro Encryption in SQL Server 2022https://doi.org/10.1007/978-1-4842-8664-7_4

4. Managing TDE

Matthew McGiffen¹  

(1)

Bristol, UK

 

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 ...