views:

68

answers:

2

I need to encrypt whole databse, not any specific column in the database. This should be done in SQL 2008 or in SQL 2008 Express edition

If any one can, do favour for this

A: 

Depending on your needs, something like TrueCrypt might do the trick, where you store your data files on an encrypted share. I've never tried it, but I would expect it to work - but some quick Googling shows that people have had problems with it. So if you try this, proceed with caution.

Joe Enos
LeonixSolutions
Yes, without more requirements, it's hard to say whether or not this would work, since it would mean mounting a drive and therefore leaving the data accessible while the drive is mounted. But if the requirement is just to have the data physically encrypted in case the hard disk is stolen, then TrueCrypt may just be all they need.
Joe Enos
+2  A: 

Check this might help you to achive your task :

Understanding Transparent Data Encryption

Using Transparent Data Encryption in SQL Server 2008

Pranay Rana