SQLTeam.com | Weblogs | Forums

Database Encryption


#1

The Enterprise Edition of 2008 and 2012 allows for using the encryption feauture for a database. The advantage of course is increased security.
But there are some disadvantages to encrypting a database. for one, compressed backups cannot be made if the database is encrypted.
?? Can anyone give me other disadvantages to db encryption?? Thanks


#2

When you read the data,the engine has to first decrypt the data for you and then display it.It is obviously going to take more time.


#3

Thanks, so a slight performance hit. Anything else?


#4

Not encrypted between Server and Client ?