February 3, 2014 at 1:42 pm
I just implemented TDE on one of the DB in our Prod environment, will this cause any issue if I copy the Database from QA to Prod? The DB in QA is not encrypted.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 3, 2014 at 3:56 pm
New Born DBA (2/3/2014)
I just implemented TDE on one of the DB in our Prod environment, will this cause any issue if I copy the Database from QA to Prod? The DB in QA is not encrypted.
Do you mean restore the prod database to your QA environment? If so, then yes it will read the following: http://voiceofthedba.wordpress.com/2013/08/19/restoring-a-tde-database-on-a-new-instance/
If you mean restore a QA database to prod (why are you doing this?) then no. TDE does not encrypt the instance, but the database that you specify.
February 3, 2014 at 4:27 pm
TDE is not very friendly feature.
You should have a firm reason for doing it.
Have you read the considerations, restrictions and limitations for TDE?
http://technet.microsoft.com/en-us/library/bb934049.aspx
http://technet.microsoft.com/en-us/library/ff773063.aspx
http://technet.microsoft.com/en-us/library/bb964742.aspx
Regards,
Igor
Igor Micev,My blog: www.igormicev.com
February 3, 2014 at 4:31 pm
I wouldn't say that TDE isn't user friendly.
I would say that you should have a firm grasp on it and why you are doing it before doing it.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 3, 2014 at 4:41 pm
SQLRNNR (2/3/2014)
I wouldn't say that TDE isn't user friendly.I would say that you should have a firm grasp on it and why you are doing it before doing it.
Agree. I would start with this [/url]and make sure that you know what TDE is (and isn't) and make sure that is what you want in your environment. Remember TDE is for encrypting data at rest if you are looking for encrypting column level data (SSNs, CC numbers, etc) TDE isn't the (whole) answer.
February 4, 2014 at 7:32 am
Thank you all for your reply. As far as implementing TDE is concerned, I am aware of the fact that TDE only encrypts data at rest. I have no idea what my Manager is trying to protect the data from. Its just that he wants to make sure that no body can restore the DB since its encrypted but any user can log in and access the information.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 4, 2014 at 7:45 am
New Born DBA (2/4/2014)
Thank you all for your reply. As far as implementing TDE is concerned, I am aware of the fact that TDE only encrypts data at rest. I have no idea what my Manager is trying to protect the data from. Its just that he wants to make sure that no body can restore the DB since its encrypted but any user can log in and access the information.
That would be a good enough reason for me in many cases.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply