SQLTeam.com | Weblogs | Forums

Database Encryption


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


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.


Thanks, so a slight performance hit. Anything else?


Not encrypted between Server and Client ?