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

preview_player
Показать описание
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:

Рекомендации по теме
Комментарии
Автор

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.

TroyMurray
Автор

Thank you, clear and simple demonstration !!

כפיר-כו
Автор

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

MarkAzali
Автор

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

opeoluwaagboola
Автор

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.

alexwerneck
Автор

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

ashwini
Автор

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

trustnoone
Автор

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

sandeepkarki
Автор

Your tutorial helped me so much ! Thanks a lot !

slimketari
Автор

Nicely explained. Its helpful. Thanks.

nikhilvarghane
Автор

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

Narohna
Автор

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.

nikhilavalluru
Автор

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

Narohna
Автор

That mouse cursor bigger than my future

banemen
Автор

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

niteshmalani
Автор

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.

Narohna
Автор

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

rizwanyousaf
Автор

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

gabalawy
Автор

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

varunreddynagaram
Автор

Could you post that script link please

srenu
join shbcf.ru