Post reply

Implementing Encrypting File System (EFS) with SQL Server

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

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

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

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

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