Auto encrypt new databases

Last Post 12 Sep 2012 10:53 AM by gunneyk. 5 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Oleh
New Member
New Member

--
10 Sep 2012 07:32 AM
I am using the enterprise edition with TDE. Is there a way to ensure, that newly created databases will be encrypted automatically?
Thanks in advance!
gunneyk
New Member
New Member

--
10 Sep 2012 09:54 AM
I would suspect you could create a server level trigger that would create the database TDE key but I have not tried it. TDE really should only be used where absolutely necessary so I am not sure that is a good idea anyway.
Oleh
New Member
New Member

--
11 Sep 2012 01:03 AM
Alright, I had to use TDE in this project. So there is obviously no standard way to do auto encrypt, perhaps I will try it with a trigger. Thanks for answering!
Oleh
New Member
New Member

--
11 Sep 2012 10:49 PM
Problem solved! If anyone runs into the same problem, let me know...
dbandee
New Member
New Member

--
12 Sep 2012 06:06 AM
great that you got it to work. we are not uding it yet but are looking into this also as we are expandin our enterprise and sharing more data. I 'll make sure to contact you with questions
dyakuyu
andy
gunneyk
New Member
New Member

--
12 Sep 2012 10:53 AM
Just curious did the trigger work or did you find another solution?


Acceptable Use Policy
---