Row level Encryption

• VastSQL

  SSC-Dedicated

  Points: 36188

  More actions

  May 6, 2010 at 11:38 pm

  #222237

  Hi Experts,

  How can we achieve row level data encryption in sql server 2008?

  will it severely affect the performance?

  Is there problems when taking backup and restoring?

  Does it have any negative impact??

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  May 6, 2010 at 11:45 pm

  #1163811

  IIRC, and you have the Enterprise Edition, you would use TDE, Transparent Data Encryption. Look it up in Books Online. After reading that, any questions, come back and ask.