What are the challenges you face when working across database platforms? Take the survey
Options

Encryption with Compression

aarons44aarons44 Posts: 32
edited June 26, 2008 9:06AM in SQL Backup Previous Versions
Are the encryption and compression options mutually exclusive? I assume they are, since they always are in other software packages due to the nature of the two operations, but I wanted to confirm.

Comments

  • Options
    peteypetey Posts: 2,358 New member
    You can perform both compression and encryption together in SQL Backup.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    That is excellent news!
  • Options
    Is this true encryption of the entire file? I'm just a little skeptical, since Microsoft can't make encryption and compression work together in SQL Server 2008.
  • Options
    peteypetey Posts: 2,358 New member
    The backup data is completely encrypted. The first 1024 bytes, which contains the SQL Backup header information, is partially encrypted.

    I'm sure Microsoft is able to encrypt the entire file, but for reasons known only to them, they choose not to do so. They could have created compressed backups as far back as SQL Server 7, but again, they chose not to do so. This is because the backup SDK for third-party vendors was already available way back then.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    Thanks for the reply. Honestly, we were thinking about dropping RedGate when we moved to SQL 2008, because Microsoft is implementing compression and encryption finally, but they can't do both at the same time, which made me a little curious. Between the great support we get from RedGate, and the features of the product, we just renewed our licenses for another year.
Sign In or Register to comment.