February 15, 2015 at 3:46 pm
Is the following process possible without an expensive third-party tool or using TDE?:
* Create symmetric key on database based on passphrase
* Do a full database backup encrypted by the symmetric key
These backups would be used for archival (in case they are needed for reporting purposes), not data recovery (so they're not business-essential). That's also why it would be difficult to buy ApexSQL Backup or Red-Gate SQL Backup Pro.
February 16, 2015 at 2:45 am
On SQL 2005 (this forum), no.
On SQL 2012, no.
On SQL 2014, yes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 16, 2015 at 12:49 pm
GilaMonster (2/16/2015)
On SQL 2005 (this forum), no.On SQL 2012, no.
On SQL 2014, yes.
That's embarrassing; I did a CTRL+F search for "Backup" without checking the forum title. Thanks for the information.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply