John Esraelo
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER
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