November 21, 2016 at 2:21 pm
I looked up Backup Encryption, and apparently in SQL Server 2014 it's available for the Standard Edition.
--=cf
November 22, 2016 at 2:06 am
Confirmed, Encrypted Backups are supported in Standard, BI and Enterprise editions of 2014 onwards.
A good introduction can be found from Nicolas Souquet
https://blogs.msdn.microsoft.com/mvpawardprogram/2014/06/02/sql-server-2014-backup-encryption/
For a long time, I've used GnuPG to encrypt backup files via a batch process; the downside is that the backup first needs to be written to the local disk, unencrypted. But the unencrypted version only exists momentarily (this may not be good enough for highly sensitive data). Works great for Express editions too. You still need good procedures to handle the keys.
November 22, 2016 at 8:07 am
Yikes.
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply