I am looking to automate the encryption of my backups, and SQL Server 2005 does not appear to include built in functionality to do the work. Similar to the question here - Is it possible to configure SQL Server 2005 to auto-compress backups? - I am looking for a list of commonly used software to do the job

  • 2
    You pretty much got that list in mrdenny's answer to your other question.
    – squillman
    Oct 13, 2009 at 14:29
  • Your options are pay for product like SQL Backup, or your own scripts using utilities like 7zip, gpg. Choose! Oct 28, 2010 at 23:56

3 Answers 3


I have used SQL Backup from Red Gate for more than 2 years now and its awesome. It encrypts, compresses, recovers from network drop-outs and gives you object level restores from native backup files. They do a free 14 day trial, here: http://www.red-gate.com/products/SQL_Backup/index.htm

Hope you give it a go, you wont be disappointed.



Nope. Not with SQL 2005.

You might want to read over this topic: Is it possible to configure SQL Server 2005 to auto-compress backups?

A lot of those answers will apply to this one as well as compress & encrypt tend to go hand-in-hand.

  • Yes, I separated this issue out from that question, since I'm looking for a separate answer. I'll edit my question to make it clearer Oct 13, 2009 at 14:18
  • Silly me! I didn't notice you were author of both.
    – Chris_K
    Oct 13, 2009 at 14:22

With SQL 2005 you can't encrypt backups, but you can encrypt them using third party tools.

Encryption and compression don't go hand-in-hand. Encrypted files are hard to compress, so if space is a concern, you might want to compress in stead of encrypt files and protect those compressed files with a password.

  • The second paragraph was apprently in response to my answer. It might've made more sense to put it as a comment on said answer... Also, please notice the word "tend" in my answer -- but I don't currently know anyone compressing without encrypting or vice-versa
    – Chris_K
    Oct 13, 2009 at 14:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.