how do you encrypt an entire SQL 2005 database?
Using cell-level encryption will not work for my situation, so I was wondering if a Windows File encryption would work? (AKA EFS)
The database is about 30GB, and only 200K records total.
Does anyone have experince in this?
Upgrade to 2008 and use Transparent Data Encryption
answered Nov 06 '09 at 08:23 AM
Bear in mind that cell level encryption prevents prying eyes within the dB and if the physical files are moved, whereas file level encryption is more to prevent a dB being copied off the system and attached elsewhere, or using other tools to read the data.
Cell level encryption ensures that only appropraite users will be able to see what's in the dB, and only through the proper interface. Not even a curious SA could get a peek.
Make sure you understand the difference between the two and that it fits with your requirements.
And above all else when you use any kind of encryption - BACK UP ALL THE KEYS!
answered Nov 06 '09 at 12:21 PM