Implementing Encrypting File System (EFS) with SQL Server

• Sam Greene

  SSCertifiable

  Points: 5252

  More actions

  August 8, 2008 at 3:43 pm

  #855557

  Good article,

  I'm assuming the same method will work with encrypting backups. Is this true?

  Can a domain admin come in an decrypt this data? I'd like this not to happen.

  Thanks!

• Sam Greene

  SSCertifiable

  Points: 5252

  More actions

  October 3, 2008 at 12:26 pm

  #880659

  For those of us who cannot restart the sql service to make this happen here is how I got this done:

  Detatch database

  Move files to new folder which you will eventually encrypt

  Reattach files

  Take DB offline

  Encrypt the folder using your sql service account

  Bring DB Online

  Encrypting the backup folder also seems to work fine.

• Sandip-31Oct

  SSC-Addicted

  Points: 494

  More actions

  October 11, 2011 at 2:59 pm

  #1393177

  Excellent Article. Thanks

  What additional steps require if there is cluster environment? on primary node it works perfectly but when i failover the sql on secondary node , encrypted database is not available.