question

Ron 1 avatar image
Ron 1 asked

how do you encrypt an entire SQL 2005 database?

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?

Thanks Ron

sql-server-2005databaseencryption
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

·
Mark Allison avatar image
Mark Allison answered

This is a great article from Brian Kelley - I strongly recommend you have a read through it.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David 1 avatar image
David 1 answered

Upgrade to 2008 and use Transparent Data Encryption

http://technet.microsoft.com/en-us/library/bb934049.aspx

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TimothyAWiseman avatar image TimothyAWiseman commented ·
I know I am adding to this almost a year later, but I thought I should point out that TDE for SQL Server 2008 is only available in Enterprise Edition. http://technet.microsoft.com/en-us/library/cc278098(SQL.100).aspx
1 Like 1 ·
Blackhawk-17 avatar image
Blackhawk-17 answered

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!

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.