x

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

more ▼

asked Nov 06, 2009 at 03:49 AM in Default

Ron 1 gravatar image

Ron 1
21 1 1 1

(comments are locked)
10|1200 characters needed characters left

3 answers: sort newest

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

more ▼

answered Nov 06, 2009 at 07:33 AM

Mark Allison gravatar image

Mark Allison
479 1 1 4

(comments are locked)
10|1200 characters needed characters left

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!

more ▼

answered Nov 06, 2009 at 12:21 PM

Blackhawk-17 gravatar image

Blackhawk-17
11.9k 28 31 36

(comments are locked)
10|1200 characters needed characters left

Upgrade to 2008 and use Transparent Data Encryption

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

more ▼

answered Nov 06, 2009 at 08:23 AM

David 1 gravatar image

David 1
1.8k 1 3

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
Nov 01, 2010 at 12:50 PM TimothyAWiseman
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1950
x241
x38

asked: Nov 06, 2009 at 03:49 AM

Seen: 3234 times

Last Updated: Nov 06, 2009 at 06:24 AM