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:
Move files to new folder which you will eventually encrypt
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)