So, what can be done at this point? I don't have any option other than using a Wizard. I don't mind using PowerShell but I am not good with writing...

Well I was just reading Brad M. Mcgehee book and it says how important maintenance plan is for the environment. So, I am just going by what experts have to...

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...

Perry and Shaw, thanks for the replies, this has been enlightening! Yesterday I didn't know much about encrypting and 12 hours later I know enough to know where I should...

Which raises another question. Let's say if there is a DB which consist of 30 tables. All columns in those tables have to be encrypted. Why its not a good...

What else can be done besides implementing tde?

Well, we are storing personal private information that is confidential. The customer request this information to be encrypted both at rest and in transmission. There are not specific threats that...

I really appreciate that you guys are trying to give me the best answer possible. The problem is that I don't really know what threats we are trying to protect...

Well maybe to protect the data. We have the database up and are using it as our Customer's Development environment. We need to get the database encrypted per the customer's...

Yes. TDE is the option we are considering.

I am just going by this document that I found on google.

http://technet.microsoft.com/en-us/library/cc278098(v=sql.100).aspx

How much does it affect the performance?

I also read that it can encrypt tempdb and transactional log as well. What happens if those 2 are encrypted?

Thank you so much for replying. It did clear so many things I had in mind about min and max memory.

Thanks,