Link to home
Start Free TrialLog in
Avatar of John Esraelo
John EsraeloFlag for United States of America

asked on

MSSQL: TDE ::

Hello team,

What's the best practice in setting up TDE (transparent data encryption) on a SQL server 2008 R2 for the first time?
Any information, guidance, URL links will be appreciated.
I have found various links and wanted to make sure that I am on the right track and choosing the right procedures.

thx

John E
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of John Esraelo

ASKER

Used the links and found pretty good information, additionally that is .

I am currently practicing the whole process from creation, backups, restorations, etc.  
a bit of a uncertainties comes along with any new procedure and/or processes of course and hopefully the practicing will bring that perfections as most of us believe.
So, thank you for the sharing


John E
Eugene,

I have been able to successfully backup and restore an encrypted database from one server to another.  the process included, creating and restoration of master key, certificate, backing up the encrypted objects and also restoring them at the server B ..
very smooth..
Just wanted to share that with you.
thx

John E