SQL 2008 R2 Standard Edition backup encryption

Question

SQL 2008 R2 Standard Edition backup encryption

BBSR

SSCommitted

Points: 1921
More actions
December 22, 2015 at 9:42 am

#307245

I have a SQL 2008 R2 Standard edition. Is there any option to encrypt the back up file? I couldn't find any option to do that.

Viewing 4 posts - 1 through 3 (of 3 total)

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

Backup encryption without TDE is a 2014 or above feature. https://msdn.microsoft.com/en-us/library/dn449489(v=sql.120).aspx

The only thing I would suggest is to look at TDE (Transparent Data Encryption) https://msdn.microsoft.com/en-us/library/bb934049(v=sql.105).aspx

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

anthony.green (12/23/2015)
The only thing I would suggest is to look at TDE (Transparent Data Encryption) https://msdn.microsoft.com/en-us/library/bb934049(v=sql.105).aspx

Which is an Enterprise edition feature.

With Standard edition, you'll need a 3rd party backup tool to encrypt backups.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

GilaMonster (12/23/2015)
anthony.green (12/23/2015)
The only thing I would suggest is to look at TDE (Transparent Data Encryption) https://msdn.microsoft.com/en-us/library/bb934049(v=sql.105).aspx
Which is an Enterprise edition feature.
With Standard edition, you'll need a 3rd party backup tool to encrypt backups.

Sorry my bad, yep this is an Enterprise only feature, was getting confused with backup compression with reading the examples in the first link