Encrypting Complete Database

Getting started with SSIS - Part 1: Introduction to SSIS

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Home | Ask Question

Ask in the public forum

Profile

Ask your questions in a public forum

My Blog Posts

Recent Blog Posts

Encrypting Complete Database

Mar 5 2010 7:30AM |

Hi there

Here is a question related to encrypt the whole SQL Server 2008 database.

I am not much into encrypting the SQL Server 2008 database, but I am aware of encrypting and decrypting the data in a table by creating a master key, certificate and symmetric key. With my little knowledge of encryption, I feel its really difficult to encrypt all the tables of the database individually.

Could you explain me how encryption is done at the database level rather than independent table for every table.

Thanks

Sunny

SQL Server Encryption 2008

sunny.msbi

1186 · 0% · 9

1 Replies

Subscribe to Notifications

SQL Server 2008 has a great feature Transparent Data Encryption (TDE) which will take away from you the head-ache to encrypt individual tables. The encryption takes places in a completely transparent manner. I would recommend reading this: http://msdn.microsoft.com/en-us/library/bb934049.aspx

Replied on Mar 5 2010 10:29AM .

Jacob Sebastian

1 · 100% · 16868

Your Reply

Sign Up or Login to post an answer.

Managed Windows Shared Hosting by OrcsWeb