I'm new to SQL Server TDE and have a question.
I have two VM's (VM1 = Source and VM2 = Target). On the source machine, I executed all the required steps to enable my Test database as well as backing up the certificate and private key. No issues here.
On the target machine, i executed the following t-sql commands
CREATE MASTER KEY ENCRYPTION CREATE CERTIFICATE FROM FILE WITH PRIVATE KEY( FILE DECRYPTION BY PASSWORD );
without any issue and successfully restored my Test TDE database.
On the source machine, I had to run this command
CREATE DATABASE ENCRYPTION KEY
but I didn't have to when I did the restore on the target machine. Here's my question: Is my Test database on the target machine TDE enabled?