Encrypting a whole Database

Question

 

I have been tasked with encrypting an entire database, and I need some assistance.

Everything that I have looked at leads me to believe that the only way to encrypt a whole database is to encrypt each column seperatly.  I am completely stumped and could really use some help.

Is it possible to encrypt a whole database?  if so, how?

If not, what other options do I have?

Thanks in advance for the help.

Answer 1

No, transparent encryption is targetted for SQL Server 2008. Till now you will have to use the procedure mentioned.

Jens K. Suessmeyer

---
http://www.sqlserver2005.de

---

 

Answer 2

See my first response to this thread - the question has been answered there.