Implementing Encrypting File System (EFS) with SQL Server

  • 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.


  • 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.

  • 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.

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply