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

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
sabarinathan
  • 21
  • 1
  • SQL Server supports this via the [Transparent Data Encryption](http://msdn.microsoft.com/en-us/library/bb934049.aspx) feature. If you have a *specific* question about how to set it up, I think serverfault.com would be a better place to ask anyway. – Dean Harding Jul 08 '10 at 05:08

2 Answers2

2

Check this might help you to achive your task :

Understanding Transparent Data Encryption

Using Transparent Data Encryption in SQL Server 2008

Pranay Rana
  • 175,020
  • 35
  • 237
  • 263
0

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
  • 39,478
  • 11
  • 80
  • 136
  • I am not sure that TrueCrypt is his answer - even though I am a long time user. TrueCrypt will create an ecrypted volume, on which he can place his databse, but he has to mount it to access it. If that is accespatable than I can say that I have used TrueCrypt for at least 5 years on both Windows & Linux and have never had a single problem. It is arguably the best product of its kind which there is. – Mawg says reinstate Monica Jul 08 '10 at 05:47
  • 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 Jul 08 '10 at 13:26