← Back to Knowledge Base

KB #240093: Cannot Restore from an encrypted SQL backup on a Compressed volume

⏱️ 1 min read
 

Type:

Known Issues
Summary:
Creating an encrypted SQL backup on a compressed drive appears to function properly, however you will not be able to Restore from the encrypted backup.

 

Additional Information:
Encryptionizer currently does not support creating an encrypted SQL Backup on a compressed volume or directory.The Backup appears to execute properly. However, when you attempt to Restore from the encrypted backup, you will receive an error message informing you that it is not a properly formatted backup. You will get this error even if you copy the backup file to a non-compressed volume and Restore.

As a workaround, do not attempt to Backup to or Restore from encrypted backups on a compressed volume.

In addition, Microsoft does not support SQL Database files residing on a compressed volume:
http://support.microsoft.com/kb/231347/e

 

Please note that Encryptionizer does support the encryption of Compressed SQL Backups generated by the Native SQL Backup utility.

Was this article helpful?

Related Articles

KB #240133: sp_n_codelvl shows Encrypted when database Offline and Plain when Online

Type: Known Issue. Minor. Summary: sp_n_codelvl is an optional Encryptionizer SQL Stored Procedure which can…

KB #240107: SQL Maintenance Plans do not delete encrypted database backup or transaction log backup files

Type: Fixed Summary: You have Configured/Secured your SQL Server instance with these options: Secured with…

KB #240146: This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms.

Type: Fixed. Summary: This issue has been addressed in Encryptionizer versions 2501.1.7.50217. If you have…

Still need help?

Our support team is here to assist you.

NetLib Security
AI Assistant · Online
Hi! I'm the NetLib Security assistant. I can answer questions about our encryption solutions, HIPAA compliance, Encryptionizer, and more. How can I help you today?