October 27, 2011 at 3:46 am
Hi,
Is there any native way in Windows to encrypt SQL Server database backup files (other than using TDE)?
How can I use encrypting file system for this?
Thanks.
October 27, 2011 at 4:30 am
you could use BitLocker if you have Windows 7 (server 2008) and above.
I usually just compress them with a password though.
October 28, 2011 at 6:19 am
See this article, it use EFS natively from windows
http://www.sqlservercentral.com/articles/Administration/implementing_efs/870/
If you wish to encrypt backup only, you can go with VDI, but you'll need some programming knowledge to implement it. (It will avoid dumping the unencrypted backup on the file system first and leaving a security hole while encrypting)
Or use third party tools, I know redgate has one (I do not works for them)
Still TDE would be the best.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply