Encrypt Database with Transparent Data Encryption (TDE) in SQL Server 2012 [HD]

Description:
This video is about how to Encrypt SQL Server Database and Database Backup files with Transparent

Data Encryption (TDE) and how to Decrypt it and restore on other instance in SQL Server 2012 [HD].

You can join me on social networks:

[TroyMurray]

Watching this video 5 years after you created, it has aged well. You did a great job walking through each step with example SQL statements for that operation. The only thing I had hoped to see, at the end, was you querying the restored database on the second instance and see the records. Aside from that you did a fine job. The only suggested enhancement I have would be some sort of visual diagram at the outside to visually illustrate the different keys and certificates and how they correlate. That said, it's only a suggestion and even without that the points and lesson here are clear. Thank you for this.

[כפיר-כו]

Thank you, clear and simple demonstration !!

[MarkAzali]

This helped me a lot. Thanks for guiding folks that want to secure their data.

[opeoluwaagboola]

Thank you very much. Your videos are making DBAs rock stars!

[alexwerneck]

Great video. It is important to say that we need give grant permissions on the certificates and also to his private key to the service from another instance. How to do this? You need only check the security properties from files and give the read permissions on it. Thanks for share you knowledge.

[ashwini]

Thanks for this usefull video. Its simple, precise and easy to understand.excellent demonstration.

[trustnoone]

Thank you for the demo. It helped a lot for me.

[sandeepkarki]

Which edition of database r u using.my doesn't support it

[slimketari]

Your tutorial helped me so much ! Thanks a lot !

[nikhilvarghane]

Nicely explained. Its helpful. Thanks.

[Narohna]

I was able to produce the error before decryption at Video: 15:39. Any idea

[nikhilavalluru]

can't a certificate can be restored with the same certificate with out creating a new one and referencing to the file. Because in procedures if a certificate name is used and that cannot be changed to instance to instance i mean cannot modify the procedures for every instance.

[Narohna]

Sorry...I was able to produce the error before decryption at Video: 15:39. Any idea

[banemen]

That mouse cursor bigger than my future

[niteshmalani]

I have Ex4 file encrypted. so how can editing on it ? How to compile on it ? I use mt4 platform

[Narohna]

Hi Mansoor. I followed your instruction. When i tried to restore the backed up database after the encryption, the database got restored without any error on a different instance.

[rizwanyousaf]

sir what about if anyone copy mdf file and attach with on his own management studio

[gabalawy]

big thanks >>> Awesome >>>> thanks a lot :)

[varunreddynagaram]

hi manzoor what changes should we do to connection string in ADO.net to connect to this TDE encrypted database any idea ?

[srenu]

Could you post that script link please