Matthew McGiffen notes how to restore a database with transparent data encryption:
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to make sure we are prepared for the scenario where something goes wrong. For instance, if the server hosting our SQL instance goes belly-up, can we recover the data that we have encrypted with TDE?
Click through to learn what you’ll need to have.