Microsoft SQL Server upgrade to Support both Encryption and Compression at the sametime...


  • Does Microsoft plan to Upgrade SQL Server 2016 to allow both Encryption and Compression to be accomplished on a single Database Backup. ? Recently I have discovered that I can not Enable Encryption and  perform a Backup with Compression on at the same time,  insuring the Backup is both Encrypted and Compressed during a single backup...

    I am able to get a Compression Backup, so long as I disable the Encryption Feature... So the simple question is;  Does anyone know if Microsoft is going to allow a Backup to be Encrypted and Compressed within a single Database Backup operation, sometime in an upcoming Release of SQL Server... ? 

    Best Regards, 



    Monday, November 14, 2016 3:32 PM

All replies